Skip to content

SQL Server Data Type Precedence

  • Data Type Precedence

    When an operator combines expressions of different data types, the data type with the lower precedence is first converted to the data type with the higher precedence.

  • Data Type Synonyms

    Data type synonyms are included in SQL Server for ISO compatibility. Data type synonyms can be used instead of the corresponding base data type name in data definition language (DDL) statements, such DECLARE @variable, CREATE TABLE or CREATE FUNCTION.

  • DATETIME vs SMALLDATETIME

    Shows the similarities and differences between the DATETIME and SMALLDATETIME data types.

  • DATETIME vs DATETIME2

    Shows the similarities and differences between the DATETIME and DATETIME2 data types.

  • GEOMETRY vs GEOGRAPHY

    Shows the differences between the GEOMETRY and GEOGRAPHY data types.

  • MONEY vs SMALLMONEY

    Shows the similarities and differences between the MONEY and SMALLMONEY data types.

  • Spatial Instantiable Data Types

    SQL Server introduced three new spatial instantiable types, namely CircularString, CompoundCurve and CurvePolygon, which are circular arc segments. A circular arc segment is defined by three points in a two dimensional plane and the third point cannot be the same as the first point.