procedure book_style_room.sql

人员管理客房管理结算客房预定人员权限管理等等

create procedure book_style_room
@book_room_combine varchar(8),
@book_room_style varchar(16)
as
select room_floor,room_id,r_style_name,room_available,room_used,room_combine,r_style_price,r_style_conprice,r_style_discount,room_state,room_explain
from room_infor,r_style_infor
where room_state='空房'and room_booked=0 and r_style_id=room_style and room_combine=@book_room_combine and r_style_id=@book_room_style