andy_tigger

摘要： 执行SELECT userid FROM userinfo得到1234如果要得到1,2,3,4执行方案1DECLARE @STR VARCHAR(8000)SELECT @STR=ISNULL(@STR+',','')+userid FROM (SELECT DISTINCT userid FROM userinfo)AS TSELECT @STR执行方案2declare @output varchar(8000)select @output = coalesce(@output + ',' , '') + userid from 阅读全文