/SQL/Create table split string function in sql server

Create table split string function in sql server

        
            
        
     SELECT 
    first_name, 
    last_name,
    value phone
FROM 
    sales.contacts
    CROSS APPLY STRING_SPLIT(phones, ',');

Source: sqlservertutorial.net

Similar codes

0 vote200 views1 answer
Longtext sql
SQL
0 vote200 views1 answer
Alter precision
SQL
0 vote208 views1 answer
Window function to forward fill
SQL
0 vote202 views1 answer
Select in select sql
SQL
7 votes195 views1 answer
Mysql unsafe update
SQL
0 vote224 views1 answer
How to get nth number in sql
SQL
4 votes242 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
1 vote210 views1 answer
Postgresql blocked on mac
SQL
0 vote222 views1 answer
Insert ip address in mysql
SQL
0 vote197 views2 answers
Mysql multiply
SQL