Written By:- Isha Malhotra
Our Website:-Tech Altum
Use of
XML in SQL Server
When we need to store data in SQL Server in
XML format .in this situation we can use XML Data Type.
For
Example:-
Create the following table to store data:-
create table XmlExample(CustID int, Prod_Detail xml);
Insetion of DATA
We can insert as
follows:-
insert
into XmlExample values(1,'<TechAltum><Product><ID>P-101</ID><Name>Mobile</Name><Price>10,000</Price></Product></TechAltum>');
or
insert into XmlExample values(2,cast('<TechAltum><Product><ID>P-102</ID><Name>AC</Name><Price>18,000</Price></Product></TechAltum>'
as XML));
Selection of DATA
select * from
XmlExample
if you run this query
then you will get following output:-
Figure 1
