T-SQL Parse a String
In SQL Server, do you have a table with a column that has several values in it that […]
csv
Splitting a Large Text File
Some text files are so large that they become difficult to work with. For example, If you try […]
Text to SQL Server
While this is part 5 of this series, this will be the most simple example. I will be […]
SQL Server Count Occurrences of a Substring
How do you count the number of occurrences of a certain substring in a SQL Server varchar, and […]
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 […]