I am new to SQL sever. Can anyone help me out on how to write a nested stored procedure in sql server 2008 that has output parameters?
You may check this: Nesting Stored Procedures Although an important note to quote
Although the nesting limit is 32 levels, SQL Server has no limit on the number of stored procedures that can be invoked from a given stored procedure, provided that the subordinate stored procedures do not invoke other subordinate stored procedures and the maximum nesting level is never exceeded.
Example:
CREATE PROCEDURE [dbo].[Test1]
@ID INT,
@Emp INT
AS
BEGIN
DECLARE @x UserDefinedTableVariable
EXEC @x = Test2
@SomeID = @ID
END
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다