tt1:表
sno grade æ¶é´
2003 101 2013-01-01 00:00:00.000
2003 90 2012-12-29 00:00:00.000
2003 80 2012-12-29 00:00:00.000
2003 100 2012-12-29 00:00:00.000
create trigger bok
on tt1
for delete
as
declare @entertime datetime /***ç³»ç»å½åæ¶é´*****/
set @entertime=getdate()
select @entertime from deleted
if (select entertime from tt1)<@entertime
begin
print 'å é¤æå'
end
else
begin
rollback transaction
end
温馨提示:答案为网友推荐,仅供参考