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
- 9044 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
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 |
Why use sub query in sql server and list out types of sub queries?
Explain the difference between clustered and non-clustered index?
What are the benefits of normalization?
What are the different editions available in sql server 2000?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What are the types of user defined functions in sql server?
How To delete duplicate record from a particular table?
How do I connect to sql server database?
Define msdb database?
Explain error and transaction handling in sql server?
What is sql server management studio? : sql server management studio
What are the different type of replication in sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
