Gregory Larsen

Stairway to T-SQL Beyond The Basics

Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

No one wants to use more keystrokes than they have to when they write a chunk of T-SQL code. To help with minimizing the number of characters a T-SQL developer needs to type the Microsoft team introduced three new shortcuts operators when they release SQL Server 2008. These shorts cuts are the String Concatenation, Add EQUALS, and the Subtract EQUALS operators.

2016-07-15 (first published: )

13,956 reads

Stairway to T-SQL Beyond The Basics

Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function

There are times where you need to write a single T-SQL statement that is able to return different T-SQL expressions based on the evaluation of another expression. When you need this kind of functionality you can use the CASE expression or IIF function to meet this requirement. In this Stairway level Gregory Larsen reviews the CASE and IIF syntax and showing you examples of how the CASE expression and IIF function.

2016-04-20 (first published: )

16,641 reads

Stairway to T-SQL Beyond The Basics

Stairway to T-SQL: Beyond The Basics Level 5: Storing Data in Temporary Tables

There are times when retrieving data for complex business requirement requires you to temporarily store one or more results sets for a short period of time. Typically these temporary tables are stored in the scope of the current connection, but they may also need to be available across multiple connections.

2016-03-18 (first published: )

14,232 reads

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.

2015-11-25

7,122 reads

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator

The UNPIVOT operator does just the opposite of the PIVOT operator, which we looked at in the previous level. By using the PIVOT operator we can take multiple rows of data and create as single row as output. The UNPIVOT operator will take values from a single row and will create multiple rows. Microsoft introduced the UNPIVOT operator when they rolled out SQL Server 2005. In this level I will be showing you different examples of how to use the UNPIVOT operator.

2015-06-24

6,937 reads

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as column headings, where the column headings are associated with summarized values displayed below each column heading. In this article I will be exploring how to use the PIVOT operator.

4 (2)

2015-05-27

16,683 reads

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 2: Using the APPLY Operator

The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.

2015-01-28

19,620 reads

Blogs

Understanding Azure Geo-Redundant Storage

By

While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...

Prompt in ADS

By

Ever since VS Code and Azure Data Studio came out, people have been asking...

When Too Much is Not a Good Thing

By

Explore how to avoid unwanted results that oft occur due to lack of attention...

Read the latest Blogs

Forums

Do you feeling the Sheila Rashid x Air Jordan 1 Mid?

By stevenrowe98

Sheila Rashid x Air Jordan 1 Mid[/URL] sports a split color-blocking that features Purple...

Licencing Information

By Wecks

Hi Guys, I have the following question I am hoping that you guys can...

Countermeasure to stop forum spam bots

By jonas.gunnarsson 52434

There is a lot of spam from time to time. Is it possible to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers