Updated: 0 sec ago
Apr 26, 2021 · As the results show, with the strings getting larger, the advantage of the CTE method increases. It should be used over the table numbers approach. Also, take into account that results depend on the hardware available on your server machine. String Split Functions in SQL Server. The SQL Server 2016 provided a new built-in function STRING_SPLIT.