create table tb(name varchar(1))
insert into tb values('a')
insert into tb values('b')
insert into tb values('c')
go
--方法一
declare @sql varchar(1000)
set @sql = ''
select @sql = @sql + t.name from (select name from tb) as t
set @sql='select result = ''' + @sql + ''''
exec(@sql)
/*
result
------
abc
*/
--方法二
declare @output varchar(8000)
select @output = coalesce(@output , '') + name from tb
print @output
/*
abc
*/
drop table tb
SQL 一列转一行
最新推荐文章于 2024-07-23 15:38:58 发布