/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

7 votes139 views3 answers
Postgre describe table
SQL
0 vote147 views4 answers
Mysql replace regex
SQL
19 votes131 views1 answer
Sqrt(-1)
SQL
0 vote133 views1 answer
Do postgresql
SQL
0 vote137 views1 answer
Oracle sql copy table without data
SQL
22 votes140 views4 answers
Mysql reset auto increment id
SQL
5 votes148 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote138 views1 answer
Contact mysql column field
SQL
0 vote142 views1 answer
How to find lowest in sql
SQL
2 votes192 views1 answer
Brew start postgres manual
SQL