SQL

Using the INSERT statement

For this demonstration we will use the HR.Employees table that we created in the post on Table Constraints. We will begin with just a simple INSERT statement that…


Data Manipulation Language (DML)

For this demonstration on Data Manipulation Languare (DML) statements we will create a table named dbo.TestTable with four columns. Then we will be using the INSERT statement to add…


SQL Join Types

When pulling data from more than one table you will need to JOIN the tables together. The JOIN types will determine what records will be returned in the…


Indy PASS 10th Anniversary

It’s the Indy PASS 10th Anniversary Summer BBQ! Join us for an evening of fun, networking and like every month you are bound to learn a…


DML Triggers

There are two types of DML Triggers that can be written for each INSERT, UPDATE, or DELETE statement. Either AFTER triggers or INSTEAD OF triggers. The…


SQL Table Constraints

When creating tables you would want to use constraints to enforce data integrity. In the picture above you can see a list of the constraints…


Working with SQL Tables

In this demonstration we will be using Data Definition Language (DDL) statements to Create, Alter, and Drop a Table. The first step in creating a table…


SQL Server Categories

The Transact-SQL language is split up into four SQL Categories Data Manipulation Language (DML) – These statements allow you to manipulate the data within your tables….


SQL Server 2016 Public Preview

SQL Server 2016 public preview now available! Three weeks ago at Microsoft Ignite the next major release of Microsoft’s flagship database and analytics platform was announced….