sql 字符串拼接 =>for xml()

USE [DC_COILS]
DECLARE @a NVARCHAR(max)=''
SELECT @a =@a + aaa+'<br>' FROM Table
SELECT @a