首页 > 代码库 > 触发器结合游标删除关联表数据

触发器结合游标删除关联表数据

USE [数据库]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--MODIFY BY 删除触发器--基本表删除数据时,把对应的调价信息一并清除
ALTER    trigger [dbo].[tg_deleteSBMC]
on [dbo].[SBMC]
for delete
as 
Declare @sbmcbh varchar(20),@store varchar(4)

begin
declare  cur_delsbmc cursor for --游标
select deleted.bh,deleted.store
from deleted
open cur_delsbmc --开启游标
fetch next from cur_delsbmc into @sbmcbh,@store
while (@@FETCH_STATUS = 0 )
begin		
	delete from HCGL_TJJLB where STORE = @store and ZDBH=@sbmcbh
	if @@ERROR <> 0  
		begin
			close   cur_delsbmc
			deallocate cur_delsbmc
			return
		end

	fetch next from cur_delsbmc into @sbmcbh,@store
end
	 close   cur_delsbmc
	 deallocate cur_delsbmc
end

  

触发器结合游标删除关联表数据