Thank this author by sharing:
By Simon Sabin,
Retreiving data from OPENXML
How to update only columns selected using OPENXML
Using OpenXML within Dynamic SQL
SQL Server 2000 added XML support awhile back, though it was limited in what is offered and can be a...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.