ALTER FUNCTION [dbo].[Split]
(
@Array VARCHAR(7000)
,@Split CHAR(1)
)
RETURNS @T TABLE(v VARCHAR(100))
AS
BEGIN
WHILE(CHARINDEX(@Split,@Array)<>0)
BEGIN
INSERT @T VALUES(SUBSTRING(@Array,1,CHARINDEX(@Split,@Array)-1));
SET @Array=STUFF(@Array,1,CHARINDEX(@Split,@Array),'');
END
INSERT @T VALUES(@Array);
RETURN;
END;
MSSQL字符串分割函数
最新推荐文章于 2021-11-19 16:42:38 发布