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.
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.