从SELECT结果中创建varchar

DECLARE @result varchar(MAX)

SELECT 
  NAME
FROM
  Table
WHERE
  ID = @Id

@result

SELECT

@result

DECLARE @result varchar(MAX)
SET @result = \'\';

SELECT 
  @result = @result + NAME + \',\'
FROM
  Table
WHERE
  ID = @Id

SET @result = SUBSTRING(@result, 1, LEN(@result) - 1)

SELECT @result

DECLARE @CSV varchar(max)

SET @CSV = \'\'

SELECT @CSV = @CSV + Col1 + \',\' FROM Table WHERE ...

SET @CSV = LEFT(@CSV, LEN(@CSV) -1)

PRINT @CSV

declare @result varchar(max)

select @result = COALESCE(@result + \', \', \'\') + name
from table