DOS Command to Append Text to a File
You may have a need to append some text to a file. Suppose you have an existing file […]
Blog
SQL Server Constraints Introduction
SQL Server has several types of constraints. But what is a constraint? Why do you need them? Which […]
SQL Server Drop a Table If Exists
Sometimes when you are looking for sql code online you find that people give example code that includes […]
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 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. […]