Notice
Recent Posts
Recent Comments
SNOWFLAKES DRAWING PAPER
[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 ..
개발/Oracle/SQL/ERD
2008. 9. 6. 08:51