What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

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,

---

What are the differences between union, intersect, and minus operators?

0 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

What do you mean by SQL injection attack?

0 Answers   Ittiam Systems,

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

What are various ways to enhance the ssrs report?

0 Answers  

---

What is the use of keyword with encryption.

0 Answers  

---

What is the use of @@spid?

0 Answers  

---

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

---

What is database black box testing?

0 Answers  

---