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

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

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  


How to locate and take substrings with charindex() and substring() functions?

0 Answers  


Explain how many normalization forms?

0 Answers  


What is buffer cash in sql server?

0 Answers  


What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,






What are the differences between local and global temporary tables?

0 Answers  


What is the native system stored procedure to execute a command against all databases?

0 Answers  


what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,


please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  


1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,


What is normalization and what are the different forms of normalizations?

2 Answers  


What are the 7 disadvantages to a manual system?

0 Answers  


Categories