SQL Server Datatypes
	datetime (highest) smalldatetime float real decimal money smallmoney int smallint tinyint bit ntext text image timestamp nvarchar nchar varchar char varbinary binary uniqueidentifier (lowest)

Table 3 Me First. This table shows SQL Server datatypes in order of precedence, highest to lowest. The datatype precedence rules govern which datatype is converted to another when different datatypes are used in an expression.