Stored Procedures and User Defined Functions |
What is the maximum number of parameters supported by a stored procedure or user defined function? 2100 for both |
In how many ways a stored procedure can return results? · Output parameters, which can return either data (such as an integer or character value) or a cursor variable (cursors are result sets that can be retrieved one row at a time). · Return codes, which are always an integer value. · A result set for each SELECT statement contained in the stored procedure or any other stored procedures called by the stored procedure. · A global cursor that can be referenced outside the stored procedure. |
Suppose a stored procedure declares a local temp table #temp. If it calls another stored procedure, will the #temp available to nested proc ? YES. |
Monday, July 4, 2011
Stored Procedures and User Defined Functions
Subscribe to:
Post Comments (Atom)
-
Most of the google tutorials on keras do not show how to display a confusion matrix for the solution. A confusion matrix can throw a clear l...
-
This error means you have created the DbContext but not configured/added it to the project using either DI in startup.cs or by using DbCon...
-
CONCLUSION : 1. Normally, use following two when you do not want query compilation also to come into picture. CHECKPOINT DBCC DROPCLEA...
No comments:
Post a Comment