I have XML file and want to bind this XML to database table

Question

Hi Diz is Kiran I have XML file which contains data and i created a table in SQL database and im trying to bind this Xml file to database table but im not able to bind it....Can you help me..... Thanking you Advance.

Khan Abrar Ahmed · Answer

Hi Refer this links http://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/ http://stackoverflow.com/questions/10795787/importing-data-from-xml-file-to-sql-database

Abhay Shanker · Answer

Check the below link can be helpful http://blog.jontav.com/post/6811942997/querying-xml-in-sql-server http://www.campusmvp.net/blog/storing-xml-in-sql-server http://www.developer.com/db/article.php/3755106/Working-with-the-XML-Data-Type-of-SQL-Server.htm