MERGE question

Hi all, I'm curious to know if anyone has tested the merge function or knows how it works more or less. Assuming that you are merging two identical tables with nearly identical values: Does it, when it finds a match, update all columns in that row, only columns that are different, or skip that row if there are no differences? I would assume the latter, but admittedly haven't tested it, so I was wondering if anyone knew the answer offhand.

Cheers,

Rick Received on Fri Nov 07 2003 - 10:30:43 CST