/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 vote140 views1 answer
Update from select join
SQL
0 vote133 views1 answer
How change the field place in mysql
SQL
0 vote162 views1 answer
Rails sql query converstion
SQL
1 vote118 views1 answer
Strict in postgres SQL
SQL
0 vote163 views1 answer
How to fetch data from database in sql
SQL
0 vote159 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote154 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
1 vote131 views1 answer
Set id count mysql
SQL
5 votes153 views3 answers
MySql get fields of table
SQL
1 vote161 views2 answers
Drop table with constraints
SQL