Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

How real and float literal values are rounded?

0 Answers  

What is dimension table? : sql server analysis services, ssas

0 Answers  

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

What is split brain scenario in DB mirroring?

1 Answers  

What are synonyms?

0 Answers  

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

What is data integrity? Explain constraints?

1 Answers   Thinksoft,

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

What are the advantages of log shipping?

0 Answers  

What is the difference between having and where clause?

4 Answers  

What happens if we shrink log file in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories