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 is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

What are the types of database schema? : sql server analysis services, ssas

0 Answers  

How to execute stored procedure in select statement sql server?

0 Answers  

How do I determine how many instances of sql server are installed on a computer?

0 Answers  

What do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  




Can you explain what are commit and rollback in sql?

0 Answers  

How to list all user defined functions in the current database?

0 Answers  

Do you know what is difference between index seek vs. Index scan?

0 Answers  

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

What is Trace flag?

1 Answers   Wipro,

What is the dbcc command and why is it used?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories