You add a character data type to an integer data type like so: SELECT ‘1’ + 1. Which data type holds the result set?

You add a character data type to an integer data type like so: SELECT ‘1’ + 1. Which data type holds the result set?

You add a character data type to an integer data type like so: SELECT ‘1’ + 1. Which data type holds the result set?


Answer – Integer

(SQL Server implicitly converts dissimilar data types in the same query. Data types have a precedence, and in this example smallint will be selected.)