摘要：
SELECT(case when a.colorder=1 then d.name else '' end) N'表名',a.name N'字段名'FROM syscolumns ainner join sysobjects don a.id=d.id and d.xtype='U' and d.name<>'dtproperties'where d.name = '表名'order by object_name(a.id),a.colorder 阅读全文
posted @ 2008-01-04 15:01 小飞龙(Jack) 阅读(498) 评论(1) 推荐(0) 编辑