1.02D Exp Bugı

CREATE TRIGGER [prevent_DL] ON [dbo].[Character]  
  FOR INSERT  
  AS  
  DECLARE @Acc varchar(10), @Max INT, @Min INT  
  SET @Min = 300   
  DECLARE LISTA CURSOR LOCAL FOR  
  SELECT AccountID FROM INSERTED  
  WHERE (Class=64)  
  OPEN LISTA  
  FETCH NEXT FROM LISTA INTO @Acc  
  WHILE @@FETCH_STATUS = 0  
  BEGIN  
  SET @Max = (SELECT MAX(cLevel) FROM [Character] WHERE (AccountID=@Acc))  
  IF (@Max < @Min)BEGIN  
  ROLLBACK TRANSACTION  
  END  
  FETCH NEXT FROM LISTA INTO @Acc  
  END  
  CLOSE LISTA  
  DEALLOCATE LISTA   
  

SET @Min = 300 //size kalmış