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
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για