I am trying to write a trigger that inserts the date when a record is inserted. I have not found any good examples on how to do this. Can anyone point me in the right direction.

Thanks,
Kevin

CREATE TRIGGER trigger_Name
   ON table_name
   AFTER insert
AS

insert into table (column1, column2, columnn3)
SELECT column1, column2, column3 from inserted
GO

Oops, sorry. Misread that. Why do you need a trigger? Put a default on the column you need the date inserted in to.

--IF you want to accomodate updates then
CREATE TRIGGER trg_myTable_ModDate
  ON myTable
 AFTER INSERT, UPDATE
AS

UPDATE myTable set ModDate = GETDATE()
FROM myTable
JOIN inserted i
ON i.ID = myTable.ID -- where ID is your primary key



David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com