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 |
How do you identify a foreign key?
Explain how many normalization forms?
Explain the rules for designing files and file groups in sql server?
What are extended events in sql server?
How to retrieve error messages using mssql_get_last_message()?
Explain the benefits of user-defined functions?
What is field in algebra?
What is a DBMS, query, SQL?
What happens if the update subquery returns multiple rows in ms sql server?
What are the types of sql server?
Explain about Joins?
Can a table be moved to different filegroup?
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)