Export (0) Print
Expand All

Supported Data Types

SQL Server 2014

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

Numeric Data Types

String Data Types

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 type

For more information

date

date (Transact-SQL)

time

time (Transact-SQL)

datetime

datetime (Transact-SQL)

datetime2

datetime2 (Transact-SQL)

smalldatetime

smalldatetime (Transact-SQL)

Binary Data Types

Data type

For more information

bit

bit (Transact-SQL)

binary(n)

binary and varbinary (Transact-SQL)

varbinary(n) 1

binary and varbinary (Transact-SQL)

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

Other data types

Data type

For more information

uniqueidentifier

uniqueidentifier (Transact-SQL)

Unsupported Data Types

The following data types are not supported:

DATETIMEOFFSET

GEOGRAPHY

GEOMETRY

HIERARCHYID

Large Objects (LOBs). For example, varchar(max), nvarchar(max), varbinary(max), image, xml, text, and ntext.

ROWVERSION

sql_variant

CLR functions

User-defined types (UDTs)

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

Community Additions

ADD
Show:
© 2014 Microsoft