Gregory Larsen

Stairway to T-SQL Beyond The Basics

Stairway to T-SQL: Beyond The Basics Level 7: Controlling the Flow of Your T-SQL

When you are writing TSQL code there are times when you want to perform the same logic over and over again. To accomplish this you can used the WHILE keyword. There are other times when you want to perform a conditional test and depending on the results of the test you execute one code block for the TRUE condition and possibly a different code block when the condition is FALSE. When you need to conditionally execute code based on the outcome of a condition you can used the IF keyword. In this Stairway level I will be discussing how to use the WHILE and IF constructs to control the flow of your TSQL code.

2014-06-25

8,806 reads

Stairway to T-SQL DML

Stairway to T-SQL DML Level 10: Changing Data with the UPDATE Statement

Unless you are working on a reporting-only application you will probably need to update tables in your SQL Server database. To update rows in a table you use the UPDATE statement. In this level we will be discussing how to find and update records in your database, and discuss the pitfalls you might run into when using the UPDATE statement.

2012-10-10

8,880 reads

Stairway to T-SQL DML

Stairway to T-SQL DML Level 11: How to Delete Rows from a Table

You may have data in a database that was inserted into a table by mistake, or you may have data in your tables that is no longer of value. In either case, when you have unwanted data in a table you need a way to remove it. The DELETE statement can be used to eliminate data in a table that is no longer needed. In this article you will see the different ways to use the DELETE statement to identify and remove unwanted data from your SQL Server tables.

2012-09-19

11,803 reads

Stairway to T-SQL DML

Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause

In this article I will be expanding on my discussion of the GROUP BY clause by exploring the ROLLUP, CUBE and GROUPING SETS operators. These additional GROUP BY operators make it is easy to have SQL Server create subtotals, grand totals, a superset of subtotals, as well as multiple aggregate groupings in a single SELECT statement.

2012-08-22

16,140 reads

Stairway to T-SQL DML

Stairway to T-SQL DML Level 2: History of Structured Query Language (SQL)

Let’s step back in time and discuss the history of Structured Query Language, or what most SQL Server professionals just shorten to SQL. Fasten your seatbelts, crank up the time machine and travel back in time to follow the history of SQL and Microsoft SQL Server from its early years to where they are today.

5 (1)

2011-10-21

12,485 reads

Stairway to T-SQL DML

Stairway to T-SQL DML Level 1: The Basic SELECT Statement

There are lots of different aspects of managing data in a SQL Server database. Before you can get into the complex management issues associated with managing application data you need to start with the basic of retrieving data from a table. To return data from a SQL Server table you use a SELECT statement. In this level I will be cover the components of the basic SELECT statement and how you can use it to retrieve data from a single SQL Server table.

4 (1)

2011-10-07

24,410 reads

Blogs

Transforming JSON data with the help of Azure Data Factory - Part 4 - Passing Arrays around

By

(2020-May-24) It has never been my plan to write a series of articles about how...

3D Printing Ear Savers

By

On April 5th, I started printing ear savers for healthcare workers. I started with...

Updated Default Settings for Azure SQL Managed Instance Databases

By

A common saying about Azure is that it is always changing. This is a...

Read the latest Blogs

Forums

Are there application developers in here? Where are you doing your SQL?

By bbsimonbb

Hi, Are there app developers in this forum? Where does your app's SQL live?...

Building Better Software for Everyone

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Better Software for Everyone

Rounding and Sums

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Rounding and Sums

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers