Answer / rajiv singh

CREATE LOGIN ra
WITH PASSWORD = 'passwd';
USE COREDATA;
CREATE USER ra FOR LOGIN ra;
GO

DROP LOGIN name

Answer / jagadeesh

create login 'name' with password='cghhicl'
GO
DROP LOGIN name

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

In which files does sql server actually store data?

0 Answers  

---

What is @@rowcount in sql?

0 Answers  

---

What is clustered index

0 Answers  

---

How to edit table in sql server 2017?

0 Answers  

---

---

How to rebuild all indexes on a single table?

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

What is difference between after and before?

0 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  

---

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

---

How to check if stored procedure is running in sql server?

0 Answers  

---