All about XML in SQL Server

SQL Server handles two types of data

1.)Relational data
2.)XML data

I have covered almost all topics about handling XML in SQL Server and posted in my site.

SECTION - 1:

      How to convert relational data to XML data ?

      answer :       use FOR XML clause

For more information about FOR XML clause, refer below link

http://www.allaboutmssql.com/2013/11/handling-xml-data-in-sql-server.html


SECTION - 2



How to traverse through XML document/fragment to fetch/modify attribute values or element nodes?

answer use XQUERY & XPATH

 How to shred XML data into columns of relational tables? 

 answer : use nodes() &  OPENXML

 How to validate structure & values of XML,each time when it is inserted/updated?

 answer : use XML SCHEMA COLLECTION

 How to improve the performance of querying XML data ?

  answer : use XML INDEX - primary & secondary index.



For more information about XQUERY,XPATH,XMLINDEX,XMLSCHEMA clause, refer below link

http://www.allaboutmssql.com/2012/09/xqueryxpathxmlschemaxml-index_6.html

1 comment:

microsoft certifications said...

Dear Web site owner. My partner and i actually enjoy this post and the internet site all in all! Your piece of writing is really plainly composed as well as simply understandable. Your current Blog design is awesome as well! Would be awesome to know where I are able obtain it. Please maintain up the very good job. We all require far more such website owners like you on the net and much fewer spammers. Fantastic mate!
http://www.sqlservermasters.com/