declare @xml xml,@handle int
declare @t table (Category varchar(20),ID int,Name varchar(20))
INSERT INTO @t SELECT null,1,null UNION SELECT null,2,nullset @xml='
<Products>
<Product Category="Book" ID="1" Name="Windows 2003" />
<Product Category="Book" ID="2" Name="VS.NET 2003" />
</Products>'Exec sp_xml_preparedocument @handle OUTPUT,@xmlUPDATE a SET Category=b.Category, Name=b.Name
FROM @t a
INNER JOIN OPENXML(@handle,'/Products/Product',1)
WITH (Category varchar(10),ID int,Name varchar(20)) b
ON a.id=b.idSELECT * FROM @t
declare @t table (Category varchar(20),ID int,Name varchar(20))
INSERT INTO @t SELECT null,1,null UNION SELECT null,2,nullset @xml='
<Products>
<Product Category="Book" ID="1" Name="Windows 2003" />
<Product Category="Book" ID="2" Name="VS.NET 2003" />
</Products>'Exec sp_xml_preparedocument @handle OUTPUT,@xmlUPDATE a SET Category=b.Category, Name=b.Name
FROM @t a
INNER JOIN OPENXML(@handle,'/Products/Product',1)
WITH (Category varchar(10),ID int,Name varchar(20)) b
ON a.id=b.idSELECT * FROM @t
FROM ...
,OPENXML...
where...
<Products>
<Product Category="Book" ID="1" Name="Windows 2003" />
<Product Category="Book" ID="2" Name="VS.NET 2003" />
</Products>' 难道这个就是XML的解析格式??