SQL Server Error String or binary data would be truncated

Question

My table    log id                 bigint old value                  xml new value                  xml module                 varchar 50  reference id           bigint  transaction           varchar 100  transaction status         varchar 10  stack trace                ntext modified on                datetime modified by                bigint   Insert Query    INSERT INTO  dbo   audit log               old value   new value   module   reference id   transaction               transaction status   stack trace   modified on   modified by        VALUES               asdf   asdf   Subscriber  4   transaction                 transaction status    stack trace  getdate   555    Error     Msg 8152  Level 16  State 14  Line 1 String or binary data would be truncated  The statement has been terminated    Why is that

User · Accepted Answer

You re trying to write more data than a specific column can store   Check the sizes of the data you re trying to insert against the sizes of each of the fields     In this case transaction status is a varchar 10  and you re trying to store 19 characters to it

User · Answer

This error is usually encountered when inserting a record in a table where one of the columns is a VARCHAR or CHAR data type and the length of the value being inserted is longer than the length of the column   I am not satisfied how Microsoft decided to inform with this  dry  response message  without any point of where to look for the answer

User · Answer

this type of error generally occurs when you have to put characters or values more than that you have specified in Database table like in this case  you specify   transaction status         varchar 10   but you actually trying to store   transaction status  which contain 19 characters   that s why you faced this type of  error in this code

[sql-server] SQL Server Error : String or binary data would be truncated

Examples related to sql-server

Examples related to sql-server-2005