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
Powered by: 博客园 Copyright © 2024 小飞龙(Jack) Powered by .NET 8.0 on Kubernetes