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
For more information about XQUERY,XPATH,XMLINDEX,XMLSCHEMA clause, refer below link
http://www.allaboutmssql.com/2012/09/xqueryxpathxmlschemaxml-index_6.html
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.
http://www.allaboutmssql.com/2012/09/xqueryxpathxmlschemaxml-index_6.html
1 comment:
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/
Post a Comment