/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

1 vote257 views1 answer
Neo4j display all nodes and relationships
SQL
1 vote257 views1 answer
Error code 1055
SQL
0 vote271 views1 answer
Every Derived yable must have its own alias
SQL
0 vote261 views1 answer
Mysql to get column name in database
SQL
0 vote278 views1 answer
PSQL use LIKE with timestamps
SQL
1 vote295 views1 answer
Homebrew install mysql
SQL
0 vote279 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
1 vote264 views1 answer
Mysql view current queries
SQL
0 vote254 views1 answer
Python mysqlclient library not found for -lssl
SQL
1 vote273 views1 answer
Change old domain to new domain name wordpress
SQL