/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 vote343 views1 answer
Arithmetic expression in sql
SQL
1 vote275 views1 answer
Postgres grant read only access to database
SQL
0 vote329 views1 answer
Sql server set complex constraints
SQL
4 votes325 views1 answer
Id primary key auto generated
SQL
0 vote319 views1 answer
Sql order by number not ordered
SQL
0 vote335 views2 answers
How to get the date from datetime in mysql
SQL
0 vote326 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote355 views1 answer
Sql express database size limit
SQL
21 votes341 views1 answer
SQL cheat sheet pdf
SQL
0 vote327 views1 answer
Postgres set default schema
SQL