Interesting New String Functions
By Lori Brown | SQL Development , SQL Server
Here are a few new string functions that I cam across while doing some research. Just goes to show you that you learn something new every day! STRING_AGG (https://docs.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql) This function is available starting with SQL 2017. It concatenates values from rows and places your separator in between the values. Here I create a comma […]
Continue reading