Stairway to T-SQL: Beyond The Basics Level 2: Writing Subqueries
In this level of the Beyond the T-SQL Basics stairway, we will be discussing the different aspects of a subquery.
2016-01-01 (first published: 2014-01-29)
19,144 reads
Gregory Larsen
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
6,795 reads
Stairway to T-SQL: Beyond The Basics Level 1: The TOP Clause
The first topic in this stairway will be discussing the TOP clause. The TOP clause allows you to control the number of rows to be returned or affected by a query.
2015-11-20 (first published: 2014-01-15)
23,226 reads
Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values
When you build applications that store records in SQL Server you will most likely have to store date and time values as part of the data. To manage all the different date related tasks you might need to perform Microsoft has introduced a number of date functions. In this stairway I will be exploring those date and time functions.
2015-10-21
7,997 reads
Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions
In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.
2015-09-02
9,557 reads
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,496 reads
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.
2015-05-27
15,825 reads
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.
2015-05-06
6,764 reads
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
18,989 reads
Stairway to Advanced T-SQL Level 1: Intro to Advanced T-SQL Using a CROSS JOIN
The first installment of this new stairway series will be discuss the CROSS JOIN operator. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.
2014-12-17
23,838 reads
Blogs
Achieving application consistent recovery points of SQL Server 2008 R2 with Azure Site Recovery in Azure
If you want to use ASR to replicate SQL Server 2008 R2 standalone or...
Cool Stuff in Snowflake – Part 9: ILIKE
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud...
Scalar Valued Functions in SQL Server 2019
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Query web API and return JSON data
Hello, We use a service that provides an API for pulling our real-time data....
Linked Table To MS Access error
Hello All, I have one table that is giving me problems. Access is the...
Ask SSC