LISTING 3: Logging New Orders in the LogOrders Table

CREATE TABLE LogOrders
(
  logid      int      NOT NULL IDENTITY(1000, 1),
  orderid    int      NOT NULL,
  customerid int      NOT NULL,
  orderdate  datetime NOT NULL,
  CONSTRAINT PK_LogOrders PRIMARY KEY(logid),
)
GO

CREATE TRIGGER trg_i_Orders_logorder ON Orders FOR INSERT
AS

INSERT INTO LogOrders(orderid, customerid, orderdate)
  SELECT * FROM inserted
GO