SELECT (CASE WHEN b.colorder = 1 OR      b.colorder IS NULL THEN a.name ELSE '' END) AS N'表名', b.name AS N'字段名',       C.NAME AS N'数据类型', b.prec AS N'长度',       (CASE WHEN b.colstat = 4 THEN '√' ELSE '' END) N'是否输出',       b.colorder N'字段序号', (CASE WHEN b.colorder = 1 OR      b.colorder IS NULL THEN d .text ELSE '' END) AS N'内容'FROM sysobjects a LEFT JOIN      syscolumns b ON b.id = a.id LEFT JOIN      systypes C ON (C.xtype = B.xtype AND c.name <> 'sysname') LEFT JOIN      syscomments d ON d .id = a.idWHERE a.schema_ver = 0 AND a.xtype = 'p'ORDER BY a.name, b.colorder

评论