Differnce between sel server 2000 and 2005

3 Answers  

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

What is a transact-sql statement batch in ms sql server?

0 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

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 is sleeping status in sql server?

0 Answers  

---

How to delete duplicate rows from table except one?

0 Answers  

---

To find second largest salary in Employee table

17 Answers   CSS,

---

What is the difference between migration and upgradation in sql server?

0 Answers  

---

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

---

What are the advantages of mirroring?

0 Answers  

---

What is primary key index?

0 Answers  

---