/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 vote277 views1 answer
Install squirrel sql ubuntu
SQL
0 vote283 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote273 views1 answer
SQL add a totals of differemt rows of the same id
SQL
42 votes345 views6 answers
Sql query duplicate rows
SQL
0 vote267 views1 answer
How to use lower case in mysql
SQL
2 votes287 views2 answers
Postgres trigger insert into another table
SQL
0 vote289 views1 answer
Psotgres multiple values
SQL
0 vote265 views1 answer
Mysql show create db
SQL
0 vote269 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote284 views1 answer
Varchar2 length in oracle
SQL