/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 vote218 views1 answer
Sql insert from excel
SQL
0 vote173 views1 answer
Sql comparison operators
SQL
1 vote199 views1 answer
Sql convert month name to number
SQL
0 vote176 views1 answer
Check index sql server
SQL
22 votes244 views4 answers
Date format mysql
SQL
16 votes182 views4 answers
Sort by sql
SQL
0 vote192 views1 answer
Display first three characters sql
SQL
0 vote180 views1 answer
Sql period overlap
SQL
1 vote181 views1 answer
Truncate left characters mysql
SQL
0 vote180 views1 answer
Cast as decimal postgresql
SQL