TechNet
Export (0) Print
Expand All

Supported Data Types

 

The following data types are supported in memory-optimized tables and natively compiled stored procedures:

Numeric Data Types

Data typeFor more information
intint, bigint, smallint, and tinyint (Transact-SQL)
bigintint, bigint, smallint, and tinyint (Transact-SQL)
smallintint, bigint, smallint, and tinyint (Transact-SQL)
tinyintint, bigint, smallint, and tinyint (Transact-SQL)
decimaldecimal and numeric (Transact-SQL)
numericdecimal and numeric (Transact-SQL)
floatfloat and real (Transact-SQL)
realfloat and real (Transact-SQL)
moneymoney and smallmoney (Transact-SQL)
smallmoneymoney and smallmoney (Transact-SQL)

String Data Types

Data typeFor more information
char(n)char and varchar (Transact-SQL)
varchar(n) 1char and varchar (Transact-SQL)
nchar(n)nchar and nvarchar (Transact-SQL)
nvarchar(n) 1nchar and nvarchar (Transact-SQL)
sysnamenchar and nvarchar (Transact-SQL)

1 Limitation is 8060 bytes per row total, counting (n) in variable-length types.

For information about supported collations, see Collations and Code Pages.

Date and Time Data Types

Data typeFor more information
datedate (Transact-SQL)
timetime (Transact-SQL)
datetimedatetime (Transact-SQL)
datetime2datetime2 (Transact-SQL)
smalldatetimesmalldatetime (Transact-SQL)

Binary Data Types

Data typeFor more information
bitbit (Transact-SQL)
binary(n)binary and varbinary (Transact-SQL)
varbinary(n) 1binary and varbinary (Transact-SQL)

1 Limitation is 8060 bytes per row total, counting (n) in variable-length types.

Other data types

Data typeFor more information
uniqueidentifieruniqueidentifier (Transact-SQL)

Unsupported Data Types

The following data types are not supported:

DATETIMEOFFSETGEOGRAPHYGEOMETRY
HIERARCHYIDLarge Objects (LOBs). For example, varchar(max), nvarchar(max), varbinary(max), image, xml, text, and ntext.ROWVERSION
sql_variantCLR functionsUser-defined types (UDTs)

Transact-SQL Support for In-Memory OLTP
Implementing LOB Columns in a Memory-Optimized Table
Implementing SQL_VARIANT in a Memory-Optimized Table

Show:
© 2016 Microsoft