Home Forums SQL Server 2008 T-SQL (SS2K8) Odd SQL conversion error "August 2012" RE: Odd SQL conversion error "August 2012"

  • September 7, 2012 at 10:36 am

    #1535171

    Andrew-495157 (9/7/2012)

    I had thought that SQL coerced the @OrderID int value to a varchar to do the comparison

    You are suggesting that SQL does the coercion the other way - coerces all column value to an Int to compare to @OrderID?

    Here is the error message, "Conversion failed when converting the nvarchar value 'August 2012' to data type int.'".

    SQL Server was attempting an implicit conversion from nvarchar to int to accomplish the comparision.