Supported DDL for Natively Compiled T-SQL modules
Applies To: SQL Server 2016
This topic lists the supported DDL constructs for natively compiled T-SQL modules, such as stored procedures, scalar UDFs, inline TVFs, and triggers.
For information on features and T-SQL surface area that can be used as part of natively compiled T-SQL modules, see Supported Features for Natively Compiled T-SQL Modules.
For information about unsupported constructs, see Transact-SQL Constructs Not Supported by In-Memory OLTP.
The following are supported:
SELECT (Transact-SQL) and INSERT SELECT statements
SCHEMABINDING and BEGIN ATOMIC (required for natively compiled stored procedures)
For more information, see Creating Natively Compiled Stored Procedures.
For more information, see Native Compilation of Tables and Stored Procedures.
Parameters and variables can be declared as NOT NULL (available only for natively compiled modules: natively compiled stored procedures and natively compiled, scalar user-defined functions).
For more information, see Use Table-Valued Parameters (Database Engine).
EXECUTE AS OWNER, SELF, CALLER and user.
GRANT and DENY permissions on tables and procedures.