String or binary data would be truncated. The statement has been terminated.Help me?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kefelegn
    New Member
    • Jul 2010
    • 1

    #1

    String or binary data would be truncated. The statement has been terminated.Help me?

    i am using sql 2005 and asp.net and code behind C#
    when i try to insert data to table it says "String or binary data would be truncated.
    The statement has been terminated." any one help me pls
    be fast
  • Christopher Nigro
    New Member
    • Jul 2010
    • 53

    #2
    It would be faster to Google the exception than to wait for someone to answer it here. Anyway, one of your text values is too long for the column that you are trying to insert into. Either increase the length on that column, shorten the value you are trying to insert or do input validation and verify that the values aren't too long before you try to insert them.

    Comment

    Working...