sql有没有类似sum（string）
0
悬赏园豆：15
[待解决问题]
假如表table：
column
aa
bb
我要得到：aa，bb。能否用sql语句实现
所有回答(3)
0
IF NOT OBJECT_ID('[ZZZ]') IS NULL
DROP TABLE [ZZZ]
GO
CREATE TABLE [ZZZ](
[tid] int identity(1,1) primary key,
[title] NVARCHAR(100))
go
INSERT [ZZZ]
SELECT 'AA' UNION ALL
SELECT 'AB' UNION ALL
SELECT 'AC'
GO
----SELECT * FROM ZZZ
DECLARE @strResult Nvarchar(Max)
set @strResult=''
SELECT @strResult=[Title]+','+@strResult from ZZZ
set @strResult=substring(@strResult,1,(len(@strResult)-1))
print @strResult
/*
AC,AB,AA
*/
0
declare @s nvarchar(max)
set @s=''
select @s=@s +column + ',' from table
0
select stuff(col,1,1,'') from ( SELECT ','+COLUMN as col FROM TABLE FOR XML PATH('')) a