循环拼接字符串

DECLARE @name NVARCHAR(MAX)
SET @name = ''
SELECT @name = @name + ',' + SrmName FROM showroom
SELECT @name