/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 vote140 views1 answer
Select count concat string sql server
SQL
2 votes118 views1 answer
Sql server case sensitive search
SQL
0 vote124 views2 answers
How to update the multiple rows in sql
SQL
0 vote117 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
1 vote123 views1 answer
Operator does not exist: integer = text
SQL
0 vote136 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
1 vote128 views1 answer
Sql server today minus n
SQL
0 vote123 views1 answer
Python mysql executemany
SQL
0 vote120 views1 answer
Use mysql in java program
SQL
0 vote116 views1 answer
How to fix mysql stop unexpectedly
SQL