Declare @Tab    dbo.SingleColumnTable
 
Insert INTO @Tab
 
Values(
    'Jack'
)
 
Insert INTO @Tab
 
Values(
    'Armageddon'
)
 
Declare @RetVal varchar(8000) = ''
 
Select Top 1 @RetVal = Data
From
(
    Select ';' + ' ' + Name as 'Data'
               From @Tab t2
               for xml path('')
) v

正如您所看到的,我正在尝试将返回的输出的列名设置为Data,但它不起作用.我收到错误列名称’数据’无效.