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:

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

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........