小型餐飲管理系統(tǒng)(編輯修改稿)
2025-02-09 15:29 本頁面
【文章內(nèi)容簡介】 @@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 begin select @errno = 30002, @errmsg = 39。Parent does not exist in ZHANGDAGL. Cannot create child in DINGCANGL.39。 goto error end end return/* Errors handling */error: raiserror @errno @errmsg rollback transactionendgo/* Update trigger tu_dingcangl for table DINGCANGL */create trigger tu_dingcangl on DINGCANGL 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 DINGCANGL */ 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 DINGCANGL.39。 goto error end end return/* Errors handling */error: raiserror @errno @errmsg rollback transactionendgo/* Insert trigger ti_zhangdagl for table ZHANGDAGL */create trigger ti_zhangdagl on ZHANGDAGL for insert asbegin declare @numrows int, @numnull int, @errno int, @errmsg varchar(255) select @numrows = @@rowcount if @numrows = 0 return /* Parent CAIWUGL must exist when inserting a child in ZHANGDAGL */ if update(CAI_ZHANGDAN_NUMBER) begin select @numnull = (select count(*) from inserted where CAI_ZHANGDAN_NUMBER is null) if @numnull != @numrows if (select count(*) from CAIWUGL t1, inserted t2 where = ) != @numrows @numnull begin select @errno = 30002, @errmsg = 39。Parent does not exist in CAIWUGL. Cannot create child in ZHANGDAGL.39。 goto error end end return/* Errors handling */error: raiserror @errno @errmsg rollback transactionendgo/* Update trigger tu_zhangdagl for table ZHANGDAGL */create trigger tu_zhangdagl on ZHANGDAGL for update asbegin declare @numrows int, @numnull int, @errno int, @errmsg varchar(255) select @numrows = @@rowcount if @numrows = 0 return /* Parent CAIWUGL must exist when updating a child in ZHANGDAGL */ if update(CAI_ZHANGDAN_NUMBER) begin select @numnull = (select count(*) from inserted where CAI_ZHANGDAN_NUMBER i
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1