SQL Server csv in xml out Project Part 3
This post continues from the previous post, Part 2. Here is the sql code that creates a new […]
xml
SQL Server csv in xml out Project Part 2
This is a continuation of the first post. Input Data Specifications – Initial Thoughts In this section we […]
SQL Server csv in xml out Project
Using SQL Server we will design a project where we process an incoming csv file and prepare an […]
SQL Server Typed XML using XSD Part 2
Just as a database has a schema, XML has a schema. The XML schema defines the structure of […]
SQL Server Table to XML Variable
This post is about working with XML in SQL Server. We are going to convert data in a […]
Transform an XML Document’s Attributes into Elements
If you have an XML document that uses attributes only, you can easily transform that document into a […]
Import XML File to Excel Part 2
This blog post continues from the previous one called Import XML File to Excel. Now, assume we have […]
Import XML File to Excel
In this blog post we follow the instruction at the MSDN website’s article Creating an XML Mapping Schema […]