Untitled

Update Trigger in SQL Server 2008
CREATE TRIGGER on_update
ON [GP].[dbo].[TABLE1]
AFTER UPDATE
AS

DECLARE @PKCOL1 int
DECLARE @COL2 int
DECLARE @COL3 nvarchar(36)
DECLARE @COL4 nvarchar(36)
DECLARE @COL5 nvarchar(126)
DECLARE @COL6 datetime
DECLARE @COL7 datetime

BEGIN
SELECT     @PKCOL1     = [COL-A],
       @COL2       = [COL-B],
       @COl3       =  NULL,
       @COL4       = [COL-C],
       @COL5       = [COL-D],
       @COL6       = [COL-E]

FROM INSERTED

   UPDATE [dbo].[TABLE2]
   SET [COL2]            =  @COL2,
       [COL3]            =  @COL3,
       [COL4]            =   @COL4,
       [COL5]            =   @COL5


   WHERE COL2 = @PKCOL1

UPDATE Table2 SET
    [Col2] = i.[Col-B]
  , [Col3] = NULL
  , [Col4] = i.[Col-C]
  , [Col5] = i.[Col-D]
FROM Table2
JOIN INSERTED i ON Table2.Col2 = i.[Col-A]