The Greatest of All

The basic T-SQL SELECT statement

The SQL language is used across many relational database platforms. Greg Larsen explains the basics of the SELECT statement for SQL Server.

Use Cases for WHILE and GOTO Loops with T-SQL for Time Series Data

In this article we cover situations where using a loop in T-SQL to process data for time series analysis is beneficial to get the desired results.

Checking the Type Code

A Virtual FROM Source

How many columns?

Playing popular game of Wordle using T-SQL

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.

Playing popular game of Wordle using T-SQL

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.

Adding Time

Quantifier predicates

Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL.