/SQL/Split string by comma in sql server

Split string by comma in sql server

CREATE FUNCTION Split
(
  @delimited nvarchar(max),
  @delimiter nvarchar(100)
) RETURNS @t TABLE
(
-- Id column can be commented out, not required for sql splitting string
  id int identity(1,1), -- I use this column for numbering splitted parts
  val nvarchar(max)
)
AS
BEGIN
  declare @xml xml
  set @xml = N'<root><r>' + replace(@delimited,@delimiter,'</r><r>') + '</r></root>'

  insert into @t(val)
  select
    r.value('.','varchar(max)') as item
  from @xml.nodes('//root/r') as records(r)

  RETURN
END
GO

Source: stackoverflow.com

Similar codes

0 vote216 views1 answer
Mysql add comment to column
SQL
0 vote214 views2 answers
Postgresql display subquery as json
SQL
0 vote217 views1 answer
Mysql coonect sample code
SQL
0 vote212 views1 answer
Automatically update database last seen datetime in sql
SQL
1 vote216 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote209 views1 answer
What is mysql_pconnect
SQL
0 vote262 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
10 votes238 views2 answers
Doublon sql
SQL
4 votes214 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
4 votes253 views1 answer
Sql delete multiple conditions
SQL