sql server split string

is only necessary to use the default keyword.2 Select * fromSplit (default,'123,456,789')3 4 Select * fromSplit (default,'123,456,789,')5 6 --Try other character segmentation below7 Select * fromSplit ('ABC','11111abc22222abc33333')8 9 Select * fromSplit ('ABC','11111ABC22222ABC33333ABC')The disadvantage is that you cannot directly act on a table, and you cannot support multi-character segmentation at the same time.Of course, if more than a few parameters, but also reluctantly, but I would

--Description: Splitting a string function--SELECT * FROM dbo. Split (' a,b,c,d,e,f,g ', ', ')-- =============================================CREATE FUNCTION [dbo].[Split](@Text VARCHAR(8000) ,@Sign NVARCHAR(4000) ) RETURNS @tempTable TABLE(IDINT IDENTITY(1,1)PRIMARY KEY,[TempVal] VARCHAR(4000) ) as BEGIN DECLARE @StartIndex INT --where to start looking D

SelectValue fromTf_njvalues ('3c457a2d-188b-4d99-a822-2968054e1fb8,3c457a2d-188b-4d99-a822-2968054e1fb8')CREATE FUNCTIONTf_njvalues (@P0 varchar(Max)--characters that need to be intercepted) RETURNS @OUT_TABLE TABLE(ValueVARCHAR(Max)) as BEGIN DECLARE @SQL varchar(Max), @output varchar( -) Set @P0= Case when Right(@P0,1)=',' Then @P0 Else @P0+',' End while CHARINDEX(',',@P0)>0 begin Set @output=left(@P0,CHARINDEX(',',@P0)-1) I

Tags: substring ret div character Zid insert case when tab substrCREATE FUNCTION Dbo.sf_ds_splitnvarchar(@strValues nvarchar (4000))RETURNS @tblStrList TABLE (id int identity (), value nvarchar (4000))AsBEGINdeclare @strTmp nvarchar (4000)DECLARE @intPos intSelect @strValues =ltrim (RTrim (@strValues))While @strValues BeginSelect @intPos =case when charindex (', ', @strValues) =0 then Len (@strValues) Else charindex (', ', @strValues)-1 endSelect @strTmp =ltrim (RTrim (substring (@strValues, 1,

SQL split string, SQL split string /* The Delimiter is ',' */declare @ depid varchar (100) declare @ location intdeclare @ length int -- Sample string set @ depid = '2017, 13434, 34, 5

SQL split string, SQL split Create function [dbo]. [fn_Split](@ SourceSql nvarchar (max), -- source separator string@ StrSeprate varchar (10) -- delimiter)Returns @ temp table (a nvarchar (max ))AsBeginDeclare @ I intSet @ SourceS

Original: "SQL" SQL version of the Split function. Used to split a string into a single-column tableFunctionality is similar to the. NET version of the String.Split function, except that. NET returns an array, which returns a single-column table with one row for each

function | string T-SQL is less capable of handling strings, such as I'm looping through strings like 1,2,3,4,5, and if you use arrays, traversal is simple, but T-SQL does not support arrays, so it's tricky to handle. The function below implements the processing of strings like an array. First, use a temporary table as an array create function f_split (@c varchar

See a post in the forum, the post has some SQL aspects of the question, I think these questions are very representative.The connection of the original posts is: http://bbs.csdn.net/topics/390884161?page=1#post-398177057Here is my solution, for your reference:1. Splitting stringsCREATE TABLE test1 (number varchar) INSERT into test1 values (' 1,2,3,4,5,6 ') desired result: number------123456 (6 rows affected)My Solution:--1.