SQL current timestamp

Question

I have made a featureclass for a utility company where they can register measures set up to mitigate problems with rats, called "mitigation measure". From this feature class it is possible to state if the current mitigation measure has been removed or not. This field is named "Removed" and it is a domain value with possibilities "Yes", "No" and "Not set".

I now wish to create a sql trigger that can update a time field called "DateRemove" with the current timestamp for the moment the utility company changes the field "Removed" from "No" to "Yes". But only when this exact change happens, not when other changes occur within the feature class.

score 1 · Answer 1 · edited Jan 07 '16 at 17:30

I changed a few things so that it ended up like this:

Create TRIGGER [sonfor_ags].[trg_date] ON [sonfor_ags].[MitigationMeasure] 
AFTER UPDATE 
AS BEGIN 
SET NOCOUNT ON; 

    UPDATE t SET DateRemove = CURRENT_TIMESTAMP 
    FROM [sonfor_ags].[MitigationMeasure] AS t 
    INNER JOIN inserted AS i ON t.OBJECTID = i.OBJECTID 
       AND i.Removed = 1; END GO

and now it works perfectly. Thank you very much

SQL current timestamp

1 Answers1