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
How do I start sql server?
What is the difference between a clustered index and a non-clustered index?
Explain primary key and foreign key constraints?
What new data source types were added in ssrs 2014?
How can sql injection be stopped? : sql server security
When columns are added to existing tables, what do they initially contain?
How can you start sql server in different modes?
What does top operator do?
What do you mean by an execution plan? Why is it used? How would you view it?
How to download and install the scaled-down database adventureworkslt?
What is the usage of the sign function?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
How can a database be repaired?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is table valued function and scalar valued functions?