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

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  


What are secondary xml indexes?

0 Answers  


What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  


What is a trigger? Why we need it?

0 Answers   Accenture,


what is a live lock? : Sql server database administration

0 Answers  






How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,


What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  


When would you use a before or after trigger?

0 Answers  


After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,


how can you attach more than 20 ldf files in sql server

0 Answers   IBM,


What is right outer join in sql server joins?

0 Answers  


What according to you is the difference between mysql and sql server performance?

0 Answers  


Categories