Basic INSERT statement
Produced: 27/01/2013 14:59:00
This article is a simple and brief introduction to the INSERT statement within SQL Server. This, as the name suggests, is the method used to enter data into our databases.

Basic SELECT statement (with WHERE clause)
Produced: 20/01/2013 17:28:00
This article is a simple and brief introduction to the SELECT statement within SQL Server. This is the most basic and most useful tool in the SQL language. It allows us to see what data is being held in our databases.

As the name implies, we simply SELECT that data from a table. It’s that easy.

Basic UPDATE statement
Produced: 13/01/2013 11:29:00
Okay, we’ve inserted data, selected data, but what happens if we find some of our data is wrong? That’s where we need to UPDATE our records.

Basic OUTPUT statement
Produced: 06/01/2013 20:26:00
Within SQL Server there is a very useful clause that you can combine with all statements (INSERT, UPDATE, DELETE) in order to provide further information or details as to what’s happening… that is the OUTPUT statement.