CREATE FUNCTION StringToTable(@StringX varchar(8000),@Split nvarchar(10))RETURNS @TableResult TABLE(TableID nvarchar(100))
AS
BEGIN
DECLARE @Index int
DECLARE @LenIndex int
SELECT @LenIndex=LEN(@Split),@Index=CHARINDEX(@Split,@StringX,1)
WHILE (@Index>=1)
BEGIN
INSERT INTO @TableResult SELECT LEFT(@StringX,@Index-1)
SELECT @StringX=RIGHT(@StringX,LEN(@StringX)-@Index-@LenIndex+1),@Index=CHARINDEX(@Split,@StringX,1)
END
IF(@StringX<>'') INSERT INTO @TableResult SELECT @StringX
RETURN
END
分割字符串的sql函数
最新推荐文章于 2024-10-10 10:18:46 发布