Thread: trigger to insert current date on insert
View Single Post
  #2 (permalink)  
Old January 23rd, 2006, 04:52 PM
SQLScott's Avatar
SQLScott SQLScott is offline
Wrox Author
Points: 1,121, Level: 13
Points: 1,121, Level: 13 Points: 1,121, Level: 13 Points: 1,121, Level: 13
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
Posts: 338
Thanks: 0
Thanked 1 Time in 1 Post
Default
CREATE TRIGGER trigger_Name
   ON table_name
   AFTER insert
AS

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

Reply With Quote