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 statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Explain can you implement data mining in ssrs?
Do you know what is rank function?
How many types of cursor type are there?
Why do we need normalization?
how to take backup bcp out for a column in table in sql server?
Tell me what is the difference between locking and multi-versioning?
What you can do to delete a table without the delete trigger firing?
What are dml (data manipulation language) statements in ms sql server?
How to provide values to stored procedure parameters in ms sql server?
What is proper subset of candidate key?
How to compare the top two records using sql?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is merge statement?
Can I save my report as html, excel or word? : sql server management studio