TSQL字符串连接在WHILE循环中不起作用？

DECLARE @result NVARCHAR(MAX) = '';
DECLARE @separator NVARCHAR(10) = '';

DECLARE @id INT;
DECLARE @name NVARCHAR(50);

DECLARE cursor_myTable CURSOR FOR SELECT id, name FROM myTable;

OPEN cursor_myTable;

FETCH NEXT FROM cursor_myTable INTO @id, @name;

WHILE @@FETCH_STATUS = 0
BEGIN
    SET @result = @result + @separator + @name;
    SET @separator = ', ';

    FETCH NEXT FROM cursor_myTable INTO @id, @name;
END;

CLOSE cursor_myTable;
DEALLOCATE cursor_myTable;

SELECT @result AS names;

SELECT STRING_AGG(name, ', ') AS names FROM myTable;