/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 vote175 views1 answer
Ms sql - add one hour to time
SQL
1 vote237 views1 answer
Spark sql concatenate string and int
SQL
1 vote236 views1 answer
Mysql current running queries
SQL
2 votes230 views1 answer
Datetrunc
SQL
0 vote234 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
11 votes231 views5 answers
How to install sqlite3 python
SQL
2 votes276 views1 answer
Python sql
SQL
0 vote228 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote231 views1 answer
Mysql decimal allow negative values?
SQL
0 vote239 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL