Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Loading XML Data into SQL Server (SQL Spackle) RE: Loading XML Data into SQL Server (SQL Spackle)
weharrelson
Grasshopper
Points: 23
More actions
January 11, 2011 at 9:28 am
#1271940
Sorry for the delay guys:
DECLARE @x XML
SELECT @x= CONVERT(xml, BulkColumn, 2) FROM
OPENROWSET(BULK 'C:\data.xml', SINGLE_BLOB) AS x