/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

1 vote219 views2 answers
Mysql does sentance contain word
SQL
0 vote193 views1 answer
Inner joint
SQL
11 votes195 views1 answer
Mysql text type max length
SQL
0 vote191 views2 answers
Sql use not in
SQL
0 vote201 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
4 votes196 views2 answers
Oracle set date format
SQL
0 vote203 views1 answer
Query to get all primary keys and foreign key
SQL
1 vote209 views1 answer
Drop primary key oracle
SQL
3 votes206 views6 answers
DB::table('users')->get();
SQL
1 vote342 views1 answer
Sql check roles
SQL