Interested to Buy Any Domain ? << Click Here >> for more details...
can i write function in stored procedure and stored
procedure in function and nested procedure.Give one example
for each question?
- 1 Answers
- 9145 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / dba
You cannot define stored procedures (SP) or user-define
functions (UDF) in a nested fashion. However, you can
execute SPs and UDFs inside of stored procedures. The
nesting is limited to 32 levels deep (A calls B, which calls
C, etc). So if a recursive call is used (A calls A), you
must have some method of stopping before 32 levels is exceeded.
You can call SPs and UDFs from inside of a UDF, but this
ability is quite limited. If a SP has any side effect, it
cannot be called. So, the SP cannot be used to return any
values to the function.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between a local and a global temporary table?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Is sql server is free?
What is updatable resultset?
What happens if null values are involved in boolean operations?
What is the sql case statement used for? Explain with an example?
Explain about merge replications?
What is the maximum number of index per table?
What stored by the model? : sql server database administration
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
How to create new table with "create table" statements?
What does ss stand for sexually?
What is the maximum size per database for sql server express?
How to loop through returning rows?
What is sql sandbox in sql server?
