There are 2 columns Age and Date of Birth in the table
How can i change automatically Age column according to Date of Birth when the year changed. ?
I searched and find that is solving with trigger but i dont know how to do it with trigger.
Loading
There are 2 columns Age and Date of Birth in the table
How can i change automatically Age column according to Date of Birth when the year changed. ?
I searched and find that is solving with trigger but i dont know how to do it with trigger.
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Ryan AlfordPosted Mar 31, 2008, 2:06 PM
here are a couple of good articles on creating triggers.
http://www.15seconds.com/issue/041006.htm
http://www.developer.com/db/article.php/3552096
http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx