Wednesday, December 3, 2014

XML Value insert into table?

You can use something like the following combined with an insert to load the files into the database as XML




SELECT * FROM OPENROWSET(
BULK 'c:\SampleFolder\SampleData3.xml',
SINGLE_BLOB)

No comments:

Post a Comment