SQL数据库 客房管理

1.入住，不准张三入住

房号，ID,姓名

p1 '201','123456789987654328','wangwu'

alter procedure p1

@fh char(3),@id char(18),@name varchar(20)

as

declare @zt char(2)

select @zt=zt from room where fh=@fh

update room set zt='满'where fh=@fh

insert into live (fh,id,intime,yj) values(@fh,@id,getdate(),200)

end

else

print '该房间已满'

select * from customer

select * from room

select * from live

select * from view1

select * from view2

update live set outtime=getdate() where fh=@fh and ff is null

select @jg=jg from room where fh=@fh

select @d=datediff(dd,intime,outtime) from live where fh=@fh and ff is null

select @t=datepart(hh,outtime) from live where fh=@fh and ff is null

if (@d=0) set @ts=1

else

if(@t>12)

set @ts=@d+1

else

set @ts=@d