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 is stored in the mssqlsystemresource database? : sql server database administration
Define synonym?
What happens if null values are involved in comparison operations?
What do you mean by a dependent functionality in a build?
Why should we go for stored procedures? Why not direct queries?
When I run the sql server 2000 setup, it just hangs. What do I do?
What is report server project?
What is a partition key?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Can we add our custom code in ssis?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is ddl and dml commands?
What is the difference between TRUNCATE and DROP?
What is the purpose of linked server configuration in sql server?
How to convert binary strings into integers in ms sql server?