In general, we try to avoid procedural logic when writing T-SQL. However, it is possible. The most basic procedural statement is the IF statement. It allows […]
As well as the variables that you declare, SQL Server has a number of built-in system variables and some built-in system functions. The system variables are […]
One of the most popular courses that we used to run in person was a Query Performance Tuning and Advanced T-SQL course. I recently finished converting […]