Data types

Every column, local variable, expression and parameter in Querona has a data type. Querona supports the SQL Server system data types, organized — as in SQL Server — into the categories below.

To convert a value from one type to another, use CAST or CONVERT.

Exact numerics

bigint, int, smallint, tinyint, bit, decimal, numeric, money and smallmoney. See Exact numerics.

Approximate numerics

float and real. See Approximate numerics.

Date and time

date, time, datetime2, datetime and smalldatetime. See Date and time. Time-zone-aware types such as datetimeoffset are not supported.

Character strings

char, varchar and text. See Character strings.

Unicode character strings

nchar, nvarchar and ntext. See Unicode character strings.

Binary strings

binary, varbinary and image. See Binary strings.

Other data types

rowversion (and its timestamp alias), uniqueidentifier and sql_variant — see Other data types. The spatial geometry type is described in Spatial Geometry.

Querona does not support the following types internally: cursor, xml, geography and table.