/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 vote329 views1 answer
Sqlite3 now
SQL
0 vote361 views2 answers
Mysql regexp match word
SQL
4 votes407 views6 answers
Select sql
SQL
0 vote336 views1 answer
MySQL FIND_IN_SET()
SQL
4 votes366 views4 answers
Print pl sql
SQL
1 vote334 views1 answer
Truncate table in postgresql and reset id
SQL
1 vote331 views1 answer
Stored procedure return value
SQL
0 vote342 views1 answer
2020 new year
SQL
6 votes359 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote405 views1 answer
Update mysql from paypal shopping cart and ipn
SQL