拆分一个字符串，重组

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

转载于:https://www.cnblogs.com/tenghoo/archive/2011/08/30/2159370.html