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

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

Question Posted / ankit bhatnagar

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

More SQL Server Interview Questions

What is the recovery model? List the types of recovery model available in sql server?

what is diffence between replicaion and logshipping?

Why and when do stored procedure recompile?

How to Generate a Series of Random Integers With T-SQL?

List some of the rules that apply to creating and using a ‘view’

What is difference between table aliases and column aliases? Do they affect performance?

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

What is collation sensitivity? Explain different types.

What happens if null values are involved in bitwise operations?

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

What is pivot and unpivot?

How to create a simple user defined function in ms sql server?

For more SQL Server Interview Questions Click Here