SQL 字符處理，分離（原）

 

declare @sql varchar(4000)
declare @variable varchar(500)
declare @field varchar(500)
declare @insertsql varchar(500)
declare xmw insensitive cursor for select xmw_wo_lot from xmw_det
open xmw
fetch next from xmw into @variable
declare @i int
set @i=0
set @sql='insert into lc_xmw_nbr values (,,,'
set @insertsql='insert into lc_xmw_nbr from '
while @@Fetch_Status=0
begin
  while @i<len(@variable)
  begin
    set @i=@i+1
    if SUBSTRING(@variable,@i,1)=';'
    begin
      print @variable
      print left(@variable,@i-1)
               set @sql=@sql+left(@variable,@i-1)+','
               --set @insertsql=@insertsql+@sql
               --print @sql
      set @variable=SUBSTRING(@variable,@i+1,len(@variable))
      set @i=0 
                 if(@i=len(@variable))
                  begin
                  set @sql=@sql+')'
                  print @sql
                  --set @insertsql='insert into lc_xmw_nbr from '
                  set @sql='insert into lc_xmw_nbr values (,,,'
                  end     
    end 
  end
fetch next from xmw into @variable
end
--print @variable
close xmw
deallocate xmw