小型餐飲管理系統(tǒng)功能模塊設(shè)計(jì)-展示頁(yè)
2025-04-26 13:13本頁(yè)面
【正文】 = 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。 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。下面是創(chuàng)建基本表的SQL語(yǔ)句：/* ============================================================ *//* Table: CAIPINGL *//* ============================================================ */create table CAIPINGL( CPGL_NAME char(20) not null, CPGL_DANJIA integer not null, CPGL_LEIBIE char(8) null , CPGL_PINGZHONG char(8) null , CPGL_DIANCAI integer null , constraint PK_CAIPINGL primary key (CPGL_NAME, CPGL_DANJIA))go/* ============================================================ *//* Table: XTGL *//* ============================================================ */create table XTGL( USERNAME char(20) not null, PASSWORD char(8) not null, constraint PK_XTGL primary key (USERNAME, PASSWORD))go/* ============================================================ *//* Table: ZHANGDAGL *//* ======================================================
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1