_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › SP襷り覲一危壱願鍵

Contents



--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
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:54

碁一 蟇煙 (企 るΠろ)