use my_db;
SET QUOTED_IDENTIFIER ON
DECLARE @xmlLocations XML
SELECT @xmlLocations = BulkColumn
FROM OPENROWSET(BULK '\my_path\my_file.xml', SINGLE_BLOB) AS x
INSERT INTO my_table
(
my_col_1,
my_col_2
)
SELECT
x.my_tag2.value ('my_tag3[1]', 'varchar(50)') AS my_col_1,
x.my_tag2.value ('my_tag4[1]', 'varchar(50)') AS my_col_2,
FROM @xmlLocations.nodes('//tag1') AS x ( my_tab )
---
Replace all the variables starting with my_ to fit your needs.
