截取字符串

if exists(select * from sys.sysobjects where id = OBJECT_ID(N'[dbo].[f_splitStr]') and xtype in (N'FN',N'IF',N'TF'))
drop function [dbo].[f_splitStr]
go
--循环截取法
create function f_splitStr(
@s varchar(8000),
@split varchar(10)
) returns @re table(col varchar(100))
as
begin
declare @splitlen int = len(@split + 'a') - 2
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

--Taanscation sql 方法