declare @num varchar(20),@nums varchar(50),@i int,@tmp int
select @num=@str,@i=1,@nums='',@tmp=0
while @i<=len(@num)
begin
if substring(@num,@i,1)<>substring(@num,@i+1,1)
begin
set @i=@i+1
if @tmp>=3
set @nums=@nums+' '+substring(@num,@i-1,1)+'出现了'+convert(varchar,@tmp)+'次'
set @tmp=1
end
else
begin
select @tmp=@tmp+1,@i=@i+1
end
end
if @nums=''
select '没有重复出现超过3次的数字'
else
select @nums