sql - SQL插入触发器

Question

我有一个表ARCHIVED_TIMESTAMP和列ID INT，ID_ELEMENT REFERENCES ELEMENT(ID)和ARCHIVED_TIMESTAMP TIMESTAMP
我想创建一个触发器，该触发器在ARCHIVED_TIMESTAMP表中的每次插入后，自动将插入的元素(ELEMENT)的id和来自插入的时间戳(ID_ELEMENT=ID)插入到表ARCHIVED_TIMESTAMP=CURRENT_TIMESTAMP中

Answer 1

如果我正确理解，请尝试以下操作:

CREATE  TRIGGER TRG_ELEMENT_FOR_INS ON ELEMENT 
FOR INSERT
AS
BEGIN

  INSERT INTO ARCHIVED_TIMESTAMP(ID_ELEMENT, ARCHIVED_TIMESTAMP)
  SELECT INS.ID
  ,      INS.CURRENT_TIMESTAMP 
  FROM Inserted INS

END -- End trigger TRG_ELEMENT_FOR_INS