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

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

Can we insert data if clustered index is disabled?

0 Answers  

could u plz explain about joins and views?

2 Answers  

How many categories of functions based their return modes?

0 Answers  

What is a join in sql? What are the types of joins?

0 Answers  




What is raid? : SQL Server Architecture

0 Answers  

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

What is primary key, unique key, and foreign key?

0 Answers  

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

Explain filestream storage of sql server 2008?

0 Answers  

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers   MCN Solutions,

For more SQL Server Interview Questions Click Here
Categories