Not all operators are created equal

While the number of commands that are supported for natively compiled T-SQL in SQL Server 2017 has expanded, unfortunately, a significant number of the most powerful T-SQL commands are still not available for In-Memory OLTP solutions.

The following notable operators are unsupported in SQL Server 2017:

LIKE
CASE
INTERSECT
EXCEPT

Attempting to use these operators inside a natively compiled stored procedure or scalar function will result in an error message explaining that the syntax is not supported, shown as follows:

The operator 'LIKE' is not supported with natively compiled modules.

The list of unsupported operators and commands is getting smaller with each subsequent release of SQL Server. One major addition in the 2017 release is the APPLY operator, which is now fully supported in natively compiled T-SQL.
A full list of unsupported operators can be found on the Microsoft Books Online page: https://msdn.microsoft.com/en-us/library/dn246937.aspx#Anchor_4.

It is important to understand that these T-SQL limitations are for natively compiled T-SQL (stored procedures and scalar functions). You are still able to write interpreted T-SQL (non-natively compiled T-SQL) using these commands. For example, it is perfectly fine to query a memory-optimized table and issue a LIKE operator to search in a character column.

Table of Contents for Not all operators are created equal

Create new playlist

Sign In

Sign Up

Table of Contents for
Not all operators are created equal