Supported Constructs on Natively Compiled Stored Procedures

 

This topic lists the supported constructs on natively compiled stored procedures.

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

The following are supported:

  • CREATE PROCEDURE

  • DROP PROCEDURE

  • SCHEMABINDING (required for natively compiled stored procedures)

  • NATIVE_COMPILATION

  • Parameters can be declared as NOT NULL.

  • Table-valued parameters.

The following are supported:

  • For procedures: EXECUTE AS OWNER, SELF, and user.

  • GRANT and DENY permissions on tables and procedures.

Natively Compiled Stored Procedures

Show: