Wednesday, 27 August 2008

CHECKSUM on Temporary tables (Temp db)

I was attempting to compare rows using CHECKSUM on sql 2005 when I came across this issue >
Storing my data in a #table (temporary table), I tried to use CHECKSUM to compare with the target table.
Despite the data being identical, different CHECKSUM values pervailed.

The good news is that a little googling proved it is sorted in sql 2008....

No comments: