data-konzept

'Hold me now!

Richie had to break out the fainting couch when I read the release notes for SQL Server 2016 RC0. Why? WHY? Because of one thing. One thing I have watched so many people butcher and bungle over the years (even myself, in about 2009).'...

New Built-in Table-Valued Function STRING_SPLIT
STRING_SPLIT is a T-SQL function that splits input character expression by specified separator and outputs result as a table.

https://www.brentozar.com/archive/2016/03/splitting-strings-sql-server-2016-rescue/

http://sqlwithmanoj.com/2016/03/10/new-in-built-table-valued-function-string_split-in-sql-server-2016-to-split-strings/