HASHBYTES with a Memory Optimized table

Andre 26 Reputation points

HASHBYTES isn't allowed with an In-Memory table in an Azure Managed Instance. Nor is CHECKSUM, or BINARY_CHECKSUM. What is the alternative to creating a hash field, that's deterministic so I can add an index on it, with an In-Memory table?

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,582 questions
{count} votes