/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 vote374 views1 answer
What is database username and password in mysqliconnect
SQL
1 vote358 views1 answer
Mysql show attributes of a table
SQL
0 vote330 views1 answer
Mysql into outfile with headers
SQL
5 votes343 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote361 views1 answer
Sql query tags
SQL
0 vote362 views1 answer
Foreign key type uniqu mysql
SQL
12 votes352 views4 answers
Import mysql database command line linux
SQL
0 vote350 views1 answer
Mysqlcli how to load external sql file
SQL
14 votes421 views1 answer
How to export db from mysql
SQL
2 votes351 views1 answer
Drop all database tables oracle sql developer
SQL