/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 vote325 views1 answer
Renommer schema sql
SQL
5 votes330 views2 answers
Sql server check port number
SQL
0 vote280 views1 answer
Mysql select top 2
SQL
0 vote381 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote343 views1 answer
Sql get count without group by
SQL
0 vote318 views1 answer
Stop psql server windows
SQL
0 vote294 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote334 views1 answer
Can't connect to postgresql mac os
SQL
0 vote332 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote281 views1 answer
Denied
SQL