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.