A reader on SQL Server 2016 got Invalid object name STRING_SPLIT when trying the new function. Here is why the error shows up and how to fix it.
SQL SERVER – Puzzle – Get the First Name From Full Name Without CHARINDEX
This First Name From Full Name puzzle excludes CHARINDEX and SUBSTRING. It came from a customer query during a performance health check.
SQL SERVER – 2017 – How to Remove Leading and Trailing Spaces with TRIM Function?
TRIM finally arrived in SQL Server 2017. Here is how to remove leading and trailing spaces with the new TRIM function, in a few simple words.
SQL SERVER – Convert Decimal to Time Format in String
A very strange question I received the other day in an email about how to convert decimal to time format string.
SQL SERVER – Removing Duplicate String Characters with Ordered Aggregation – Part 2
I can Remove Duplicate characters while preserving their first-occurrence order. This second method uses explicit positions and ordered aggregation.
How to Insert Line Break in SQL Server String? – Interview Question of the Week #139
How do you insert a Line Break in a SQL Server string? Just press Enter inside the string, and switch SSMS results to text to see it. Here is how it works.
SQL SERVER – Understanding JSON Use is Case-Sensitive
My daughter explores every new toy, and that is how I play with JSON in SQL Server 2016. One surprise: JSON paths are case-sensitive, as this example shows.