“Life isn’t about finding yourself.....Life is about creating yourself.”
Monday, August 29, 2011
How to Parse XML data using XML type?
We can parse xml data by using
.query()
method or by
.value()
method.
XML type is having 2 more methods
1.
nodes()
->This method will return each node of xml file.
2.
exist()
->This method is quite similar to IF Exists method of sql server.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment