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?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,


Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,


What are the two virtual tables SQL Server maintains for triggers?

3 Answers  


What is the difference between having and where clause?

4 Answers  


Explain what are the authentication modes in sql server?

0 Answers  






What r sql reporting services and analysis services? how can we use it.

2 Answers   Microsoft,


What is the meaning of resultset type_scroll_insensitive?

0 Answers  


Explain filestream storage of sql server 2008?

0 Answers  


List out the different types of locks available in sql server?

0 Answers  


what type of indexes physically sort data?

3 Answers  


What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,


Explain sp_configure commands, set commands?

3 Answers  


Categories