CONVERT vs. CONVERT_IMPLICIT

  • Article

Today's question comes from a friend I have in Brazil.

Please, tell-me one thing, is there any improvement in avoid Implicit Conversions forcing one explicit conversion? Or will QP behind the scenes execute the same SQL using the function CONVERT()?

These are the same at runtime.  They do vary slightly in the binding rules, but I'm not sure if there is any practical difference.  So, I would not expect to see a CPU difference between the two. 

Thanks,

 Conor