MY_XML.record.query ('id' ) . value ('.', 'BIGINT' ), MY_XML.record.query ('first_name' ) . value ('.', 'VARCHAR (100)'), MY_XML.record.query ('last_name' ) . value ...

This screenshot lists the source of a SQL Server 2014 stored procedure ... working source illustrates how easy it is to INSERT XML data into temp tables and table variables, allowing even greater ...

This generic SSIS script code loads any complex XML data into SQL Server Database. The table structure based on the XML structure is created dynamically and the data is loaded. There is an option of ...