Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Data Type Precedence

SQL Server 2000

When two expressions of different data types are combined by an operator, the data type precedence rules specify which data type is converted to the other. The data type with the lower precedence is converted to the data type with the higher precedence. If the conversion is not a supported implicit conversion, an error is returned. When both operand expressions have the same data type, the result of the operation has that data type.

This is the precedence order for the Microsoft® SQL Server™ 2000 data types:

  • sql_variant (highest)

  • datetime

  • smalldatetime

  • float

  • real

  • decimal

  • money

  • smallmoney

  • bigint

  • int

  • smallint

  • tinyint

  • bit

  • ntext

  • text

  • image

  • timestamp

  • uniqueidentifier

  • nvarchar

  • nchar

  • varchar

  • char

  • varbinary

  • binary (lowest)
© 2015 Microsoft