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

if (object_id('DELETE_CLASSIFICATION', 'tr') is not null)    drop trigger DELETE_CLASSIFICATIONgocreate trigger DELETE_CLASSIFICATIONon CLASSIFICATION    for deleteas    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_newGOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GO