SELECT @@version
/*
-------------------------------------------------
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition _disibledevent=sql:variable("@pos")]').
value('.[1]','VARCHAR(max)')
return @ret
END
GO
-- 数据准备
DECLARE @t TABLE(data varchar(50))
INSERT @t VALUES('10/20/30/50/40/90')
INSERT @t VALUES('1/2/3/5/4/9')
INSERT @t VALUES('10/5/60/33/12/1')
INSERT @t VALUES('10/8/3/60/55/20')
select dbo.F_split(data,3,'/') as col
from @t
DROP FUNcTION F_split
/*
col
------------------------------
30
3
60
3
(4 行受影响)
*/
-- 对比两个函数,大家看看是不是XML很有意思呀!!
最新评论