--SP 매개변수 데이터 타입 알아내기
create proc usp_get_sp_parameter @sp_name nvarchar(255) 
as
select @sp_name sp_name, '' name, '' column_name
union all
select '', a.name as column_name,
          b.name +  
         case when b.status = 2  then '(' + convert(varchar(10),a.length) + ')'
                   when a.xtype in (106,108) then '(' + convert(varchar(10),a.xprec) + ',' +  convert(varchar(10),a.xscale) + ')'
                   else '' end  as type
from syscolumns a,systypes b 
where a.id = object_id(@sp_name)
and a.xtype = b.xtype
go

--drop proc usp_get_sp_parameter