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

Answers were Sorted based on User's Feedback



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

Answer / kalyan

the above answer is partially correct, sp's can call
another sp but the levels is only upto 32.

Is This Answer Correct ?    20 Yes 1 No

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

Answer / thiyagaraj.ramaswamy

Yes, a stored procedure can call another stored procedure.
It can be controlled at any levels..

Is This Answer Correct ?    5 Yes 5 No

Post New Answer

More SQL Server Interview Questions

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,


What is transaction server auto commit?

0 Answers  


How to change a login name in ms sql server?

0 Answers  


What is the cpu pressure?

0 Answers  


What is stretch database in sql server?

0 Answers  






How many nested transaction can possible in sql server?

3 Answers   Bank Of America,


What is the difference between varchar and varchar(max) datatypes?

0 Answers  


What command is used to delete a table from the database in the sql server and how?

0 Answers  


What is mssql?

0 Answers  


How do I completely remove sql server instance?

0 Answers  


Why use stored procedures in sql server?

0 Answers  


What is normalization 1nf 2nf 3nf?

0 Answers  


Categories