[Sql Server] Make row readonly

以下sample sql是判斷如果要更新或刪除系統記錄檔層級為"Fatal"或"Error"的資料，會引發rollback和error。

CREATE TRIGGER [dbo].[triLogReadonly] ON [dbo].[SysLogging] AFTER UPDATE, DELETE AS IF EXISTS (SELECT * FROM deleted WHERE Level='Fatal' OR Level='Error') BEGIN    ROLLBACK TRANSACTION    RAISERROR ('Cannot update or remove read-only row(s)', 16, 1)    RETURN END

https://www.blueshop.com.tw/board/FUM20041006152735ZFS/BRD20160901105122EO3.html