How to create a new table in a given schema?

0 Answers  

---

what is nonclustered index

0 Answers  

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

What is dirty page?

0 Answers  

---

What is the full meaning of dml?

0 Answers  

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,

---

What is primary key, unique key, and foreign key?

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 is exclusive locks?

0 Answers  

---

Distinguish between nested subquery and correlated subquery?

0 Answers  

---