SQL XML Example - LoadFile.sql

declare

@xmlDoc xml

set

@xmlDoc = (

select

*

from openrowset

(bulk 'c:\temp\doc1.xml', single_clob)

as

a

)

select

@xmlDoc