Is the following statement a valid example of the checksum-statement ? I've read about the * on msdn (-which does not mention the abality to use the table-qualifications as t. and o.) but am unable to test because I have a couple of days off right now
UPDATE o
SET
o.data1 = t.data1
, o.data2 = t.data2
, o.data3 = t.data3
, o.modify_date = @processing_date
, o.modify_flag = 'U'
FROM odstable o
INNER JOIN temptable t
ON t.key1 = o.key1
AND t.key2 = o.key2
AND t.key3 = o.key3
WHERE
(
checksum(o.*) <> checksum(t.*)
)
Thanks !
benchmark tests cursor vs set based are planned thursday next week (after a short vacation 🙂