SQL Server Datetime
The topic of date and time in SQL Server requires more attention than any of the other data […]
Database
SQL Server csv in xml out Project Part 6
In this post we will focus on cleaning the incoming data. In our project, the stored procedure that […]
SQL Server csv in xml out Project Part 5
In this blog we will be focusing on an easier part of the program. All we need to […]
SQL Server csv in xml out Project Part 4
Importing From CSV We now need to look at importing our csv file into the tables. The stored […]
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 […]
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 […]
SQL Data Numerics
This post is based on the stairway series at SQL Server Central called Stairway to Data, by Joe […]
SQL Data Introduction
This post is based on the stairway series at SQL Server Central called Stairway to Data, by Joe […]
SQL Database Design Introduction
Over at the website SQL Server Central they have series of articles that they group into what they […]