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
*/