触发器结合游标删除关联表数据
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
posted on
2017-06-07 18:32
Apex_233 阅读(
...) 评论(
)
编辑
收藏
转载于:https://www.cnblogs.com/Apex233/p/6958547.html
相关资源：各显卡算力对照表！
