1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

Question Posted / icedrop

Answers were Sorted based on User's Feedback



Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?..

Answer / nsatyabrat7

yes, we can,,create a child sp inside a parent sp...

Is This Answer Correct ?    5 Yes 0 No

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?..

Answer / satyabrat

yes, we can create ..

Is This Answer Correct ?    2 Yes 0 No

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?..

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

Post New Answer

More SQL Server Interview Questions

Why do we use functions?

0 Answers  

What is database isolation in sql server? : sql server database administration

0 Answers  

What is a full text index?

0 Answers  

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

Does partitioning ssd reduce performance?

0 Answers  




create index a on employee(dno) In this,which index was created?

2 Answers  

What is acid mean in sql server?

0 Answers  

What do you understand by triggers and mention the different types of it?

0 Answers  

Explain “row_number()” in sql server with an example?

0 Answers  

How do you check the performance of a query and how do you optimize it?

1 Answers  

How to find out what is the default collation in a database?

0 Answers  

What is the standby server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories