34,576
社区成员
发帖
与我相关
我的任务
分享
declare @value varchar(200);
set @value='';
--下面的cte只是模拟数据
;with cte as(
select 1 as n
union all
select n+1 from cte where n<5
)
----------cte end
select @value=@value+cast(n as varchar)+','
from cte
select @value
1,2,3,4,5,
(1 行受影响)--SQL Server 2000 的做法
DECLARE @result varchar(8000)
SELECT @result = ISNULL(@result+',','')+convert(varchar(11),id) FROM a
SELECT @result AS result
SELECT Stuff((SELECT ','+convert(varchar(11),id) FROM a for xml path('')),
1,1,'') AS result