sql slplit 操作

else if @DealType='EDIT' --修改操作
begin
 if(exists(select * from wenjuan_timu where bianhao=@bianhao and timubiaoti=@timubiaoti and tihao<>@tid))
         set @Ruturn='SAMTITLE'
 else
     begin
 
     update wenjuan_timu set timubiaoti=@timubiaoti,bixuan=@bixuan,paixu=@paixu,tuxing=@tuxing,jiaocha=@jiaocha,toupiao=@toupiao,xiala=@xiala,tuxingsu=@tuxingsu,liebiao=@liebiao,jiaocha1=@jiaocha1,jiaocha2=@jiaocha2,jiaochamore=@jiaochamore,lieshu=@lieshu where tihao=@tid
     --添加到题库
  if(@tiku='是')
  begin
  update wenjuan_tiku_timu set timubiaoti=@timubiaoti,bixuan=@bixuan,paixu=@paixu where tihao=@tid
  end
  --添加到选项表里
  
  delete wenjuan_xuanxiang where tihao = @tid  -- 删除原来的选项，
 
  --DECLARE @Index int;
  --DECLARE @Left nvarchar;
  
  --DECLARE @Index1 int;
  --DECLARE @Left1 nvarchar;
 
  select @count=count(*)+1 from wenjuan_xuanxiang where tihao=@tihao
 
  WHILE CHARINDEX(',',@xx) > 0
   BEGIN
   select @count=count(*)+1 from wenjuan_xuanxiang where tihao=@tihao
 
    SELECT @Index = CHARINDEX(',',@xx);
    SELECT @Left = LEFT(@xx,@Index-1);
  
    SELECT @Index1 = CHARINDEX(',',@xxtp);
    SELECT @Left1 = LEFT(@xxtp,@Index1-1);
  
    insert into wenjuan_xuanxiang(tihao,xuanxiang,toupiao,xunsu) values(@tihao,@LEFT,@LEFT1,@count)
    if(@tiku='是')