Do you know 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  

---

Can we call future method from trigger?

0 Answers  

---

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

---

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

---

What is the size of transaction log file?

0 Answers  

---

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

What is a Join and explain its types?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

what are isolation levels? : Sql server database administration

0 Answers  

---

How to enter date and time literals in ms sql server?

0 Answers  

---

What is tablesample?

0 Answers  

---

What is Left Outer Join?

2 Answers  

---