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 |
How reterive duplicate value in SQL?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Can another user execute your local temporary stored procedures?
Does index speed up select statements?
If we use where clause in the left outer join then how the query would behave/act?
What is the difference between mysql and mysqli?
List some major differences between triggers and stored procedures?
what are three different authentications to connect linked servers?
Define right outer join?
Explain about builtinadministrator?
What are the different types of locks in the database?
Scalability, Availability, Integration with internet, etc.)?
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)