我想将
XML Path的输出存储在变量中.但是这不起作用:
- 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
解决方法
尝试改变
- Select Top 1 @RetVal = Data
- From
- (
- Select ';' + ' ' + Name as 'Data'
- From @Tab t2
- for xml path('')
- ) v
至
- Select @RetVal =
- (
- Select ';' + ' ' + Name as Data
- From @Tab t2
- for xml path('')
- )