sql某列结果拼为一行

declare @ids varchar(max)
set @ids=''
select @ids=@ids+','+convert(varchar(10),product_id) from tblProduct where PublishToWeb=1
select @ids