34,576
社区成员
发帖
与我相关
我的任务
分享
if object_id('tb','U') is not null
drop table tb
go
create table tb
(
jiqiID int,
starttime datetime default getdate(),
overtime datetime,
)
go
insert into tb(jiqiID) select 1
go
if object_id('tr_tb','TR') is not null
drop trigger tr_tb
go
create trigger tr_tb on tb
for insert
as
update tb set overtime=getdate() from tb inner join inserted on tb.jiqiID=inserted.jiqiID-1
go
insert into tb(jiqiID) select 2
select * from tb
/*
jiqiID starttime overtime
----------- ----------------------- -----------------------
1 2011-11-12 15:58:23.423 2011-11-12 15:58:48.440
2 2011-11-12 15:58:48.360 NULL
(2 行受影响)
*/
Create trigger tr_SalesOrder on SalesOrder
for insert
as
update s
set starttime=getdate(),overtime=null
from SalesOrder s
inner join inserted i on s.OrderID=s.OrderID
Create trigger tr_SalesOrder on SalesOrder
for inserted
as
update s
set starttime=getdate(),overtime=null
from SalesOrder s
inner join inserted i on s.OrderID=s.OrderID