_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › SP襷り覲一危壱願鍵
|
|
--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
鏤
|
碁一 蟇煙 (企 るΠろ) |