create function n(@str1 varchar(20),@str2 varchar(10)) returns int
as
begin
declare @i int,@j int,@num int
set @i=1
set @num=0
while(@i<=len(@str1))
begin
set @j=1
while(@j<=len(@str2))
begin
if substring(@str1,@i+@j-1,1)!=substring(@str2,@j,1)
goto loop1
else
set @j=@j+1
end
if @j=len(@str2)+1
set @num=@num+1
loop1:set @i=@i+1
end
return @num
end
select dbo.n('xionghainixiiiixixi','xi')