/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

1 vote238 views1 answer
Key validation sql
SQL
0 vote194 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote340 views1 answer
Sqlite display data in separated columns
SQL
1 vote188 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote190 views2 answers
Script all indexes in a database
SQL
0 vote234 views1 answer
Sql select without column name
SQL
1 vote197 views1 answer
Mysql select from outside
SQL
0 vote146 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
1 vote194 views2 answers
Extract weekday from date in sql
SQL
0 vote244 views1 answer
Get foreign table names mysql
SQL