Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Execution plan uses CONVERT_IMPLICLIT , But i have mention CAST in where clause RE: Execution plan uses CONVERT_IMPLICLIT , But i have mention CAST in where clause

  • November 25, 2013 at 4:54 am

    #1668753

    Not sure if this is what you are referring to...

    SQL Server apparently treats CAST as CONVERT:

    http://beyondrelational.com/modules/2/blogs/77/posts/11334/cast-vs-convert-is-there-a-difference-as-far-as-sql-server-is-concerned-which-is-better.aspx