Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
Answers were Sorted based on User's Feedback
yes, we can,,create a child sp inside a parent sp...
Is This Answer Correct ? | 5 Yes | 0 No |
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 |
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
How to locate and take substrings with charindex() and substring() functions?
Explain how many normalization forms?
What is buffer cash in sql server?
What are triggers? How do you invoke a trigger on demand?
What are the differences between local and global temporary tables?
What is the native system stored procedure to execute a command against all databases?
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
1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
What is normalization and what are the different forms of normalizations?
What are the 7 disadvantages to a manual system?