游标

1、sql Server游标1

declare mycursor cursor for (SELECT   *  FROM   Brand)
 open mycursor
 FETCH NEXT FROM mycursor INTO @BrandID,@Name
 while(@@FETCH_STATUS = 0) 
  BEGIN
  if not exists(select  1 from  brand where brandId =@BrandID)  
   begin  
     insert   into   Brand(BrandID,Name)   values(@BrandID,@Name)  
   end 
  else
   update Brand set BrandID=@BrandID,Name=@Name where BrandID=@BrandID
  FETCH NEXT FROM mycursor INTO @BrandID,@Name
  END 
  select @message      
 close mycursor
 DEALLOCATE mycursor

2、Sql Server 游标2

declare mycursor cursor for (SELECT   *  FROM   Brand)
 open mycursor

select @cnt = COUNT(0) from Brand
 while(@cnt > 0)
 begin
 FETCH NEXT FROM mycursor INTO @BrandID,@Name
 while(@@FETCH_STATUS = 0) 
  BEGIN
  if not exists(select  1 from  brand where brandId =@BrandID)  
   begin  
     insert   into   Brand(BrandID,Name)   values(@BrandID,@Name)  
   end 
  else
   update Brand set BrandID=@BrandID,Name=@Name where BrandID=@BrandID
  FETCH NEXT FROM mycursor INTO @BrandID,@Name
  END  
 set @cnt = @cnt - 1
   
 close mycursor
 DEALLOCATE mycursor