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
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 |
Yes, a stored procedure can call another stored procedure.
It can be controlled at any levels..
| Is This Answer Correct ? | 5 Yes | 5 No |
Explain transaction server explicit transaction?
How to receive output values from stored procedures?
Can you explain various data region available in ssrs with their use?
How to create a large table with random data for index testing in ms sql server?
what are user defined datatypes? : Sql server database administration
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
what is victor class
How to return the top 5 rows from a select query in ms sql server?
create index a on employee(dno) In this,which index was created?
Is INSTEAD OF trigger directly applicable to Table ?
how to create a scrollable cursor with the scroll option? : Sql server database administration
How network traffic be reduced by using the stored procedure?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)