How To Declare Input-Output Parameters In SQL Server Stored Procedure/Function?
If you declare a parameter as OUTPUT, it acts as Both Input and OUTPUT
CREATE PROCEDURE SimpleInOutProcedure ( @p_InputInt INT, @p_OutputInt INT OUTPUT)ASBEGIN SELECT @p_OutputInt = @p_OutputIntENDGODECLARE @p_OutputInt int = 4EXEC SimpleInOutProcedure @p_InputInt = 1, @p_OutputInt = @p_OutputInt OUTPUTSELECT @p_OutputInt
This is sample code for SQL Input & Output parameter.
CREATE PROCEDURE [dbo].[sample_Insert]@name varchar(500),@entryby int,@RetVal INT = 0 OUTASSET NOCOUNT ONINSERT INTO dbo.Master ( name , entry_date , entry_by )VALUES ( @name , -- service_name - varchar(1000) dbo.GetActDate() , -- entry_date - datetime @entryby -- entry_by - int )IF @@ERROR = 0BEGINSET @RetVal = 1 -- 1 IS FOR SUCCESSFULLY EXECUTEDEndELSEBEGINSET @RetVal = 0 -- 0 WHEN AN ERROR HAS OCCUREDEnd set ANSI_NULLS ON set QUOTED_IDENTIFIER ON