Can a stored procedure call itself or recursive stored procedure? How many level

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

Question Posted / maheswari

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

More SQL Server Interview Questions

What are scalar functions?

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

What is the largest component inside a field?

How to delete a database in ms sql server?

sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

What are the types of backup and tell me the difference between full and differential backup?

How to enforce security in sql server? : sql server security

What is a rownum?

How to restore performance issues and how to check?

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

What is a dbms wizard?

For more SQL Server Interview Questions Click Here