/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

2 votes223 views1 answer
Alter table add multiple columns postgresql
SQL
1 vote231 views1 answer
Mysql decimal allow negative values?
SQL
1 vote239 views1 answer
Cannot drop database because it is currently in use
SQL
3 votes237 views3 answers
Order by postgres
SQL
1 vote242 views1 answer
Mysql select for update ejemplo
SQL
0 vote295 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
4 votes218 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote220 views1 answer
Create new table pl sql
SQL
7 votes233 views2 answers
Mysql default value
SQL
0 vote238 views1 answer
Sqlalchemy empty table
SQL