• The following link should help you understand data type precedence better:

    http://msdn.microsoft.com/en-us/library/ms190309(v=sql.100).aspx