景點門票銷售管理系統(tǒng)數(shù)據(jù)庫設(shè)計(參考版)
2025-04-11 23:51本頁面
【正文】 with replacego。with norecoverygorestore database Attraction_Managefrom disk=39。with differentialgouse mastergorestore database Attraction_Managefrom disk=39。with REPLACEgouse Attraction_Manage17backup database Attraction_Manageto disk=39。with initgo 完整數(shù)據(jù)庫恢復(fù)use mastergorestore database Attraction_Managefrom disk=39。),constraint CHECK1_AGE check(Age=0)goalter table Admin_alter table Ticket_summary with checkadd constraint CHECK_Sell_amount check(Sell_amount=0),constraint CHECK_Sell_money check(Sell_money=) 完整數(shù)據(jù)庫備份use Attraction_Managegobackup database Attraction_Manageto disk=39。 or Sex=39。),constraint CHECK_AGE check(Age=0)goalter table Custom_T with checkadd constraint CHECK1_SEX check(Sex=39。 or Sex=39。6完整性約束USE Attraction_Managegoalter table Admin_T with check16add constraint CHECK_SEX check(Sex=39。 where Ticket_ID=39。)create trigger tri_Ticxgon Ticket_List for updateas declare sTic_ID char(17),sTicket_type char(3),saTicket_type char(3),scount int,sacount intselect sTicket_type=Ticket_type,sTic_ID=Ticket_ID from insertedselect saTicket_type=Ticket_type from Ticket_List where Ticket_ID=sTic_IDselect scount=Ticket_Count from Ticket_T where Ticket_type=sTicket_typeselect sacount=Ticket_Count from Ticket_T where Ticket_type=saTicket_typebeginupdate Ticket_T set Ticket_Count=scount+1 where Ticket_type=sTicket_typereturnupdate Ticket_T set Ticket_COunt=sacount1 where Ticket_type=saTicket_typereturnendrollback transactionupdate Ticket_List set Ticket_type=39。,2,40,39。, 1539。,39。,39。create trigger tri_Tic_Sellon Ticket_summary for insertas declare oldcount int,newcount int,sTicket_type char(3)select sTicket_type=Ticket_type,newcount=Sell_amount from insertedselect oldcount=Ticket_Count from Ticket_T where Ticket_type=sTicket_typeif newcount0 and oldcount0beginupdate Ticket_T set Ticket_Count=oldcountnewcount where Ticket_type=sTicket_typereturnendrollback transactioninsert into Ticket_summary values(39。)，對各表所有有關(guān)該人的信息進行級聯(lián)刪除create trigger TRiGGER_EXIT_TICon dd_T for deleteas 14beginDeclare Order_ID_DEL char(10),Cust
公司管理相關(guān)推薦
鄂ICP備17016276號-1