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
- 9205 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 |
What is temporal table?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What is equi join with example?
Explain the difference between cross join and full outer join?
What is the full form of ddl?
how to delete duplicate rows in sql server2005
7 Answers Cisco, CTS, HCL, IBM,
What are the two virtual tables SQL Server maintains for triggers?
Explain having clause and where clause?
How to create a dml trigger using create trigger statements?
Why are sql functions used?
when would you go for denormalization? : Sql server database administration
Indexes are updated automatically is the full-text index also updated automatically?
-
Oracle (3253) - 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)
