/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 vote214 views1 answer
Oracle list proxy users
SQL
0 vote246 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
2 votes234 views1 answer
Sql find not in list
SQL
0 vote209 views1 answer
Postgresql update to unique
SQL
0 vote228 views1 answer
Shortcut run sql pgadmin
SQL
0 vote234 views1 answer
Sql server rtrim everything after character
SQL
0 vote226 views1 answer
Get sum sqlite android
SQL
1 vote163 views1 answer
Oracle compile schema
SQL
3 votes208 views2 answers
Plsql print
SQL
0 vote225 views1 answer
Csv to sqlite python
SQL