can i write function in stored procedure and stored
procedure in function and nested procedure.Give one example
for each question?
Answer / 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 |
Explain the various types of concurrency problem?
What are the types of stored procedures in an sql server?
What is the main purpose of having conversation group?
What is the cartesian product of the table?
What is normalization 1nf 2nf 3nf?
how to select 5 to 7 rows from a table, which contains 10 rows?
What is the full meaning of dml?
Can we rewrite subqueries into simple select statements or with joins? Example?
How to Get the last identity value used
How does index makes search faster?
Can we call a function that has out parameter in select statement
What is star, snowflake and star flake schema? : sql server analysis services, ssas