SQL Server Insert New XML Node at the End
This post is a simple illustration of insert an empty node at the end of an existing node. […]
SQL Server
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 XQuery Insert xml Node
How do you insert xml into a node in another xml using XQuery? This post discussed that. This […]
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 Datetime
The topic of date and time in SQL Server requires more attention than any of the other data […]
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 […]