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 |
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is the difference between deallocate cursor and close cursor?
Can select statements be used on views in ms sql server?
What are the different normalization forms?
How do I delete a sql server database?
What are the differences between stored procedure and functions in SQL Server 2000?
25 Answers College School Exams Tests, HCL, Infosys, TCS,
Define inner join? Explain with an example?
What does the not null constraint do?
How to delete a database in ms sql server?
How to disable a login name in ms sql server?
What is an example of a primary key?
Is trigger fired implicitely?
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)