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
- 9141 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's the difference between SQL & MY-SQl...? And what we learn from these ....?
What is the sql profiler?
How to find Duplicate Records In table?
What is a full text index?
What is @@rowcount in sql?
In which tcp/ip port does sql server run? Can it be changed?
What is delete query?
What is data source document?
Explain transaction server implicit?
your distribution database is full what will u do
What is an sql server agent?
How are the unique and primary key constraints different?
-
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)
