This should work for you .

CREATE TABLE _A

(

A int ,

B int ,

c datetime

)

CREATE TABLE _B

(

A int ,

B int ,

c datetime

)

Insert into _A (A,B,C)

SELECT 44601631,6543,null

Insert into _A (A,B,C)

SELECT 44601631,6543,GETDATE()

CREATE TRIGGER TRG_A

ON _A

AFTER INSERT, UPDATE

AS

insert into _B

SELECT * FROM inserted

where c is not null

SELECT * FROM _A

SELECT * from _B

Update _A

Set c = Getdate()

where A = 44601631

GO