June 11, 2025 at 12:00 am
Comments posted to this topic are about the item The Trigger Updated Column(s)
June 11, 2025 at 8:12 am
Minor quibble - the question asks about UPDATED_COLUMNS but the function is actually COLUMNS_UPDATED.
June 11, 2025 at 9:52 am
I wonder, if someone is really using the COLUMNS_UPDATED() function - it is way to complex for 99% of the scenarios particularly when you need to shuffle bits and had to hope that the columns on the prod system of every customer are in exact the same order as on your dev or you would have to join the information_schema tables...
PS: just because UPDATED(x) is true, it doesn't mean, that there is really a change in this column. Just that it was used in the UPDATE / MERGE statement. For performance reasons you should always check in the WHERE if it was really changed and do your workload only on those columns that are.
God is real, unless declared integer.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply