拆分一个字符串，重组

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