/*
* 字符串分割
* SELECT * FROM dbo.uf_Util_SplitStr('1,2,3,4,5,6,7,8,9,10,11,12', ',')
*/
CREATE FUNCTION dbo.uf_Util_SplitStr(
@Src varchar(8000),
@Splitor varchar(10)
)
RETURNS @Result TABLE(VALUE varchar(100))
AS
BEGIN
DECLARE @i int
SET @Src = RTRIM(LTRIM(@Src))
SET @i = CHARINDEX(@Splitor,@Src)
WHILE @i>=1
BEGIN
-- 插入新值
INSERT @Result
VALUES(LEFT(@Src, @i-1))
SET @Src = SUBSTRING(@Src, @i + 1, LEN(@Src) - @i)
SET @i = CHARINDEX(@Splitor, @Src)
end
IF @Src <> ''
INSERT @Result
VALUES(@Src)
RETURN
END