Prevent accidental update or delete commands of all rows in a SQL Server table

Prevent accidental update or delete commands of all rows in a SQL Server table

瀏覽:798
日期:2025-04-25
Now that a DELETE trigger is defined on the Purchasing.VendorContact table, we can modify the delete trigger to prevent accidental delete of all rows in table. Just ALTER the trigger and paste code for the prevention logic at the beginning of the trigger....看更多