禮拜五，送佛到西天 working version of sample code

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.