Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning when one column is updated, want to update another column in same table using trigger. RE: when one column is updated, want to update another column in same table using trigger.
Jerry Hung
SSChampion
Points: 12968
More actions
September 25, 2008 at 10:31 am
#877158
how about a Computed Column that "computes" i.Quantity * i.Price
http://www.sqlservercentral.com/articles/User-Defined+functions/complexcomputedcolumns/2397/[/url]