-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description:sql函数实现C#Split的功能
-- =============================================
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER function [dbo].[SplitStr]
(
@SourceSql varchar(8000),-----源字符串----
@StrSeprate varchar(10)----分割符---
)
returns float
as
begin
declare @ch as int
declare @temp as float
set @temp = 0
set @SourceSql= rtrim(ltrim(@SourceSql))
set @ch=charindex(@StrSeprate,@SourceSql)
while(@ch > 1)
begin
set @temp = @temp + convert(float,(left(@SourceSql,@ch-1)))
set @SourceSql = substring(@SourceSql,@ch+1,(len(@SourceSql)-@ch))
set @ch = charindex(@StrSeprate,@SourceSql)
end
return @temp
end