What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

How to change a login name in ms sql server?

0 Answers  

---

What are the different types of replication are there in sql server 2000?

0 Answers  

---

Explain throw statement in sql server 2008?

0 Answers  

---

How to configure and test odbc dsn settings?

0 Answers  

---

---

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

---

What are the differences between having and where clause.

0 Answers  

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

What is raid, and how it can influence database performance?

0 Answers  

---

What are the differences between sql server and mysql.

0 Answers  

---