–将列名输出为一行,用逗号分隔
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,”)
一个专注于IT技术分享的网站
–将列名输出为一行,用逗号分隔
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,”)