SQL Server with input and output stored procedures

<span style= "color: #999999;" >--creating a stored procedure alter PROCEDURE DBO.ABCD       @inp  int,  --input parameter    @oup int output  --output parameter as  BEGIN      declare @num int  --Define variable    declare @numer int  --Define variable    SELECT @num = count (ZoneID) from Basic_zone wh ere ZoneID > @inp  --Query assignment    Select @num-  -print variable    set @oup = @num + @inp  --Action variable    select @oup c19/>--Print output value end--Call stored Procedure Declaration variable argument valid direct pass constant is meaningless declare @inp int SET @inp = 113EXEC dbo.abcd @inp, 1</span>

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

SQL Server with input and output stored procedures