Export (0) Print
Expand All

Transact-SQL Support for In-Memory OLTP

SQL Server 2014

You can access memory-optimized tables using any Transact-SQL query or DML statement (SELECT, INSERT, UPDATE, or DELETE), ad hoc statement, and SQL module such as stored procedures, table-value functions, scalar functions, triggers, and views. For more information see Accessing Memory-Optimized Tables Using Interpreted Transact-SQL.

When creating and modifying database objects (DDL statements), the following statements have been modified:

For optimized access to memory-optimized tables use natively compiled stored procedures. For more information, see Natively Compiled Stored Procedures. For information about supported features and natively compiled stored procedures, see Supported Constructs on Natively Compiled Stored Procedures and Supported Constructs in Natively Compiled Stored Procedures.

Memory-optimized tables support PRIMARY KEY and NOT NULL constraints. For information on implementing unsupported constraints, see Migrating Check and Foreign Key Constraints.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft