procedure.txt

该管理系统主要实现了对公寓楼、宿舍、住宿学生相关信息的查询

create procedure  pro_stu_hotel
@campus char(20)=null,
@building char(6)=null
as
select '宿舍'=hotel_information.hotel_no,
'电话'=hotel_information.hotel_phone,
'已住学生'=hotel_information.hotel_actual_stu,
'可住学生'=hotel_information.hotel_capacity
from building_information,hotel_information
where building_information.building_no=hotel_information.hotel_belong_building
and building_information.building_no=@building
and building_information.building_belong_campus=@campus