/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 vote190 views1 answer
Mysql wsrep ls
SQL
1 vote148 views4 answers
Psql check tables command
SQL
7 votes146 views3 answers
Sql update where id
SQL
-1 vote140 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
10 votes153 views3 answers
Insert into auto increment mysql
SQL
0 vote174 views2 answers
MySQL PARTITION BY month automatically
SQL
9 votes156 views4 answers
How to create new user and database postgresql in ubuntu
SQL
10 votes149 views5 answers
Create table mysql query
SQL
0 vote156 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote144 views1 answer
Check index sql server
SQL