select_setsomeonelivein.sql

来自「一套宾馆管理系统」· SQL 代码 · 共 22 行

create procedure ArrangeSomeone
@SqlSmt varchar(500),
@id int ,
@return_id tinyint output 
as
 declare @lock bit
 select @lock=islock from RoomList where room_id=@id
 if @lock=0 --没有锁定，可以扫行
  begin
   execute(@SqlSmt)
   update RoomList set islock=0 where room_id=@id
   commit
   set @return_id=1
   return 
  end
 else
  begin
   rollback
   set @return_id=0
   return 
  end