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

How many types of cursor type are there?

0 Answers  

How many categories of functions based their return modes?

0 Answers  

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

Explain in brief how sql server enhances scalability of the database system?

0 Answers  




When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

how we can use a database with php.

2 Answers   HCL, IT Solution,

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

What are different types of replication in sql server?

0 Answers  

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

Can you explain the role of each service?

1 Answers  

Explain cursor as data base object?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories