以下是我的触发器代码,各位论坛的朋友检查下代码是否需要优化?
--------------------作者:xx;主题:采购入库单触发器;内容:将采购入库单子表中的产品编号值赋予给产品编号(出库)-----------------------
use UFDATA_002_2021 -----------指定当前数据库
--------------------当库里存在cpingrk_trigger触发器时自动删除,没有,则新建--------------------------------------
if exists(select name from sysobjects where name='rdrecords01_trigger')
drop trigger rdrecords01_trigger
go
--------------------新建rdrecords01_trigger触发器--------------------------------------
--------------------rdrecord101采购入库单主表,rdrecords01采购入库单子表
create trigger rdrecords01_trigger
on rdrecord01
for insert,update,delete
as
if exists(select * from inserted)
begin
update B
set B.cBatchProperty7=B.cDefine28
from rdrecord01 A,INSERTED I,rdrecords01 B
where B.ID=A.ID
END
GO