Triggers

CREATE TRIGGER <TriggerName> ON <TableName OR ViewName>
FOR INSERT, UPDATE, DELETE
AS
SELECT [ID]
FROM <TableName>
WHERE <You determine the criteria for getting the ID>
<Then what ever you want to do with the ID>

SELECT [ID]
FROM <TableName>
WHERE LastEditDate =
(SELECT MAX(LastEditDate)
FROM <tableName>)

CREATE TRIGGER <TriggerName> ON <TableName OR ViewName>
FOR INSERT, UPDATE, DELETE
AS
INSERT INTO <AnotherTable>([ID]) VALUES(
   SELECT A.[ID]
      FROM <TableName> As A
      WHERE A.LastEditDate =
         (SELECT MAX(B.LastEditDate)
         FROM <tableName> As B))

  REFERENCING Specifies the correlation names for the transition variables and the table names for the transition tables. Correlation names identify a specific row in the set of rows affected by the triggering SQL operation. Table names identify the complete set of affected rows. Each row affected by the triggering SQL operation is available to the triggered action by qualifying columns with correlation-names specified as follows. OLD AS correlation-name Specifies a correlation name which identifies the row state prior to the triggering SQL operation. NEW AS correlation-name Specifies a correlation name which identifies the row state as modified by the triggering SQL operation and by any SET statement in a BEFORE trigger that has already executed. The complete set of rows affected by the triggering SQL operation is available to the triggered action by using a temporary table name specified as follows. 
 
 OLD_TABLE AS identifier Specifies a temporary table name which identifies the set of affected rows prior to the triggering SQL operation. NEW_TABLE AS identifier Specifies a temporary table name which identifies the affected rows as modified by the triggering SQL operation and by any SET statement in a BEFORE trigger that has already executed. The following rules apply to the REFERENCING clause:
None of the OLD and NEW correlation names and the OLD_TABLE and NEW_TABLE names can be identical (SQLSTATE 42712).
Only one OLD and one NEW correlation-name may be specified for a trigger (SQLSTATE 42613).
Only one OLD_TABLE and one NEW_TABLE identifier may be specified for a trigger (SQLSTATE 42613).
The OLD correlation-name and the OLD_TABLE identifier can only be used if the trigger event is either a DELETE operation or an UPDATE operation (SQLSTATE 42898). If the operation is a DELETE operation, OLD correlation-name captures the value of the deleted row. If it is an UPDATE operation, it captures the value of the row before the UPDATE operation. The same applies to the OLD_TABLE identifier and the set of affected rows.
The NEW correlation-name and the NEW_TABLE identifier can only be used if the trigger event is either an INSERT operation or an UPDATE operation (SQLSTATE 42898). In both operations, the value of NEW captures the new state of the row as provided by the original operation and as modified by any BEFORE trigger that has executed to this point. The same applies to the NEW_TABLE identifier and the set of affected rows.
OLD_TABLE and NEW_TABLE identifiers cannot be defined for a BEFORE trigger (SQLSTATE 42898).
OLD and NEW correlation-names cannot be defined for a FOR EACH STATEMENT trigger (SQLSTATE 42899).
Transition tables cannot be modified (SQLSTATE 42807).
The total of the references to the transition table columns and transition variables in the triggered-action cannot exceed the limit for the number of columns in a table or the sum of their lengths cannot exceed the maximum length of a row in a table (SQLSTATE 54040).
The scope of each correlation-name and each identifier is the entire trigger definition.
FOR EACH ROW Specifies that the triggered action is to be applied once for each row of the subject table that is affected by the triggering SQL operation. FOR EACH STATEMENT Specifies that the triggered action is to be applied only once for the whole statement. This type of trigger granularity cannot be specified for a BEFORE trigger (SQLSTATE 42613). If specified, an UPDATE or DELETE trigger is activated even when no rows are affected by the triggering UPDATE or DELETE statement.