Question

求数据库触发器代码（SQL）

酒店管理
表client(cid(客户编号),cname(客户名字),entretime(入住时间),leavetime(离开时间),rid(房间标号))
表room(rid(房间编号号),roomstatue(房间状态),cid(客户编号))
求触发器 当客户入住选定房间时 room表roomstatue，cid改变
同理 离开时做相应操作

Answer 1

CREATE TRIGGER Trig_client_update ON T_Item
FOR Update
AS
if Update(entretime)
begin
declare @rid int
SELECT @rid= rid FROM Inserted
if not @rid is null
begin
update room
set roomstatue='离开'
where rid=@rid
end
end
go
CREATE TRIGGER Trig_client_insert ON T_Item
FOR insert
AS
if @@Rowcount = 0
return
begin
declare @rid int
SELECT @rid= rid FROM Inserted
if not @rid is null
begin
update room
set roomstatue='入住'
where rid=@rid
end
end

Answer 2

create trigger personin
on client
for update(??,这个不清楚你是update还是insert)
as
update room set roomstatus='??',cid=(select cid from inserted) where rid=(select rid from inserted)

离开基本差不多