📄 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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -