不小心update忘记添加条件,简单限制下!
trigger针对DML频繁操作时性能不佳,注意自己实际情况!
create trigger tr_tblTime
on tblTimefor update,delete
as
if ORIGINAL_LOGIN()in ('wind','snow')
and (select count(*) from deleted)> 10
BEGIN
RAISERROR ( 'Serious error, please contact the DBA',16,1)
ROLLBACK TRANSACTION
RETURN
END
go