How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

---

How to enter binary string literals in ms sql server?

0 Answers  

---

What are cursors stored procedures and triggers?

0 Answers  

---

What are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

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

2 Answers   HCL,

---

Explain primary key?

0 Answers  

---

What are the kinds of subquery?

0 Answers  

---

What happens if null values are involved in arithmetic operations?

0 Answers  

---

What is the use of group by clause?

0 Answers  

---

What are the differences between char and varchar in ms sql server?

0 Answers  

---