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)
CREATE DATABASE (SQL Server Transact-SQL) (added MEMORY_OPTIMIZED_DATA)
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.
See Also
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
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru