create trigger tg on access for insert as update userinfo set offonline=1 from userinfo u,inserted i where u.username=i.username
create trigger triA on access_log for insert as update userinfo set offonline=1 from userinfo a join inserted b on a.username=b.username go
create trigger trg_test on access_log for insert as update userinfo set offonline=1 from inserted a ,userinfo b where a.username=b.usernamego
create trigger tg_1 on access for insert as update userinfo set offonline=1 from userinfo u,inserted i where u.username=i.username
--建表 create table access_log (username varchar(10)) create table userinfo(username varchar(10),offonline bit)--create trigger create trigger tg_test on access_log for insert as declare @username varchar(10) select @username=username from inserted insert into userinfo values(@username,1)---test insert into access_log values('vv') select * from userinfo
测试: create table access_log (username varchar(10)) create table userinfo(username varchar(10),offonline bit)insert into userinfo select 'a',0 union select 'b',0 goselect * from userinfo 结果: a 0 b 0 create trigger up on access_log for insert as update userinfo set offonline=1 from userinfo a inner join inserted b on a.[username]=b.[username] goinsert into access_log select 'b' select * from access_log select * from userinfo where 1=1结果: 表:access_log b 表:userinfo a 0 b 1
as
update userinfo
set offonline=1
from userinfo u,inserted i
where u.username=i.username
as
update userinfo set offonline=1 from userinfo a join inserted b on a.username=b.username
go
on access_log
for insert
as
update userinfo
set offonline=1
from inserted a ,userinfo b
where a.username=b.usernamego
on access for insert
as
update userinfo set offonline=1
from userinfo u,inserted i
where u.username=i.username
create table access_log (username varchar(10))
create table userinfo(username varchar(10),offonline bit)--create trigger
create trigger tg_test on access_log
for insert
as
declare @username varchar(10)
select @username=username from inserted
insert into userinfo values(@username,1)---test
insert into access_log values('vv')
select * from userinfo
create table access_log (username varchar(10))
create table userinfo(username varchar(10),offonline bit)insert into userinfo
select 'a',0
union
select 'b',0
goselect * from userinfo
结果:
a 0
b 0
create trigger up
on access_log
for insert
as
update userinfo
set offonline=1
from userinfo a inner join inserted b
on a.[username]=b.[username]
goinsert into access_log
select 'b'
select * from access_log
select * from userinfo where 1=1结果:
表:access_log
b
表:userinfo
a 0
b 1