TSQL: importing XML data using OPENROWSET Posted by herbee on Wednesday, 19.October.2011 CREATE TABLE xml_documents( x XML ); INSERT INTO xml_documents ( x ) SELECT * FROM OPENROWSET(BULK N’myXmlFile.xml’, SINGLE_BLOB) AS x; GO Rate this: Share this:FacebookTwitterStumbleUponDiggRedditEmailLike this:LikeBe the first to like this post.