Answers for "sql split"

SQL
1

sql server 2016 split string

SELECT value FROM STRING_SPLIT('Lorem ipsum dolor sit amet.', ' ');
Posted by: Guest on January-27-2021
0

create table split string function in sql server

SELECT 
    first_name, 
    last_name,
    value phone
FROM 
    sales.contacts
    CROSS APPLY STRING_SPLIT(phones, ',');
Posted by: Guest on December-07-2020
1

sql split string by space

SELECT SUBSTRING('please notify the sender at the e-mail address above',0,30 +
charindex(' ',SUBSTRING('please notify the sender at the e-mail address above',31,len('please notify the sender at the e-mail address above')))
 )
 as part1,
 
 SUBSTRING('please notify the sender at the e-mail address above',30+ charindex(' ',SUBSTRING('please notify the sender at the e-mail address above',31,len('please notify the sender at the e-mail address above'))),len('please notify the sender at the e-mail address above')) as part2
Posted by: Guest on January-04-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language