DECLARE @Output varchar(max) = ''
SELECT @Output = coalesce(@Output+',','') + CONVERT(varchar(max),Col1) FROM Table1
SET @Output = RIGHT(@Output,LEN(@Output)-1)
PRINT @Output

像这样:

like this:

SELECT GROUP_CONCAT(SenderID) FROM UserInfo