Viewing 2 posts - 1 through 2 (of 2 total)
Sorry for the delay guys:
DECLARE @x XML
SELECT @x= CONVERT(xml, BulkColumn, 2) FROM
OPENROWSET(BULK 'C:\data.xml', SINGLE_BLOB) AS x
January 11, 2011 at 9:28 am
#1271940
FWIW, We have weekly imports of ~25MB of XML. The sp_xml_preparedocument method ran circles around the new ways (x.data.value...)
January 3, 2011 at 4:09 pm
#1268698