blazer.sql

< SQL SERVER 2000 案例教程>>,冶金工业出版社,这本书的代码

use 酒店客房管理系统
--exec Hotel_GetRoomInfo 12007
--exec Hotel_UpdateRoomInfo "12109", D3109, "商业房","可用","无","宽带"
-- exec Hotel_EditRoom "12007", 
--exec Hotel_addCustom "100002", "身份证", "秦汉","女","天津","无","无"
-- exec Hotel_DelCustom "100002" 
-- exec Hotel_GetValidRoom 0, "1900-01-11", "2005-01-11"
-- exec Hotel_AddWorkSheet 3, 0, "2000-01-11", A00001, "Nu"
-- exec Hotel_AddSheetItem 2, 100001, 12007, 0,"2000-01-11","2000-01-15"
-- exec Hotel_DelSheetItem 2,100001
exec Hotel_GetCustomCost 100001