Listing 1: OpenXML's WITH Clause
/* OpenXML that uses schema from Products table */
SELECT *
FROM OpenXML(@doc,'//Item',2)
WITH Products

/* OpenXML with user-specified schema */
SELECT *
FROM OpenXML(@doc,'//Item')
WITH (XMLProductName nvarchar(40) 'Name',
      XMLCost        money        'Cost',
      XMLWeight
   nvarchar(32) 'Weight')