What are the options to import XML data, which have been generated by a select for xml auto? I managed to use a simple approach using the Load Table statement, but I don't like the restriction, that Load Table will require an exclusive lock on the table.
Using openxml I don't like the necessity to provide all column types.
Is there a more easy way to insert the data generated with XML auto?
asked 30 Aug '12, 10:30
As we have customers with older SA versions than 12, we didn't use load table with xml data as that is not available before. We always used OpenXML and to my knowledge it's necessary there, to provide the data types for all columns.
answered 01 Oct '12, 07:13