sql使用while循环进行遍历xml列时出现以下报错该如何解决

declare @row int
set @row=1
declare @totrow int
set @totrow=@data.value('count(/Workflow/Activities/Activity)','int')

while @row<=@totrow
    begin
        select 
        @result=t.c.value('(Title/Resource/text())[1]','varchar(100)')
        from @data.nodes('/Workflow/Activities/Activity['+@row+']') as t(c)
        set @row=@row+1
    end

错误信息:nodes的参数必须是字符串文字信息
错误位置:from @data.nodes('/Workflow/Activities/Activity['+@row+']') as t(c)
代码思路:先计算出有多少个节点，再循环显示节点名称,通过通过控制Activity[row]实现