
USE [SodaDB]
go

-- Insert an order
INSERT INTO order_form_temp(order_form_xml)
SELECT * FROM OPENROWSET(
   BULK 'C:\Labs\L08_XML\Solution\XMLDataType\order1.xml',
   SINGLE_BLOB) AS x
go

-- FIRST DOCUMENT LOADED

SELECT * FROM order_form_temp

-- SELECTED ROW CONTAINING DOCUMENT

-- Attempt to buy more than one product at a time
-- Fails
INSERT INTO order_form_temp(order_form_xml)
SELECT * FROM OPENROWSET(
   BULK 'C:\Labs\L08_XML\Solution\XMLDataType\order2.xml',
   SINGLE_BLOB) AS x
go

