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

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

Explain Active/Active and Active/Passive cluster configurations

2 Answers  

What is difference between rownum and row_number?

0 Answers  

What is indexing and its types?

0 Answers  

Why use “nolock” in sql server?

0 Answers  

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

How do I create a stored procedure in dbml?

0 Answers  

Can we call future method from trigger?

0 Answers  

application server is slow what may be the problem

0 Answers   Microsoft,

How to connect to a sql server using odbc_connect()?

0 Answers  

What are logical/boolean operations in ms sql server?

0 Answers  

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories