create procedure cx @rs int,@rriqi1 date,@criqi1 date as --查询符合人数和日期的房间
declare @num char(7)
declare getCur cursor for
select num from fangjian,dengji
where fangjian.num=dengji.num and @rs=rs
and @rriqi1>criqi1 or @criqi1<rriqi1
open getCur
fetch getCur into @num
select num 房号,rs 可居住人数
from fangjian
where num=@num
close getCur
deallocate getCur
exec cx '1','2019-06-28','2019-07-05'