Thread: trigger to insert current date on insert
View Single Post
  #3 (permalink)  
Old January 23rd, 2006, 04:54 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
Oops, sorry. Misread that. Why do you need a trigger? Put a default on the column you need the date inserted in to.

Reply With Quote