/**FN_SplitSTR**/
/** 循环截取法分割字符串,默认返回数据表 */
IF exists (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[FN_SplitSTR]') and xtype in (N'FN', N'IF', N'TF'))
BEGIN
DROP FUNCTION [dbo].[FN_SplitSTR]
END
GO
CREATE FUNCTION FN_SplitSTR(
@s NVARCHAR(MAX), --待分拆的字符串
@split NVARCHAR(10) --数据分隔符
)RETURNS @re TABLE(col NVARCHAR(100))
AS
BEGIN
DECLARE @splitlen INT;
SET @splitlen=LEN(@split+'a')-2;
SET @s = REPLACE(REPLACE(@s,'[',''),']','');
WHILE CHARINDEX(@split,@s)>0
BEGIN
INSERT @re VALUES(LEFT(@s,CHARINDEX(@split,@s)-1));
SET @s=STUFF(@s,1,CHARINDEX(@split,@s)+@splitlen,'');
END
INSERT @re VALUES(@s);
RETURN
END
GO
SQL 循环截取法分割字符串,默认返回数据表
最新推荐文章于 2022-02-28 10:40:12 发布