SQL Server Course at Udemy Philip Burton
If you like watching videos to learn topics, consider Udemy.com This post is about a series of videos […]
sql
SQL Server Duplicates Part 2
This discussion of finding duplicates in SQL Server is a continuation of Part 1. We will look at […]
SQL Server Export to Excel
https://www.microsoft.com/en-us/download/details.aspx?id=23734 Wizard From within SQL Server you can use the wizard to export a tables or tables (using […]
SQL Server csv in xml out Project Part 12
Create an Empty xml File Here we need to simply create an empty xml file. The file will […]
SQL Server csv in xml out Project Part 11
Create XML From Tables What we have in the input file is shown below. After that, we show […]
SQL Server csv in xml out Project Part 8
Part 8 usp_15NoDuplicateOrders
SQL Server csv in xml out Project Part 7
This is the code for usp_11CheckIfFileExists in our I Love Books project. Before looking at all of the […]
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 […]