/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

2 votes248 views1 answer
Create delete procedure mysql
SQL
18 votes165 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote221 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote209 views1 answer
Mysql grouping functions
SQL
14 votes195 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
1 vote202 views1 answer
Delete row mssql
SQL
0 vote207 views1 answer
Create bdd mysql
SQL
0 vote245 views1 answer
Count column of tables psql
SQL
1 vote203 views1 answer
Backup mysql data only
SQL
0 vote365 views1 answer
How to use select union and loop
SQL