【正文】 ..........................................................................17 proc_insert_Worker .................................................................................................................17 proc_insert_Customer..............................................................................................................18 proc_insert_Car...........................................................................................................................19 proc_insert_CarClass ..................................................................................................................20 proc_insert_Record.....................................................................................................................21 proc_find_AllCarClass ...............................................................................................................22 proc_find_Cars............................................................................................................................23 proc_find_Car .............................................................................................................................23 proc_find_Customer ...................................................................................................................24 proc_find_CustomerRecord......................................................................................................24 proc_find_CarRecord................................................................................................................25 proc_find_CustomerFavorite ....................................................................................................25 函數(shù) ....................................................................................................................................................................267 / 55 func_CreateRecordNO................................................................................................................26 func_IdToAge.............................................................................................................................26 觸發(fā)器 ..............................................................................................................................................................27 Trigger_insertCar_addCarClassCnt..........................................................................................27 Trigger_deleteCar_subtractCarClassCnt ..................................................................................27 Trigger_updateCar ....................................................................................................................28 Trigger_updateRecordReturnDate............................................................................................28七、 運行結(jié)果 ..............................................................................................................................................................29 租賃汽車 ............................................................................................................................................................29 資料查詢 ............................................................................................................................................................30 訂單查詢 ............................................................................................................................................................30 查詢一類汽車 ....................................................................................................................................................31 還車登記 ............................................................................................................................................................31 統(tǒng)計某一年齡最喜歡的類型 ............................................................................................................................32八、 總結(jié) ......................................................................................................................................................................32九、 附錄 ......................................................................................................................................................................33 存儲過程代碼 ....................................................................................................................................................33 proc_insert_Car...........................................................................................................................33 proc_insert_CarClass ..................................................................................................................33 proc_insert_Customer.................................................................................................................34 proc_insert_Record.....................................................................................................................34 proc_insert_Worker ....................................................................................................................34 proc_find_AllCarClass ...............................................................................................................35 proc_find_Car .............................................................................................................................35 proc_find_Cars............................................................................................................................35 proc_find_CarRecord..................................................................................................................36 proc_find_Customer .................................................................................................................36 proc_find_CustomerFavorite ............................................