SQLserver 表名、列名、列中文名、列类型、长度等

概述insert into XT_DDSselect a.name cTname, b.colid iNO, b.name cFname, (case when charIndex(':',CONVERT(VARCHAR(200),d.value)) = 0 then CONVERT(VARCHAR(200),d.value)

insert into XT_DDSselect a.name cTname,b.colID iNO,b.name cFname,(case when charIndex(':',CONVERT(VARCHAR(200),d.value)) = 0        then CONVERT(VARCHAR(200),d.value)        else left(CONVERT(VARCHAR(200),d.value),charIndex(':',d.value))-1) end        ) as cFPname,c.name cdataType,b.length iWIDth,'1' as bVisible,'blue' as ccolor,null as cmeno  from syscolumns b        inner join sysobjects a on a.ID=b.ID and a.xtype='U' and a.name like 'JC%'       left join systypes c on b.xtype=c.xtype         left join sys.extended_propertIEs d on b.ID=d.major_ID and b.colID=d.minor_ID select * from XT_DDS order by cTname,iNo;delete from XT_DDS;

  总结

以上是内存溢出为你收集整理的SQLserver 表名、列名、列中文名、列类型、长度等全部内容，希望文章能够帮你解决SQLserver 表名、列名、列中文名、列类型、长度等所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。