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 |
what are constraints? : Sql server database administration
Explain about extended stored procedure?
Tell me about Triggers?
Define outer join in sql server joins?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What do you understand by coalesce in sql server?
How fixed length strings are truncated and padded?
What is the difference between locking and multi-versioning?
Are connections to sql server encrypted?
How do I find the port number for sql server?
What is the difference between createstatement and preparedstatement?
How to compare the top two records using sql?