Home Forums Cloud Computing SQL Azure - Development Heads up on changes to the CHECKSUM function in APDW RE: Heads up on changes to the CHECKSUM function in APDW

  • January 5, 2017 at 3:23 pm

    #1921002

    Grant

    Same value (1132495864) on 2008 R2 (SP2) - 10.50.4042.0 (X64), collation Latin1_General_CI_AS

    Same value (1132495864) on 2014 - 12.0.2269.0 (X64), collation Latin1_General_CI_AS

    I'll post other results when I get to the machines.

    select checksum( cast('abc' as char(3))) as [AsChar], checksum( cast('abc' as nchar(3))) as [AsNChar]

    select @@version

    select SERVERPROPERTY('collation')

    pcd