T-SQL Language Changes in SQL Server 2022 Part 2

Learn about more of the T-SQL language changes in SQL Server 2022 to LTRIM, RTRIM, TRIM, GET_BIT, SET_BIT, LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT and more.

Removing a Column

Another Conversion Question

More Conversion Questions

SQL WHERE Tutorial

In this article, we look at several different examples of how to use the SQL WHERE clause to narrow down searches for data in a SQL Server table.

Understanding the System Function FILEPROPERTY()

Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.

An Interesting Conversion

Saving Labor

Manage Your Business Rules in T-SQL Query

Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses.  And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]

SQL WAITFOR Command to Delay SQL Code Execution

In this article, we look at the SQL Server WAITFOR command to allow delays in processing either for a specified time or a set amount of time.