摘要: 执行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阅读全文
posted @ 2011-07-07 10:37 车神 阅读(23) | 评论 (0) 编辑 |