What is the use of set nocount on/off statement?

0 Answers  

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

---

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

---

What is the difference between a function and a trigger?

0 Answers  

---

What is faster join or union?

0 Answers  

---

What does truncate do?

0 Answers  

---

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

---

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---