create trigger sys_trig
on sys_mac
for insert,update
as
Declare @ip varchar(13)
select @ip=ip from inserted
update sys_mac set 時間='999' where ip=@ip
on sys_mac
for insert,update
as
Declare @ip varchar(13)
select @ip=ip from inserted
update sys_mac set 時間='999' where ip=@ip
on sys_mac
for insert,update
as
Declare @ip varchar(13)
select @ip=ip from inserted
if @ip='192.168.0.177'
update sys_mac set 時間='999' where ip=@ip