Sign Up Login


  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

How many index keys possible for a table

6 Answers  

Are null values the same as that of zero or a blank space?

0 Answers  

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

can any one please send sql quries most used in applications.

2 Answers  

Difference between Function and Procedure-in general?

6 Answers  

what are file groups?

3 Answers   Evalueserve,

How can we delete a table in sql server?

0 Answers  

How to rebuild all indexes on a single table?

0 Answers  

What are the type of Indexes? which one is best, why?

6 Answers  

What is the difference between row_number and dense_rank?

0 Answers  

how many type of indexing in database?

0 Answers   IBM,

What are different types of collation sensitivity?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories