Transact-SQL Support for In-Memory OLTP

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

The following Transact-SQL statements include syntax options to support In-Memory OLTP:

• ALTER DATABASE File and Filegroup Options (Transact-SQL) (added MEMORY_OPTIMIZED_DATA)

• ALTER TRIGGER (Transact-SQL)

• CREATE DATABASE (SQL Server Transact-SQL) (added MEMORY_OPTIMIZED_DATA)

• CREATE PROCEDURE (Transact-SQL)

• CREATE TABLE (Transact-SQL)

• CREATE TRIGGER (Transact-SQL)

• CREATE TYPE (Transact-SQL)

• DECLARE @local_variable (Transact-SQL)
  In a natively compiled stored procedure, you can declare a variable as NOT NULL. You cannot do so in a regular stored procedure.

AUTO_UPDATE_STATISTICS can be ON for memory-optimized tables, starting with SQL Server 2016. For more information, see sp_autostats (Transact-SQL).

SET STATISTICS XML (Transact-SQL) ON is not supported for natively compiled stored procedures.

For information on unsupported features, see Transact-SQL Constructs Not Supported by In-Memory OLTP.

For information about supported constructs in and on natively compiled stored procedures, see Supported Features for Natively Compiled T-SQL Modules and Supported DDL for Natively Compiled T-SQL modules.

In-Memory OLTP (In-Memory Optimization)
Migration Issues for Natively Compiled Stored Procedures
Unsupported SQL Server Features for In-Memory OLTP
Natively Compiled Stored Procedures