The Updated Columns List

Question

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Toreador SSChampion Points: 11382 More actions · Answer 1

I really dislike this function, as it requires knowledge of how the table was initially created.

Create table t1 (c1 int, c2 int)

will return different results for this function from

Create table t1 (c2 int, c1 int)

For this reason (plus readability) I stick to Update() (with a load of ORs to check several columns at once).