/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

4 votes316 views3 answers
Sql drop database if exists
SQL
2 votes317 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote335 views2 answers
Check if sql temp table exists
SQL
0 vote291 views1 answer
Get yesterday date ISO in psql
SQL
12 votes348 views4 answers
How to drop all tables in postgresql
SQL
33 votes292 views2 answers
Postgres how to add field created at
SQL
0 vote314 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote281 views1 answer
Oracle sqlp update amount / quantity
SQL
2 votes291 views1 answer
No data found oracle
SQL
0 vote289 views2 answers
Sql if empty then
SQL