DemoSp.sql

use a_db1
go
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Description: Show the use of a simple out ,
-- mainly for demoing calling from PowerShell.
-- =============================================
drop PROCEDURE DemoSp
go
CREATE PROCEDURE DemoSp
    -- Add the parameters for the stored procedure here
    @in int, 
    @out int out
AS
BEGIN
    SET NOCOUNT ON;
    select @out = @in * 2;
    SELECT @in, @out
 
END
GO
 
declare 
@inArg int = 21,
@outArg int
exec DemoSp @inArg, @outArg out
print 'Back in the caller [' + convert(nvarchar,@outArg) + ']';