Вот есть такой XML
<?xml version="1.0" encoding="windows-1251" ?>
<Element BarCode="1110000101" ContentType="Договор">
<ListItem fieldName="ID" fieldValue="4274" />
<ListItem fieldName="DataAreaID" fieldType="Note" fieldValue="НС" />
<ListItem fieldName="CustGroup" fieldType="Note" fieldValue="Внутренние" />
<ListItem fieldName="CurrencyCode" fieldType="BusinessData" fieldValue="RUR" />
<ListItem fieldName="CustClassificationID" fieldType="Note" fieldValue="1" />
<ListItem fieldName="SubSegmentID" fieldType="Note" fieldValue="111" />
<ListItem fieldName="EmplID" fieldType="Note" fieldValue="Малявин Эдуард Владимирович" />
<ListItem fieldName="AccountNum" fieldType="Text" fieldValue="7706092528" />
<ListItem fieldName="Name" fieldType="Text" fieldValue="Тестирование" />
<ListItem fieldName="NameAlias" fieldType="Text" fieldValue="Тестирование" />
</Element>
Есть таблица:
CREATE TABLE [dbo].[DFArchive](
[ObjectID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[ExportDate] [datetime] NULL,
[BarCode] [nvarchar](max) NOT NULL,
[XmlDocument] [xml] NOT NULL,
[Imported] [bit] NOT NULL,
[ImportDate] [datetime] NULL,
[ImportLog] [nvarchar](max) NULL
)
Надо в поле XmlDocument поместить эту красоту. Как это сделать средствами T-SQL?