/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 vote94 views1 answer
Mysql timeout 30 seconds
SQL
13 votes134 views3 answers
Sql online code
SQL
0 vote166 views3 answers
Mysql CAST(amount as float)
SQL
0 vote120 views1 answer
Mysql sql select one day before
SQL
3 votes145 views1 answer
Oracle sql commit example
SQL
0 vote134 views1 answer
Guid string to binary better
SQL
1 vote131 views1 answer
Convert rows to string sql server
SQL
0 vote160 views2 answers
Suse Linux restart MySQL
SQL
7 votes126 views4 answers
What is my mysql version
SQL
0 vote130 views4 answers
Sql server date format yyyy-mm-dd
SQL