The introduction of the xml data type, with its own set of methods for processing xml data, made it possible for SQL Server developers to create columns and variables of the type xml. Deanna Dicken examines the modify() method, which provides for data manipulation of the XML data stored in the xml data type via XML DML statements.

Too many SQL Servers to keep up with? Download a free trial of SQL Response to monitor your SQL Servers in just one intuitive interface."The monitoring in SQL Response is excellent." Mike Towery.