Question

sql server 中如何实现将查询结果ID,返回成字符串用逗号分隔？

ID RefID
1 1
1 2
1 3
用ID1查询需要返回1,2,3

Answer 1

declare @result varchar(255)
set @result = ''

select @result = @result + cast(RefID as varchar(255)) +','
from 表
where id = 1

select left(@result,len(@result) - 1)