select syscolumns.*, systypes.* from syscolumns
left join systypes on syscolumns.xusertype=systypes.xusertype
where id in (select id from sysobjects where name='存储过程的名字' )
select syscolumns.*, systypes.* from syscolumns
left join systypes on syscolumns.xusertype=systypes.xusertype
where id in (select id from sysobjects where name='存储过程的名字' )
转载于:https://www.cnblogs.com/kuang/archive/2012/07/19/2599347.html