Link to home
Create AccountLog in
Avatar of Paracom_Inc
Paracom_Inc

asked on

Trigger to set mod date for SQL 2005 table

I would like to write a SQL 2005 trigger to set the value of a last mod date column in any row that is inserted or updated in a specific table. Is this possible? I can create a trigger, but I don't know how to change the data for the inserted/updated row.
ASKER CERTIFIED SOLUTION
Avatar of D B
D B
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
sorry, typo !
... getdate is a function ofcourse, so you need 'getdate()'

SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Glad I could be of any help !