Create Trigger [dbo].[Test01] On TblParaCode AFTER UPDATE,delete AS begin if ((SELECT paracode From TblParaCode where typecode=29) =2) begin RAISERROR('Cannot delete this record.',16,1) rollback transaction end end
INSTEAD OF
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)