/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

3 votes134 views1 answer
Postgres select max value
SQL
0 vote158 views1 answer
Sql query to select even numbers
SQL
0 vote123 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote111 views1 answer
Sql remove last x char
SQL
0 vote111 views1 answer
Dbms_output sql developer
SQL
0 vote134 views1 answer
Java nosql sort
SQL
1 vote115 views1 answer
Mysql select if empty result
SQL
29 votes115 views5 answers
Mysql show table structure
SQL
0 vote120 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
2 votes155 views1 answer
Sql compare strings
SQL