select syscolumns.*, systypes.* from syscolumns
left join systypes on syscolumns.xusertype=systypes.xusertype
where id in (select id from sysobjects where name='存储过程的名字' )
