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.