[SQL] MS-SQL PROCEDURE OUTPUT TEST

PROCEDURE OUTPUT TEST

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

-- uSP_test1
Alter        PROCEDURE uSP_test1

as

declare @test varchar(100)

execute  uSP_test2 @test output

select @test

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

-- declare @test as varchar(100)
-- execute uSP_test2 @test output
-- select @test

-- uSP_test1
Alter        PROCEDURE uSP_test2
(

 @test varchar(100) OUTPUT

)

as

select @test = max(mem_No) from ssr_member
--return @test

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO