#string_split() function

SQL Server 2016’s new in-built function (i.e. SPLIT_STRING()) to split the string into rows using delimiter

Hi Friends,

Hope, you are doing fine!

Today, I found the SQL Server 2016 new in-built function (SPLIT_STRING()) which will make the developer’s life more easier, when it comes to split the string into rows using some delimiter.

Earlier to MS SQL Server 2016 version, we were using either XML Path() clause to split the string or to define some custom user-defined function to achieve this task.

You…