1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

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 are the options which must be set to allow the usage of optimistic models?

1 Answers  

Can we hide the definition of a stored procedure from a use?

1 Answers  

Mention the 3 ways to get a count of the number of records in a table.

1 Answers  

Why we need sql server?

1 Answers  

How will you know when statistics on a table are obsolete?

1 Answers  

How to get nth highest salary from employee table.

1 Answers  

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

How does using a separate hard drive for several database objects improves performance right away?

1 Answers  

What is the template in sql?

1 Answers  

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

How to select some specific rows from a table in ms sql server?

1 Answers  

What is data source document?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories