String manipulation in T-SQL code is not a new concept. I intentionally used “new” to indicate that some of the string functions discussed in this article were added after SQL Server 2016, which was the version I was using until a recent upgrade. Microsoft is constantly adding new features to SQL Server, many times itContinue reading “SQL Server: “New” String Functions”
Tag Archives: SQL Server
Snowflake: Greatest and Least Functions
In a recent post, I discussed the GREATEST and LEAST functions in SQL Server 2022. Both of these functions exist in Snowflake, but after some testing, I found that they behave differently in Snowflake than in SQL Server when dealing with NULL values. While the functions behave differently, there are options to “get around” theContinue reading “Snowflake: Greatest and Least Functions”
SQL Server: Greatest and Least Functions
Occasionally I needed to choose the greatest or least value from a set of columns during a project in SQL Server and use that value to make another decision in my logic. For example, choosing the most recent or oldest date. Depending on how the data is modeled, this could be relatively simple and useContinue reading “SQL Server: Greatest and Least Functions”
Eric Heilman 