Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
Answers were Sorted based on User's Feedback
yes, we can,,create a child sp inside a parent sp...
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / saddam
I dont know whether we can create an child SP inside an Parent SP. But according to me, whenever the parent SP is called then the child SP will be getting created recursively
which should not happen.
An Child SP can be called in an parent SP but it should not get created.
| Is This Answer Correct ? | 1 Yes | 0 No |
When I delete any data from a table, does the sql server reduce the size of that table?
What is repeatable read?
What is a recursive stored procedure in sql server?
How to find the list of fixed hard drive and free space on server?
how to select 5 to 7 rows from a table, which contains 10 rows?
How to drop an existing schema in ms sql server?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is meant by Active-Passive and Active-Active clustering setup?
Explain “row_number()” in sql server with an example?
What does REVERT do in SQL Server 2005?
How do I create an extended event in sql server?
What are the underflow and overflow behaviors on float literals?
Oracle (3253)
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)