NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Template Scripts > XML > OPENROWSET

Template Script: XML\OPENROWSET.sql

CREATE TABLE #T1(XmlCol XML);

INSERT #T1
SELECT * FROM OPENROWSET(
   BULK 'C:\Temp\xmlresult8\xmlresult8.xml',
   SINGLE_BLOB) AS x

DECLARE @xml XML

SELECT
    @xml = XmlCol
FROM #T1

SELECT @xml

Description for Template Script: XML\OPENROWSET.sql

Todo