Monday, July 4, 2011

Stored Procedures and User Defined Functions



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.





No comments:

Post a Comment