/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

11 votes354 views1 answer
Oracle export view ddl
SQL
11 votes337 views5 answers
Update table from another table mysql
SQL
0 vote532 views1 answer
Get first match in each group mysql query
SQL
0 vote339 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote268 views1 answer
Mysql find foreign key references
SQL
2 votes315 views1 answer
Date conversion in mysql column
SQL
1 vote307 views1 answer
Oracle index partition
SQL
0 vote304 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
1 vote302 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote306 views1 answer
Duplicate value unique constraint mysql error
SQL