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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to name query output columns in ms sql server?

536


What is trigger explain with program?

530


what is the sql equivaent of the dataset relation object ?

1565


What is the dbcc command and why is it used?

565


What is key set driven?

535






What is the difference between function and stored procedure in sql server?

481


How do I install sql server?

460


what are the different stages of Report Processing?

97


Why do we use stored procedures in sql server?

493


As per your opinion what are the five top responsibilities of a dba? : sql server database administration

608


What is the native system stored procedure to execute a command against all databases?

534


What stored by the msdb?

581


How to assign null values to variables or columns?

543


Can you index views?

498


Explain the truncate command?

518