TRY_CONVERT large numbers

  • stephen.long.1


    Points: 2577

    Hugo Kornelis (3/5/2016)

    MMartin1 (3/4/2016)

    I wonder why int to varchar was special.

    I am sure that sometime, somewhere deep in the dark and muddy past of SQL Server (probably back in the Sybase days), someone had a compelling argument for this.

    I am not going to speculate on this one, though!

    I think the "blame" for this is on Microsoft.

    When I try the following in Sybase (Adaptive Server Enterprise 15.7), I get an error:


    ERROR: Insufficient result space for explicit conversion of INT

    value '234523' to a VARCHAR field.

Viewing post 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply