CREATEFUNCTION [dbo].[fn_Split] (
@InputString As Varchar(Max), --1,2,3 (输入字符串)
@Delimiter As Varchar(30) ---分割符
)
RETURNS TABLE AS
/*
函数 fn_Split
功能 ﹕字符串分割
drop function fn_Split
修改日期 修改作者 修改描述
-------------------------------------------------
*/
RETURN
(
SELECT Split.a.value('.', 'NVARCHAR(MAX)') DATA
FROM
(
SELECT CAST('<X>'+REPLACE(@InputString, @Delimiter, '</X><X>')+'</X>' AS XML) AS String
) AS A
CROSS APPLY String.nodes('/X') AS Split(a)
)
使用:
select * from dbo.fn_Split('1,2,3',',')