/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 vote172 views1 answer
Convert epoch to date in sql server
SQL
1 vote169 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
3 votes144 views4 answers
Show columns from table
SQL
0 vote172 views1 answer
How to fetch unique records from two tables
SQL
0 vote179 views2 answers
Nested query
SQL
6 votes177 views1 answer
Oracle trigger after logon on database
SQL
5 votes211 views1 answer
Add column table sql default value
SQL
3 votes177 views2 answers
How to load files in mysql
SQL
3 votes182 views1 answer
Stpop start psql server
SQL
10 votes187 views4 answers
SELECT FROM WHERE
SQL