XQuery - Chinese characters
can tell me why statement fails?
set
arithabort on
update xxxxxx
set myxml.modify('insert <開關></開關> after (/instance/說明/關)[1]')
where id= 1
the error is:
xquery [xxxxxx.myxml.modify()]: syntax error near 'insert', expected identifier.
thanks!
since deal unicode characters, prefix expression n'.
here example:
beyond relational
here example:
declare @x xml select @x = n'<instance><說明><關></關></說明></instance>' set @x.modify(n'insert <開關></開關> last (/instance/說明/關)[1]') select @x /* <instance><說明><關><開關 /></關></說明></instance> */
beyond relational
SQL Server > SQL Server XML
Comments
Post a Comment