/**********************************************************************************************
-- Title : [2k] 프로시저에서 결과셋, Return, output 통한 반환 코드 테스트
-- Reference : dbrang.com
-- Key word : return, output, resultset 리턴 리턴값
**********************************************************************************************/
use tempdb
go
-- 프로시저 생성
if (object_id('up_ttt') is not null)
drop proc up_ttt
go
create proc up_ttt
@out char(8) = null output
as
declare @date char(8)
set @date = convert(char(8), getdate(), 112)
select @date as [Result Value]
set @out = @date
return 999
go
-- 반환 코드 확인
declare @return int
declare @output char(8)
exec @return = up_ttt @out = @output output
select @return as [Return Value], @output as [Output Value]