/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 vote310 views1 answer
Get statis values sql
SQL
1 vote227 views1 answer
Mysql strict_trans_tables
SQL
8 votes201 views5 answers
Alter table add column with default value
SQL
2 votes240 views1 answer
Sqlite insert if not exists
SQL
0 vote9.7K views1 answer
Postgresql delete type
SQL
0 vote224 views1 answer
Convert excel into sqllite db using python
SQL
0 vote209 views1 answer
Sqlite commands
SQL
25 votes226 views6 answers
How to change column name in mysql
SQL
0 vote251 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
10 votes193 views1 answer
Create table oracle
SQL