sql server 的xml字段操作

来源:互联网 发布:饭岛三智 知乎 编辑:程序博客网 时间:2024/05/17 23:37

外国人写的是对的


For the first error, you can tell it you are trying to set the text of the element if it is untyped.UPDATE MyTable SETxml.modify('replace value of(/root/child/grandchild/myelement/text())[1] withxs:dateTime("2002-05-30T09:30:10Z")')WHERE id = '00000000-0000-0000-0000-000000000000'


原创粉丝点击