34,576
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
lalakid 2006-07-28
- 打赏
- 举报
SELECT TYPE.[NAME]
FROM SYSCOLUMNS COL INNER JOIN SYSTYPES TYPE
ON COL.xtype = TYPE.xtype
WHERE COL.[ID] = OBJECT_ID('表')
AND COL.[NAME] = '列名'
FROM SYSCOLUMNS COL INNER JOIN SYSTYPES TYPE
ON COL.xtype = TYPE.xtype
WHERE COL.[ID] = OBJECT_ID('表')
AND COL.[NAME] = '列名'
chuifengde 2006-07-28
- 打赏
- 举报
select a.name,c.name,a.length from syscolumns a ,sysobjects b,systypes c where a.id=b.id and a.xtype=c.xtype and b.name='表名' and c.name<>'sysname'
