SQL Server Check Constraints Part 2
In this post we will look at some examples of check constraints in SQL Server. We will start […]
SQL Server
SQL Server Check Constraints Introduction
In SQL Server you will find that you need to keep control of the data that gets entered […]
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? […]