Question

sqlserver 触发器 if update()可不可以多家参数

create trigger trigger_aircondition_annal on tb_room
for update
as
if update(AC1_temp)
begin
declare @room1 varchar(6), @temp1 int
select @temp1=AC1_temp,@room1=RoomId from deleted

insert into tb_aircondition_annal(RoomId,Air1temp,Air1Time) select RoomId,@temp1 ,getdate() from inserted
end

Answer 1

create trigger trigger_aircondition_annal on tb_room
for update
as
declare @room1 varchar(6), @temp1 int
select @temp1=AC1_temp,@room1=RoomId from deleted

insert into tb_aircondition_annal(RoomId,Air1temp,Air1Time) select RoomId,@temp1 ,getdate() from inserted

Answer 2

if update(AC1_temp) or update(AC2_temp) or ...
begin

end