Splitting values in a string variable and inserting values as rows - II - STRING_SPLIT function

Yesterday I wrong a post on splitting string values using an Extended Function. The biggest issue with it was, unavailability in Azure SQL Database. However, we have a new function to achieve it and it works in both SQL Server 2016 and Azure SQL Database.

This is how it works;

view plainprint?

1. DECLARE @String nvarchar(4000) = 'SQL,Business Intelligence,Azure';  
2.   
3. SELECT *  
4. FROM STRING_SPLIT(@String, ',');  

DECLARE @String nvarchar(4000) = 'SQL,Business Intelligence,Azure';

SELECT *
FROM STRING_SPLIT(@String, ',');

No more complex queries for splitting values :).