In order to evaluate the expression @notastring + ' is not a string.', SQL Server needs to follow the rules of data type precedence to complete the implicit conversion before the result of the expression can be calculated. Because int has a higher precedence than VARCHAR, SQL Server attempts to convert the string to an integer and fails because this string cannot be converted to an integer.