问创建已创建日期和更新日期的表(只读)

EN

CREATE TABLE dbo.foo
(
  ID INT IDENTITY(1,1),
  CreatedDate DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UpdatedDate DATETIME NULL
);
GO

CREATE TRIGGER dbo.foo_ForUpdate
  ON dbo.foo
  FOR UPDATE
AS
BEGIN
  SET NOCOUNT ON;

  UPDATE f SET UpdatedDate = CURRENT_TIMESTAMP
    FROM dbo.foo AS f
    INNER JOIN inserted AS i
    ON f.ID = i.ID;
END
GO

CREATE TRIGGER dbo.TableTriggerName
ON dbo.TableName
AFTER INSERT, UPDATE, DELETE
AS 
BEGIN
    SET NOCOUNT ON;

    --
    -- Check if this is an INSERT, UPDATE or DELETE Action.
    -- Set Action to Insert by default.
    IF EXISTS(SELECT * FROM DELETED)
    BEGIN
    END
    ELSE 
        IF NOT EXISTS(SELECT * FROM INSERTED) RETURN; -- Nothing updated or inserted.

    ...

    END