Sql Server行转列
select STUFF((select ‘,’+ ColName from (select * from View_TableFieldInfo where TableName=‘Projects_Detail’ ) A ORDER by ColumnId FOR XML PATH(’’)),1,1,’’)
表数据如下:需要查询所有的cloname列
执行结果如下:
Sql Server行转列
select STUFF((select ‘,’+ ColName from (select * from View_TableFieldInfo where TableName=‘Projects_Detail’ ) A ORDER by ColumnId FOR XML PATH(’’)),1,1,’’)
表数据如下:需要查询所有的cloname列
执行结果如下: