SQL触发器
雁过留香
这个作者很懒,什么都没留下…
展开
-
验货计划控制
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER TRIGGER [GF_update_dateyh]ON [dbo].[t_yhplan]FOR updateASSET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus intsel...原创 2019-03-07 16:04:35 · 239 阅读 · 0 评论 -
生产周计划单控制
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER TRIGGER [T_update_面料及工序日期更新]ON [dbo].[t_BOSSCZJHD]FOR updateASSET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus int...原创 2019-03-07 16:03:40 · 196 阅读 · 0 评论 -
tr_更新最高限价
alter trigger tr_更新最高限价 on t_supplyentry for updateas declare @FUsed int,@FOldUsed int select @FUsed = FUsed from insertedselect @FOldUsed= FUsed from deleted if update (FUsed) and @FOldUsed ...原创 2019-02-23 16:50:56 · 149 阅读 · 0 评论 -
触发器:序列号自动生成
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER TRIGGER [tr_SerialNO]ON [dbo].[t_BOSSerialNO]FOR updateAS SET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus int sel...原创 2019-02-23 16:51:08 · 556 阅读 · 0 评论 -
物料变更
alter TRIGGER [GF_物料变更] ON [dbo].[t_BOSPosqbg]FOR updateAS SET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus int select @FID = FID,@FMultiCheckStatus = FMultiCheckStatus...原创 2019-02-22 16:00:29 · 427 阅读 · 0 评论 -
BOM删除记录
create TRIGGER [GF_BOM删除记录] ON [dbo].[t_bomdeleted]FOR updateAS SET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus int select @FID = FID,@FMultiCheckStatus = FMultiCheckS...原创 2019-02-22 15:59:44 · 556 阅读 · 0 评论 -
BOM插入记录
alter TRIGGER [GF_BOM插入记录] ON [dbo].[t_bominserted]FOR updateAS SET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus int select @FID = FID,@FMultiCheckStatus = FMultiCheckS...原创 2019-02-22 15:59:11 · 244 阅读 · 0 评论 -
触发器:出货调整单
alter trigger GF_出货调整单 on t_AdjustBillfor update as declare @FID int,@FStatus int,@FOldStatus intselect @FID = FID,@FStatus = FMultiCheckStatus from inserted select @FOldStatus = FMultiCheckS...原创 2019-02-22 15:54:30 · 168 阅读 · 0 评论 -
触发器:订单通知单加单
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER trigger [GF_insert_ddtzd] on [dbo].[t_ddtzdIncrease]for update as declare @FID int,@FStatus int,@FOldStatus int select @FID = FID,@FStatus =...原创 2019-02-22 15:44:27 · 295 阅读 · 0 评论 -
快速复制新增物料
alter TRIGGER GF_快速复制新增物料ON t_copyitemFOR updateASSET ANSI_WARNINGS OFFdeclare @FID int,@FMultiCheckStatus int,@FOldStatus intselect @FID = FID,@FMultiCheckStatus = FMultiCheckStatus from ...原创 2019-03-07 16:06:34 · 423 阅读 · 0 评论