declare
@table
table
(t
varchar
(
500
))
declare @s varchar ( 500 )
set @s = ' 你好啊hello123 ' ;
declare @len int
set @len = len ( @s )
declare @i int , @j int
set @i = 1
set @j = 0
while @i <= @len
begin
while @j < @len and @j < ( @len - @i + 1 )
begin
set @j = @j + 1
declare @t varchar ( 500 )
set @t = SubString ( @s , @i , @j )
if not exists ( select top 1 1 from @table where t = @t )
begin
insert into @table (t) values ( @t )
print cast ( @i as varchar ) + ' ~ ' + cast ( @j as varchar ) + ' : ' + @t
end
end
set @i = @i + 1
set @j = 0
end
select t from @table
declare @s varchar ( 500 )
set @s = ' 你好啊hello123 ' ;
declare @len int
set @len = len ( @s )
declare @i int , @j int
set @i = 1
set @j = 0
while @i <= @len
begin
while @j < @len and @j < ( @len - @i + 1 )
begin
set @j = @j + 1
declare @t varchar ( 500 )
set @t = SubString ( @s , @i , @j )
if not exists ( select top 1 1 from @table where t = @t )
begin
insert into @table (t) values ( @t )
print cast ( @i as varchar ) + ' ~ ' + cast ( @j as varchar ) + ' : ' + @t
end
end
set @i = @i + 1
set @j = 0
end
select t from @table