获取SQL Server自定义表的字段名组合 SELECT o.name, stuff((select ','+ s.name from dbo.syscolumns s WHERE s.id=o.id ORDER BY s.colid FOR xml PATH('')), 1, 1, '') as FieldText FROM dbo.sysobjects o WHERE o.xtype='U' GROUP BY o.name,o.id,o.xtype