/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

7 votes115 views1 answer
Minecraft forge server host
SQL
3 votes118 views2 answers
Check data in table mysql
SQL
7 votes121 views1 answer
Sql pagination oracle
SQL
0 vote120 views2 answers
Identity column in sql server
SQL
5 votes108 views2 answers
Postgre insert select
SQL
1 vote115 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote158 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote106 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote124 views1 answer
How to check common records in 2 table
SQL
0 vote105 views1 answer
Alter table fulltext
SQL