求大神
a表
ID
1
2
3
4
5
想查询出
显示一行 1,2,3,4,5
------解决思路----------------------
SELECT Stuff((SELECT ','+convert(varchar(11),id) FROM a for xml path('')),
1,1,'') AS result------解决思路----------------------
--SQL Server 2000 的做法
DECLARE @result varchar(8000)
SELECT @result = ISNULL(@result+',','')+convert(varchar(11),id) FROM a
SELECT @result AS result