Watch this example on YouTube:
1. Here is my first sp:
CREATE PROCEDURE [dbo].[TestOutput_Procedure1]
@Success int = 0 Output
AS
BEGIN
SET NOCOUNT ON;
SET @Success = 1;
Return @Success;
END
2. Second one
CREATE PROCEDURE [dbo].[TestOutput_Procedure2]
AS
BEGIN
SET NOCOUNT ON;
Declare @Success int = 0;
Exec TestOutput_Procedure1 @Success
OUTPUT;
Select @Success;
END
3. Test
Exec TestOutput_Procedure2;
No comments:
Post a Comment