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 primary key in sql server?
What are the OS services that the SQL Server installation adds?
What is the use of stored procedure?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is the main difference between ‘between’ and ‘in’ condition operators?
Explain the difference between clustered and non-clustered index?
What is key set driven?
Differences between logshipping and mirroring
what is unique and xaml nonclustered index
What is the difference between a function and a stored procedure?
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
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)