Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hrishi_des
Yak Posting Veteran
76 Posts |
 Posted - 2007-01-24 : 08:25:20
|
| We need to comapre records from a oldanalysis to new analysis.we are thing of using Checksum,binary_checksum to compare rows in SQL 2005.Does anybody has used it before and are there any shortcomings of that.regards,Hrishikesh |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-01-24 : 12:39:19
|
| It is possible to generate 2 identical binary_checksums values from different inpuut values....but if you get different binary_checksums values, then you can definitely say the input values are different.search here for info on same...from other members. |
 |
|
|
hrishi_des
Yak Posting Veteran
76 Posts |
Posted - 2007-01-25 : 03:09:17
|
| can be specify the size of checksum generated? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-25 : 03:23:13
|
| The size? It is 4 bytes (32 bit) long, an integer value between -2147483648 and +2147483647.Peter LarssonHelsingborg, Sweden |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
lobsterZoom
Starting Member
9 Posts |
Posted - 2007-04-23 : 05:29:28
|
| (Spam Removed) |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-23 : 05:30:17
|
| SPAM!! AGAIN!!!4th...Peter LarssonHelsingborg, Sweden |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-08-01 : 12:05:06
|
| Here is an example of such records that create the same checksums.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33567&SearchTerms=BINARY_CHECKSUM |
|
|
|
hrishi_des
Yak Posting Veteran
76 Posts |
Posted - 2007-08-02 : 00:50:31
|
| I finally used hashbytes its more unique and works fast too!!!When solution is simple, God is answering…. |
|
|
|
|
|
|
Binary_checksum