Listing 2: T-SQL Code to Create Products Table
CREATE TABLE [Products] (
    [ProductID] [int] IDENTITY (1, 1) NOT NULL ,
    [ProductName] [nvarchar] (40) NOT NULL ,
    [Cost] [money] NULL ,
    [Overflow] [text] NULL
) ON [PRIMARY]
GO

DECLARE @doc int

/* Load XML document (parse) */
EXEC sp_xml_preparedocument @doc OUTPUT, '/* replace comment with XML from 
Figure 2 */'
INSERT INTO Products (ProductName, Cost, Overflow)
SELECT XMLProductName, XMLCost, XMLOverflow
FROM OpenXML(@doc,'//Item',8)
WITH (XMLProductName nvarchar(40) 'ProductName',
      XMLCost        money        'Cost',
      XMLOverflow    text         '@mp:xmltext')
EXEC sp_xml_removedocument @doc