/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

4 votes349 views2 answers
Sql offset
SQL
0 vote348 views1 answer
Find how many tables in database sql query
SQL
1 vote327 views1 answer
Scaffold mysql database
SQL
0 vote393 views1 answer
Mysql streaming example
SQL
3 votes358 views1 answer
Get current month last date in sql server
SQL
1 vote333 views1 answer
Oracle sql create view
SQL
0 vote317 views1 answer
Get time component of datetime sql
SQL
0 vote317 views1 answer
Delete insert record in sql server
SQL
1 vote337 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote339 views1 answer
Mysql update table from select on another table
SQL