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

What is a partition key?

0 Answers  


What is the difference between HAVING clause and the WHERE clause?

7 Answers  


Explain sql delete command?

0 Answers  


you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  


How to get the definition of a trigger back?

0 Answers  






What gets stored inside msdb database?

0 Answers   Abacus,


How do you know if sql server is running on your local system?

0 Answers  


i need some interview questions on sql server developer plz any onee send some links.

2 Answers  


Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  


Which table keeps the locking information?

0 Answers  


Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,


What are the advantages of user defined function?

0 Answers  


Categories