ALTER function [dbo].[数量](@str varchar(500))
returns int
as
begin
declare @n int
declare @m int
declare @i int
declare @jg char(20)
set @n=len(@str)
set @m=0
set @i=1
while @i< =@n
begin
set @jg=substring(@str,@i,1)
if @jg=','
set @m=@m+1
set @i=@i+1
end
return @m-1
end
returns int
as
begin
declare @n int
declare @m int
declare @i int
declare @jg char(20)
set @n=len(@str)
set @m=0
set @i=1
while @i< =@n
begin
set @jg=substring(@str,@i,1)
if @jg=','
set @m=@m+1
set @i=@i+1
end
return @m-1
end