Automatically add and persist the current date in the database

Question

I want to create a database which has one date column that needs to be automatically filled with the current date. I tried the following design in Sql Management Studio: enter image description here

The problem with this desing is that every time I insert a new record to the table, all DateEffective rows change to the current date, and I need only the last row to change. Is there any solution to this problem?

Thanks!

find your answer here: http://stackoverflow.com/a/4888388/94334 — Tamir, Aug 07 '12 at 08:45

score 0 · Answer 1 · answered Aug 07 '12 at 08:45

0

try creating a trigger for this:

Trigger

answered Aug 07 '12 at 08:45

Joe G Joseph

23,518
5
56
58

Automatically add and persist the current date in the database

1 Answers1