SQL Server implementation Split function split string function and usage example _mssql

This article illustrates the function and usage of SQL Server to implement Split function split string. Share to everyone for your reference, specific as follows:

/*
function Name: F_splittonvarchar function
: To realize the function of Split function
update record:
design idea: A string that combines nvarchar type characters, Separate into a list of nvarchar types/
CREATE FUNCTION [dbo].[ F_splittonvarchar]
(
@SourceSql  NVARCHAR (MAX),--source delimited string
@StrSeprate VARCHAR (10)--Separator
RETURNS @temp TABLE (Col NVARCHAR (MAX))
as BEGIN
DECLARE @i INT
Set @SourceSql = RTRIM (LTRIM (@SourceSql))
Set @i = CHARINDEX (@StrSeprate, @ Sourcesql) while
@i >= 1
BEGIN
  inserts @temp
  VALUES
   (left
    (@SourceSql, @i-1)
   )
  SET @SourceSql = SUBSTRING (@SourceSql, @i + 1, LEN (@SourceSql)-@i)
  SET @i = CHARINDEX (@StrSeprate, @SourceSql)
end
IF @SourceSql <> '
  INSERT @temp
  VALUES
   (
    @SourceSql
   )
return
end Go

Call Example:

SELECT col from F_splittonvarchar (' 1,2,3,4 ', ', ', ');

As shown in the figure:

I hope this article will help you with your SQL Server database program.