Limit the number of SQL Server table updates and delete rows

Accidentally update forget to add conditions, simple limit!

Trigger for DML frequent operation of poor performance, pay attention to their actual situation!

Create Trigger Tr_tbltime

On Tbltime

For Update,delete

As

If Original_login (' Wind ', ' snow ')

and (select COUNT (*) from deleted) > 10

BEGIN

RAISERROR (' serious error, please contact the DBA ', 16, 1)

ROLLBACK TRANSACTION

Return

End

Go

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/SQLServer/