t-sql
SQL 201 – CREATE TABLE
CREATE TABLE I've showed you how to get data out of a table, put data in, change it, and delete it. But I haven't showed you how to create your own table...
sql
t-sql
SQL 101 – DELETE
It looks like I'm getting close to the end of my 101 series. After I show you how to remove data from tables, the last topic I plan to cover is creating tables.
microsoft sql
SQL 101 – TRANSACTION
As I mentioned in my previous post, before you move on to more difficult topics I need to share with you what a TRANSACTION is, and how to use them. By now
t-sql
SQL 101 – INSERT
In all the previous articles I've written on SQL I've showed you how to get data out of the database. Now, we're switching gears. I'm going to show you how to
t-sql
SQL 101 – UPDATE
Previously, I showed you how to get new information into a SQL database. This time I'll show you how to make changes to that data, once it's in there. The basic
microsoft sql
Comparing Query Performance
A significant portion of your time as a database programmer or administrator will be to improve the performance of queries. While there are several benchmarks
sql
Duplicates
Duplicates. I honestly can't tell you how many times the root cause of a problem has been records in a table get repeated, where there should never be
sql
A Better sp_who2
If you've ever needed to work with sp_who2 to figure out what's going on, then you know it would be nice to be able to sort the results, right? Well, if you use
t-sql
Moving Data Between Tables
Very early into my SQL career I had to get comfortable moving records around between tables and databases. There are several ways to do it, you just have to
microsoft sql
SQL 201 – Combining Query Results
Overview There comes a point in your SQL career where you will need to combine the results of several queries into one data set, and present it in one view.
microsoft sql
SQL 101 – JOIN
Overview I want to cover a fundamental topic for SQL programming. This is the topic you should start studying right after you have a basic understanding of
microsoft sql
SQL 201 – Sub Queries
Sub queries or nested queries are complete queries wrapped inside of another complete query. Some times this technique is used as a replacement for a JOIN