CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

by

On SQL Server Forum, at this page, it’s stated:

The built-in CHECKSUM function in SQL Server is built on a series of 4 bit left rotational xor operations. See this post for more explanation.

More Related Contents:

  1. How to get cumulative sum
  2. How to check if a column exists in a SQL Server table
  3. How to get a float result by dividing two integer values using T-SQL?
  4. Get first day of week in SQL Server
  5. SQL Server query to find all permissions/access for all users in a database
  6. SQL Server add auto increment primary key to existing table
  7. How to delete large data of table in SQL without log?
  8. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  9. Retrieve column definition for stored procedure result set
  10. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  11. Do while loop in SQL Server 2008
  12. Query times out when executed from web, but super-fast when executed from SSMS
  13. TSQL: How to convert local time to UTC? (SQL Server 2008)
  14. Regular Expressions in SQL Server servers?
  15. Unique constraint on multiple columns
  16. How to update primary key
  17. error when inserting into table having instead of trigger from entity data framework
  18. Case sensitive variables in SQL Server
  19. Transpose rows and columns with no aggregate
  20. How to find the port for MS SQL Server 2008?
  21. How to convert number of minutes to hh:mm format in TSQL?
  22. SQL Server Configuration Manager cannot be found
  23. SQL Server recursive query
  24. Temporarily disable all foreign key constraints
  25. How do I move a table into a schema in T-SQL
  26. nvarchar(max) vs NText
  27. How to find the boundaries of groups of contiguous sequential numbers?
  28. How to wait for 2 seconds?
  29. How to choose the clustered index in SQL Server?
  30. Populate Dataset With Table Names From Stored Procedure

Leave a Comment