/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

17 votes388 views6 answers
Change column name in sql
SQL
8 votes374 views4 answers
Reset SQL auto increment
SQL
0 vote349 views1 answer
Query archive mode
SQL
0 vote337 views1 answer
Call function in query sql server
SQL
0 vote341 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
6 votes353 views4 answers
How to remove unique key in mysql
SQL
1 vote326 views1 answer
Foreign key in oracle sql developer
SQL
1 vote361 views1 answer
Mysql decimal allow negative values?
SQL
0 vote361 views1 answer
Double in sql server example
SQL
2 votes352 views1 answer
Node and mysql like
SQL