Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
Answer Posted / 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 |
Post New Answer View All Answers
What are the security related catalog views? : sql server security
What is the difference between dataadapter and datareader?
How sql server executes a statement with nested subqueries?
What are three major types of constraints?
Scalability, Availability, Integration with internet, etc.)?
Explain sub-query?
What are different replication agents and what's their purpose? : sql server replication
What is the syntax for encrypting a column in SQL Server?
Which joins are sql server default?
Explain the third normal form(3nf)?
What are exact numeric data types in ms sql server?
Tell me what are the advantages of using stored procedures?
What is log cache in sql server?
can an automatic recovery be initiated by a user? : Sql server administration
Explain different types of index?