Priority of data type
When the expression of the two different data types is combined with an operator, the priority sequence rule of the data type determines which data type to be converted to another. The priority order is low in data type conversion to the priority order. Returns an error if this conversion is not supported inherent conversion. When two operand expressions have the same data type, the result of the calculation is the type of data.
Below is the priority order of the Microsoft® SQL ServerTM 2000 data type:
SQL_VARIANT (highest) DateTime SmallDatetime Float Real Decimal Money SmallMoney Bit Ntext Text Image TimeStamp Uniqueidentifier Nvarchar Nchar VARCHAR CHAR VARBINARY Binary (Minimum)
