/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 vote311 views1 answer
Set Mamp mysql globally
SQL
8 votes311 views2 answers
How to fetch data from database without last column
SQL
0 vote274 views1 answer
What does the -p flag do in mysql cli
SQL
2 votes364 views2 answers
Python escape string for sql
SQL
4 votes297 views1 answer
Phone number sql
SQL
6 votes290 views1 answer
What is where clause in sql
SQL
3 votes299 views1 answer
Postgresql db owner change
SQL
0 vote316 views1 answer
Command line mysql xampp
SQL
0 vote304 views1 answer
Ajax error exception handeling
SQL
0 vote297 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL