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)
Comparing features of LangGraph vs CrewAI
LangGraph Orchestration vs CrewAI Orchestration The following table compares LangGraph and CrewAI orchestration across their menta...
-
http://www.sommarskog.se/share_data.html How to Share Data Between Stored Procedures An SQL text by Erland Sommarskog, SQL Server MVP. M...
-
The evolution of LangChain has led to significant shifts in how agents are constructed, moving from the legacy AgentExecutor to the graph-b...
-
CrewAI's built-in retry mechanism distinguishes between logical errors (like a bad response format) and technical API failures (like ...
No comments:
Post a Comment