create table tb ( id int identity (1,1), code varchar (50), num varchar (50), rq datetime null, primary key(id) ) gocreate trigger tri_rq on tb for insert, update as update tb set rq=getdate() from inserted a inner join tb b on a.id=b.id --id为关键字goinsert into tb(code,num) values(1,1)insert into tb(code,num) values(1,2)insert into tb(code,num) values(1,3)select * from tbdrop table tb go
create trigger tri_rq on tb for insert, update as update tb set rq=getdate() from inserted a inner join tb b on a.id=b.id --id为关键字 go--触发器就是为了记录表中数据建立或更新的时间
create table tb (
id int identity (1,1),
code varchar (50),
num varchar (50),
rq datetime null,
primary key(id)
)
gocreate trigger tri_rq on tb
for insert, update
as
update tb set rq=getdate()
from inserted a inner join tb b on a.id=b.id --id为关键字goinsert into tb(code,num) values(1,1)insert into tb(code,num) values(1,2)insert into tb(code,num) values(1,3)select * from tbdrop table tb
go
for insert, update
as
update tb set rq=getdate()
from inserted a inner join tb b on a.id=b.id --id为关键字
go--触发器就是为了记录表中数据建立或更新的时间