/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

1 vote121 views1 answer
Oracle apex run 404
SQL
0 vote96 views1 answer
Sql table to store status
SQL
0 vote133 views1 answer
Oracle cpu metric
SQL
0 vote133 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote134 views1 answer
Drop column from local database postgres pgadmin
SQL
1 vote119 views2 answers
How to check username in mysql command line
SQL
0 vote126 views1 answer
Pl sql search saurce code
SQL
0 vote133 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote130 views1 answer
Mysql order by rand limit 1 really slow
SQL
16 votes143 views1 answer
Mysql smallint range
SQL