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
- 9045 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the name of reporting services config file and what’s it’s used for?
What are translations and its use? : sql server analysis services, ssas
Explain about Normalization?
How to update multiple rows with one update statement in ms sql server?
Sql server reporting services vs. Crystal reports.
how many layers of tcp/ip protocol combined of? : Sql server database administration
how will add additional conditions in sql?
What is constraints and its types?
Explain error and transaction handling in sql server?
What is dbcc updateusage?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
How to rename databases in ms sql server?
‘Order by’ is not allowed in a view how can you sort information from a view?
What is the main purpose of having conversation group?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
