--获取切割字符位置
BREAK
RETURNS varchar(MAX)
PRINT @value


DECLARE @value VARCHAR(max)
BEGIN
SET @Source = SUBSTRING(@Source,@ChIndex+1,@Len)
645002*01

END
SET @ChIndex = CHARINDEX(@SplitChar,@Source)
DECLARE @n INT = 0
SET @Source = SUBSTRING(@Source,0,@ChIndex)

--获取总长度
SET @value = dbo.fGetStrBySplit('645002*01_45854_183677_12',0,'_')
SET @Len = LEN(@Source)
(

复制代码 代码如下:

DECLARE @Len INT

END
GO
BEGIN



SET @n = @n + 1
AS
)

CREATE FUNCTION fGetStrBySplit
SET @ChIndex = CHARINDEX(@SplitChar,@Source)
183677 WHILE @ChIndex > 0
@Index INT,
--2
BEGIN
@SplitChar VARCHAR(1)
RETURN @Source
@Source VARCHAR(max),
结果：
--1