set @groupTree.modify('insert <Group name="{sql:variable("@p_GroupName")}"/> into (//*[@name="{sql:variable("@p_ParentGroupName")}"])[1]');
报错
Msg 9303, Level 16, State 1, Procedure P_CreateGroup, Line 31
XQuery [modify()]: Syntax error near '@', expected ']'.
难道into后面是不可以用sql:variable的?
要实现这样的功能有什么办法啊?
...全文
574打赏收藏
真心求教xquery问题
set @groupTree.modify('insert into (//*[@name="{sql:variable("@p_ParentGroupName")}"])[1]'); 报错 Msg 9303, Level 16, State 1, Procedure P_CreateGroup, Line 31 XQuery [modify()]: Syntax error near '@', exp