select cast(a.name as varchar) as para,b.name from syscolumns a,systypes b where id = object_id('proc_student') and a.xtype = b.xtype /* para name ------------------------------ -------------------------------------------------------------------------------------------------------------------------------- @姓名 varchar @学号 varchar(所影响的行数为 2 行) */
select * from information_schema.parameters a ,sysobjects b where a.specific_name=b.name and xtype='P'
from syscolumns a,systypes b
where id = object_id('proc_student') and a.xtype = b.xtype
/*
para name
------------------------------ --------------------------------------------------------------------------------------------------------------------------------
@姓名 varchar
@学号 varchar(所影响的行数为 2 行)
*/