Bulk import XML file records in SQL Server table using a sql query

This video shows how we can use openrowset in sql server for bulk import of xml data into a database table.
This is very simple sql query which can be used for the same.

Credits:
Music: YouTube audio library

[FilipposSdralias]

Great tutorial! Thanks! What if the encoding of the xml file is iso-8859-1?

[ramyapandiyan]

iam facing some issue while executing thz query

[bogdanf]

can you share in description the final query?

[tosindanielyt]

Thanks for the video. How can one read the attributes?

[surajkalantre]

thanks but at the end only column name displays