AzureFeeds

Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. A while back, we added […]

After discussing LEFT OUTER JOIN, you might wonder if there is also a RIGHT OUTER JOIN. There is, and it’s the reverse of the left one. […]

The next type of join that I want to discuss in these posts is a left outer join. We use this mostly, when we know that […]

There are two ways you can write common join syntax. There’s an older way to write the query and a new way to write the query. […]

The most common form of join between two tables is what’s called an inner join. In the example shown above, I’ve selected some columns from different […]

A foreign key is a situation where we store the primary key of one table in another table. It’s very useful. For example, we might need […]

In the previous post, we saw how CROSS JOIN operations work. Now it’s rare for us to want to have every combination of the rows in […]

The simplest way to join two tables is what’s called a cross-join. So this is where I say from products, cross-join, sales territories. SELECT * FROM […]

Most programming languages have some way of forming loops. Now some of them have a variety. For example, a language like Basic had a For Next […]

In general, we try to avoid procedural logic when writing T-SQL. However, it is possible. The most basic procedural statement is the IF statement. It allows […]

As well as the variables that you declare, SQL Server has a number of built-in system variables and some built-in system functions. The system variables are […]

Variables in T-SQL work very much the way they do in other languages. A variable really is nothing more than a name given to a memory […]