Yelena Varshal (11/2/2007)

---

I think that UPDATE() is incorrect answer.

The question was:

"Within a trigger, how can you tell if a value has altered on a specific column? "

The explanations for the...

uhm.. If you did use CHR, then I guess that the problem is there: You should use CHAR, as below:

SELECT make, model, color, CASE WHEN StartDate <> Effectdate THEN 'Eff. '...

Hi.

Only a little humble suggestion: to read/write configuration settings into the Windows Registry, Enterprise Manager uses xp_instance_regread and xp_instance_regwrite, that are the same as xp_regread and xp_regwrite, except already focused...

In this solution I used a function (available in MSSQL 8.0 and later). The usage of a function give the advantage to be invoked inside any query, thus executing the...