Search code examples
sql-serversql-server-2005checksum

SQL Server - CHECKSUM() ON 2005 vs 2008+ versions

I've tested the CHECKSUM() on SQL Server 2008, 2012, 2016:

SELECT ABS( CHECKSUM( 0x010006002B11E231F06C1DF20200000000000000 ) )

All versions return: 236465144

I don't have SQL Server 2005, so what will be the result on this version.

I saw that the CHECKSUM() I'm using above only applies to version 2008+.

Will the CHECKSUM() from SQL Server 2005 be the same as with other versions?

Solution

  • Can I even call CHECKSUM() on 2005? The question is: if I run the query above, what will return.

    Yes you can call it and the result is the same.

    Here is my SQL Server 2005:

    enter image description here