In this article, we will see as how we can upload the xml file from physical drive and then parse it to tabular data. Our problem statement is say we want to upload the entire xml files that we received in one particular day. [More]

XML has become an easiest mode to exchange and transfer data. There can be a scenario when we have received data in xml format and we want to store in tabular format in one of the table that we have created in SQL Server. Below is how we can go about solving such a problem. [More]

For XML Explicit is a very complex mode but it allows to present the data in any desirable format we want. It can cause maintenance problem because queries can be very big and any change can be overwhelming. One of the advantages of Explicit mode over others is we can output column values as CDATA. [More]

In this article we will go over as how we can retrieve tabular data as XML and some XML basics. We will first go over as how we can retrieve tabular data in XML format. We will use AdventureWorks table for this. [More]