SQL Server Duplicates Part 2
This discussion of finding duplicates in SQL Server is a continuation of Part 1. We will look at […]
Mike
SQL Server Duplicates Part 1
When working with databases you will often need to check if there are any duplicates in your tables. […]
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 Check If File Exists
In this post we will review a function that we have used in another post. This SQL Server […]
SQL Server xp_cmdshell
From within SQL Server you can spawn a command shell to the operating system. Therefore you can run […]
SQL Server CLR Assemblies Part 2
Functions In the previous post we created a procedure for SQL Server using the .NET framework. We chose […]
SQL Server Temp Table to Pass Data Between SProcs
Do you have a series of stored procedures in SQL Server that need to pass data between themselves? […]
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 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 […]