quote:
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 nowUPDATE 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.*)
)
That would be a No. * will not work in this case.
And I do have to say SeekQuel that is an unique approach. Have to use sometime myself now.