--SQL Server 2000 的做法 DECLARE @result varchar(8000)SELECT @result = ISNULL(@result+',','')+convert(varchar(11),id) FROM aSELECT @result AS result
我倒难怪,SQL 2000下如何的搞?
3Q 搞定来,原来2000 不支持for XML 语法
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 @value1,2,3,4,5,(1 行受影响)
1,1,'') AS result
消息 170,级别 15,状态 1,第 1 行
第 1 行: 'xml' 附近有语法错误。不知道为什么
DECLARE @result varchar(8000)SELECT @result = ISNULL(@result+',','')+convert(varchar(11),id) FROM aSELECT @result AS result
我倒难怪,SQL 2000下如何的搞?
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 @value1,2,3,4,5,(1 行受影响)