sql语句将查询的结果拼接成字符串
表样:
DECLARE @STR VARCHAR(8000)
SELECT @STR=ISNULL(@STR+',','')+userID FROM (SELECT DISTINCT userID FROM Users)AS T
SELECT @STR AS NAME
结果:
declare @output varchar(8000)
select @output = coalesce(@output + ',' , '') + userid from Users
print @output
结果:
SELECT GROUP_CONCAT(userID) as id from Users
查询结果:
一份耕耘,一份收获,付出就有回报永不遭遇过失败,因我所碰到的都是暂时的挫折