CREATE  trigger DISALLOW_ENTRY_CHANGE on WARR_PARTS_RCVD after insert
as 
set nocount on

/* Declare local variables */
declare 
  @AMT	T_MONEY,
  @CHG	T_MONEY,
  @Msg                   T_ERR_REF

select 
  @AMT = I.ACT_PARTS_AMT,
 @CHG=D.ACT_PARTS_AMT
from inserted I
JOIN DELETED D
ON I.TKT_NO=D.TKT_NO

/* Make sure the entry has not changed */
if @AMT <> @CHG and @AMT IS NOT NULL
  begin
    select @Msg = @AMT + ' <> ' + @CHG + ' - you may not CHANGE ENTRIES!'
      raiserror(@Msg, 18, 1)
  end

CREATE TRIGGER ...
...
AS

...

UPDATE U
SET    MyCol1 = COALESCE(D.MyCol1, U.MyCol1),
       MyCol2 = COALESCE(D.MyCol2, U.MyCol2),
...
FROM   MyTable U
       JOIN deleted D
           ON D.MyPK = U.MyPK

CREATE  trigger DISALLOW_ENTRY_CHANGE on WARR_PARTS_RCVD
for update
as 
set nocount on

/* Declare local variables */
declare 
  @AMT	T_MONEY,
  @CHG	T_MONEY,
  @Msg  T_ERR_REF

select 
  @AMT = I.ACT_PARTS_AMT,
 @CHG=D.ACT_PARTS_AMT
from inserted I
JOIN DELETED D
ON I.TKT_NO=D.TKT_NO

/* Make sure the entry has not changed */
if @AMT <> @CHG
  begin
rollback
  raiserror('you may not CHANGE ENTRIES!', 18, 1)
  end

CREATE  trigger DISALLOW_ENTRY_CHANGE on WARR_PARTS_RCVD 
FOR UPDATE
as 
set nocount on

/* Declare local variables */
declare 
  @AMT	T_MONEY,
  @CHG	T_MONEY,
  @AMT2	T_MONEY,
  @CHG2	T_MONEY,
  @DT		T_DAT,
  @DTC		T_DAT,
  @DT2		T_DAT,
  @DTC2	T_DAT,
  @V		T_VEND_NO,
  @VC		T_VEND_NO,
  @V2		T_VEND_NO,
  @VC2		T_VEND_NO,
  @R		T_FLG,
  @RC		T_FLG,
  @R2		T_FLG,
  @RC2		T_FLG,
  @Msg               T_ERR_REF

select 
   @AMT=i.ACT_PARTS_AMT,@AMT2=i.ACT_PARTS_AMT2,
@DT=i.DATE_PARTS_RCVD,@DT2=i.DATE_PARTS_RCVD2,
@V=i.ACT_PARTS_VEND,@V2=i.ACT_PARTS_VEND2,
@R=i.PARTS_RCV_TYP,@R2=i.PARTS_RCV_TYP2,
   @CHG=D.ACT_PARTS_AMT,@CHG2=D.ACT_PARTS_AMT2,
@DTC=D.DATE_PARTS_RCVD,@DTC2=D.DATE_PARTS_RCVD2,
@VC=D.ACT_PARTS_VEND,@VC2=D.ACT_PARTS_VEND2,
@RC=D.PARTS_RCV_TYP,@RC2=D.PARTS_RCV_TYP2
from inserted i
JOIN DELETED D
ON i.TKT_NO=D.TKT_NO

/* Be sure user is the user logged in */
if (@AMT<>@CHG) OR (@AMT2<>@CHG2)
OR(@DT<>@DTC)OR(@DT2<>@DTC2) OR
(@V<>@VC)OR(@V2<>@VC2) OR(@R<>@RC)
OR(@R2<>@RC2)
 BEGIN
ROLLBACK
      raiserror( ' !CHANGE ENTRY NOT ALLOWED!', 18, 1)
  end