Professional Web Applications Themes

Checksum Algorithm/Collisions - Microsoft SQL / MS SQL Server

It's very easy to find checksum collisions in any data set: SELECT CHECKSUM('ABC'), CHECKSUM('ASH')   That depends what you want to use the hash result for. I don't think You can't expect CHECKSUM to reliably tell you whether two rows are identical under any cirstances. -- David Portas ------------ Please reply only to the newsgroup -- "Edward Nicholas" <com> wrote in message news:google.com... ...

  1. #1

    Default Re: Checksum Algorithm/Collisions

    It's very easy to find checksum collisions in any data set:
    SELECT CHECKSUM('ABC'), CHECKSUM('ASH')
     

    That depends what you want to use the hash result for. I don't think You
    can't expect CHECKSUM to reliably tell you whether two rows are identical
    under any cirstances.

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Edward Nicholas" <com> wrote in message
    news:google.com... 


    David Guest

  2. #2

    Default Re: Checksum Algorithm/Collisions

    You could look at red-gate software's SQL Data Compare

    --

    ----------------------------
    Allan Mitchell (Microsoft SQL Server MVP)
    MCSE,MCDBA
    www.SQLDTS.com
    I support PASS - the definitive, global community
    for SQL Server professionals - http://www.sqlpass.org



    "Edward Nicholas" <com> wrote in message
    news:google.com... 
    news:<phx.gbl>... 
    > >
    > > That depends what you want to use the hash result for. I don't think You
    > > can't expect CHECKSUM to reliably tell you whether two rows are[/ref][/ref]
    identical [/ref][/ref]


    Allan Guest

Similar Threads

  1. WebDav Server has moved. How do I correct for IP checksum?
    By Ray_Gubala@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 2
    Last Post: January 11th, 09:20 PM
  2. Shockwave DMG Checksum Error
    By Naomi2 in forum Macromedia Shockwave
    Replies: 0
    Last Post: December 29th, 04:30 PM
  3. collisions
    By :. Buzzalino \(Foros Macromedia\) .: in forum Macromedia Director 3D
    Replies: 7
    Last Post: March 8th, 09:36 PM
  4. cannot read tar archive from tape: directory checksum error
    By news.amnet.net.au in forum Linux / Unix Administration
    Replies: 1
    Last Post: August 16th, 06:59 PM
  5. Checksum errors using CPAN module
    By Paul Galbraith in forum PERL Modules
    Replies: 0
    Last Post: May 19th, 05:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139