More on Implicit Conversions

Yesterday, a reader posted a question asking me to comment on SQL Server’s algorithm for choosing implicit conversions.  When SQL Server encounters an expression with mismatched types, it has two options.  It can execute the query with an implicit conversion or it can fail with an error.  Before digging into the implicit conversion scenario, let’s…

4