Getdate as default value 1

[JohnBates]

Hi,

If the def value for a col is (getdate()),
will the col get updated every time anything in that row is changed.... or is it updated only on the initial insert of that row?

thanks, john

 

[JohnBates]

oh nevermind. Sorry to waste your time.

I experimented and found that No it doesn't
update a datetime col with the new time every time the column gets changed. You have to do that in your code (for ex in VB LastChanged = (now())

 

[john76]

If you want a date field to update every time it is modified (touched), you probably will want to use an update trigger to update the field whenever any data is modified in the table.

Hope this helps,
John

 

[darkwing75]

john76,

how would you do that? I mean how would you do a trigger that would update like a 'updated_date' field, everytime a particular row is updated? thanks!

 

[mkrausnick]

John,

Did you ever get an answer on how to use a trigger to update a CreateDate or LastUpdate date?

Mike Krausnick
Dublin, California

 

[SQLSister]

within a trigger

update table1
set lastupdateDAte = getdate()
FROM table1, inserted
WHERE table1.idfield = inserted.idfield

This should update the last modified date everytime the rigger runs.


Questions about posting. See faq183-874

 

[mkrausnick]

Cool! Thanks so much! Is 'inserted' is a pseudo table containing the record that was inserted? Would I also use 'inserted' to reference the ID on a modified record or would that be a 'updated' or some such?

Mike Krausnick
Dublin, California

 

[SQLSister]

yep, there are two pseudotables, inserted and deleted. THe first holds the new values (in an update) or the new record (In an insert). Deleted holds the old values or the record to be deleted. These pseudotables are only accessible ina trigger.

Questions about posting. See faq183-874

 

[mkrausnick]

Excellent. Thank you again.

Mike Krausnick
Dublin, California