sql server触发器（批量删除，使用游标）

if (object_id('DELETE_CLASSIFICATION', 'tr') is not null)
    drop trigger DELETE_CLASSIFICATION
go
create trigger DELETE_CLASSIFICATION
on CLASSIFICATION
    for delete
as
    declare @CLASSIFICATION_NO  varchar(100);
       declare  cur_new insensitive cursor 
     for select CLASSIFICATION_NO from deleted
   open cur_new
   fetch next from cur_new into @CLASSIFICATION_NO
   
      while @@FETCH_STATUS <> -1
   begin
   
   
    delete Classification_Url where CLASSIFICATION_NO = @CLASSIFICATION_NO;
     fetch next from cur_new into @CLASSIFICATION_NO
     END
   close cur_new
   deallocate cur_new


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO