/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 vote145 views1 answer
Sql change column in existing table
SQL
3 votes138 views1 answer
Sql is not like
SQL
0 vote140 views1 answer
Join in update query in mysql
SQL
0 vote106 views1 answer
Oracle sysdba connect as another user
SQL
0 vote166 views1 answer
Mysql 3 months ago
SQL
0 vote127 views1 answer
Mysql add comment to column
SQL
0 vote137 views1 answer
Power query datetime to date
SQL
2 votes142 views1 answer
How to get weekday from old date in sql
SQL
0 vote134 views1 answer
Sql pad left 0
SQL
-1 vote171 views1 answer
Brisanje dupliranih konatakata
SQL