/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 vote163 views1 answer
Systems sql
SQL
2 votes151 views1 answer
Sqlite indexes
SQL
61 votes1K views6 answers
Mysql add column
SQL
0 vote143 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote152 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote167 views1 answer
Sql remove non numeric characters
SQL
0 vote159 views1 answer
Oracle concat datetime
SQL
0 vote134 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote144 views1 answer
Mysql query single row
SQL
0 vote135 views1 answer
The local psql command could not be located
SQL