小型餐飲管理系統(tǒng)功能模塊設(shè)計(jì)(編輯修改稿)
2025-05-14 13:13 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 t when inserting a child in CAIWUGL */ if update(ZHANGDAN_NUMBER) begin if (select count(*) from ZHANGDAGL t1, inserted t2 where = ) != @numrows begin select @errno = 30002, @errmsg = 39。Parent does not exist in ZHANGDAGL. Cannot create child in CAIWUGL.39。 goto error end end return/* Errors handling */error: raiserror @errno @errmsg rollback transactionendgo/* Update trigger tu_caiwugl for table CAIWUGL */create trigger tu_caiwugl on CAIWUGL for update asbegin declare @numrows int, @numnull int, @errno int, @errmsg varchar(255) select @numrows = @@rowcount if @numrows = 0 return /* Parent ZHANGDAGL must exist when updating a child in CAIWUGL */ if update(ZHANGDAN_NUMBER) begin if (select count(*) from ZHANGDAGL t1, inserted t2 where = ) != @numrows begin select @errno = 30003, @errmsg = 39。ZHANGDAGL does not exist. Cannot modify child in CAIWUGL.39。 goto error end end /* Modify parent code of CAIWUGL for all children in ZHANGDAGL */ if update(ZHANGDAN_NUMBER) begin update ZHANGDAGL set CAI_ZHANGDAN_NUMBER = from ZHANGDAGL t2, inserted i1, deleted d1 where = and ( != ) end return/* Errors handling */error: raiserror @errno @errmsg rollback transactionendgo/* Delete trigger td_caiwugl for table CAIWUGL */create trigger td_caiwugl on CAIWUGL for delete asbegin declare @numrows int, @errno int, @errmsg varchar(255) select @numrows = @@rowcount if @numrows = 0 return /* Delete all children in ZHANGDAGL */ delete ZHANGDAGL from ZHANGDAGL t2, deleted t1 where = return/* Errors handling */error: raiserror @errno @errmsg rollback transactionendgo/* Insert trigger ti_dingcangl for table DINGCANGL */create trigger ti_dingcangl on DINGCANGL for insert asbegin declare @numrows int, @numnull int, @errno int, @errmsg varchar(255) select @numrows = @@rowcount if @numrows = 0 return /* Parent ZHANGDAGL must exist when inserting a child in DINGCANGL */ if update(ZHANGDAN_NUMBER) begin if (select count(*) from ZHANGDAGL t1, inserted t2 where = ) != @numrows
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1