Post reply

String or binary data would be truncated

  • August 11, 2009 at 12:08 pm

    #140794

    Msg 8152, Level 16, State 14, Line 145

    String or binary data would be truncated.

    The statement has been terminated.

    How difficult would it be for Microsoft to tell you the column and table name!?!?!?!?

    I'm sure many have struggled with this. Anybody out there got an easy way to find the offending column? I know it's fairly easy to track these things down but it just pisses me off that MS makes me figure out what column and table it is. :angry:

  • August 11, 2009 at 10:52 pm

    #1037842

    BWAA-HAA!!! Now where would the fun in that be. 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 12, 2009 at 1:03 pm

    #1038233

    I did a little research on this and found that this was suggested on the MS Connect site on 7/7/2005 and 4/22/2008. Microsoft said it was too late to include in 2005 and it would be addressed in 2008. Well guess what?

    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125347

Viewing 3 posts - 1 through 2 (of 2 total)

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