–将列名输出为一行，用逗号分隔
select STUFF(
(select ‘,’+a.name
from syscolumns A Inner Join sysobjects D on A.id=D.id
and d.name=’tableName’ order by a.colorder for xml path(”))
,1,1,”)
Wed. Jul 22nd, 2026
–将列名输出为一行，用逗号分隔
select STUFF(
(select ‘,’+a.name
from syscolumns A Inner Join sysobjects D on A.id=D.id
and d.name=’tableName’ order by a.colorder for xml path(”))
,1,1,”)