取 SQL Table 欄位的說明產生成 .NET 欄位說明

declare @tblName varchar(100) set @tblName='[dbo].[sn_Projects]’

declare @NetRepl nvarchar(max)=N’             /// <summary>             /// @Desc             /// </summary>             public object @col; ‘ declare @NetCode nvarchar(max) select @NetCode= (SELECT REPLACE(REPLACE(@NetRepl,’@Desc’,convert(nvarchar(max),Value)),’@col’,name) as [text()] FROM(select c.name,isnull(ex.value,’NULL’) value from sys.syscolumns c LEFT  JOIN  sys.extended_properties ex  ON  ex.major_id = c.id     AND ex.minor_id = c.colid      AND ex.name = ‘MS_Description’  WHERE      OBJECTPROPERTY(c.id, ‘IsMsShipped’)=0 and id=OBJECT_ID(@tblName) )t for xml path(“))

select Replace(Replace(Replace(@NetCode,’ ’,"),’&lt;’,'<‘),’&gt;’,’>’)

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s

%d 位部落客按了讚: