result set에 대한 data type을 조절할 수 있다.
create procedure denali_withresultset
as
select 1 as no,'tsql' type, 'withresultset' as feature union all
select 2 as no,'tsql' type, 'throw' as feature union all
select 3 as no,'tsql' type, 'offset' as feature union all
select 4 as no,'tsql' type, 'sequence' as feature
go
exec denali_withresultset
with result sets
(
( no int,
featuretype varchar(50),
featurename varchar(50)
)
)
--결과가 다음과 같이 나오게 함
/*
no featuretype featurename
1 tsql withresultset
2 tsql throw
3 tsql offset
4 tsql sequence
*/