Introduction:
Here
I will explain how to write a query to read xml
data file or read xml data type with simple example using SQL
Server.
Description:
In previous articles I explained Pass XML file as a parameter to stored procedure, read xml node
values and bind data to gridview, how to insert
and read data from xml in asp.net, Create online poll system with percentage graphs, Bind xml data to dropdownlist/gridview in asp.net . Now I will explain how to write a query to read xml
data
in SQL
Server.