Gregory Larsen

Currently a SQL Server DBA. I've been working with SQL Server since 1999. I'm an old-time mainframe DBA. My DBA career started in 1985. Currently studying to obtaining MCDBA.

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.

4.86 (7)

2021-05-05 (first published: )

23,768 reads

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

Using a CURSOR is not normally the best way to process through a set of records. Yet when a seasoned programmer moves to writing TSQL for the first time they frequently look for ways to process a sets of records one row at a time. They do this because they are not used to thinking about processing records as a set. In order to process through a TSQL record set a row at a time you can use a cursor. A cursor is a record set that is defined with the DECLARE CURSOR statement. Cursors can be defined as either read-only or updatable. In this article I will introduce you to using cursors to do record level processing one row at a time.

4 (1)

2021-04-14 (first published: )

10,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 (4)

2021-02-10 (first published: )

19,863 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.

4 (1)

2021-01-20 (first published: )

10,845 reads

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 11: Using Logical Operators

SQL Server supports a number of different logical operators.  These operators can be used for testing Boolean conditions that return true, false and unknown in your T-SQL code.  Logical operators are useful for defining constraints to limit the rows be processed when selecting or updating data. This chapter will provide an overview of the logical […]

4 (1)

2020-11-04 (first published: )

2,700 reads

Transact-SQL: The Building Blocks to SQL Server Programming eBook by Gregory A. Larsen

Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen

Transact SQL (TSQL) is the languaged used to query and update data stored in a SQL Server. This book, written by SQL Server Central and Simple Talk author Greg Larsen, will give developers an understanding of the basics of the TSQL language. Programmers will have the building blocks necessary to quickly and easily build applications that use SQL Server.

2020-07-28

377 reads

Blogs

Nerd Journey Podcast with Nick Korte

By

I’m thrilled to have recently recorded a podcast with Nick Korte from Nerd Journey....

Daily Coping 18 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a configurable SSMS script

By

Several times over the last few weeks I’ve gotten a request to create a...

Read the latest Blogs

Forums

Hostage Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hostage Data

Multiplying Vectors in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiplying Vectors in R

Hidden Pitfalls with INNER JOIN and NOT IN Operators

By MMartin1

Comments posted to this topic are about the item Hidden Pitfalls with INNER JOIN...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers