一个简单的酒店系统的数据库设计

--15,随时查询顾客的应付金额
create proc guestcost @guestid int ,@total money output
as
  declare @servercost money,@roomcost money
  select @servercost=sum(servercost)
  from serverlist
  where serverid in
      (select serverid
       from serveruse
       where guestid=@guestid)
  select @roomcost=roomtypelist.roomcost
  from roomtypelist
  where roomtypeid in
      (select roomtypeid
       from roomlist
       where roomlist.roomid in    --用上面的结算
          (select roomid
           from guestroom
           where guestid=@guestid))
  select @roomcost=@roomcost*
    (select datediff(day,(select indate
                          from guestroom
                          where guestid=@guestid),getdate())
     from guestroom
     where guestid=@guestid)
  select @total=@servercost+@roomcost

上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:数据库备份中可能出错的情况及解决办法

下一篇:collate chinese_prc_ci_as null 是什么意思