摘要: declare @myxml xmlset @myxml='<?xml version="1.0" encoding="gb2312"?> <root> <item id="1"> </item> </root>'select @myxml--1、插入item的第一个子元素 set @myxml.modify('insert <co...阅读全文

摘要: 10月25日sql:variable() binding and modify method of xquery: insert XML DML/* In SQL Server 2005, we can use sql:variable and sql:column function to bind relational data into XML by means of xquery. Howe...阅读全文