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
A puzzle from a health check: get the first name from full name without CHARINDEX. Here is the sample table and data, so you can try your own answer.
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 – Remove Duplicate Chars From String – Part 2
My earlier UDF used a WHILE loop to remove duplicate characters. Here is another way to Remove Duplicate chars from a string using a tally number table.
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.