Post reply

Server: Msg 8152, Level 16, State 9

  • October 20, 2003 at 10:21 am

    #160037

    Hi All,

    I am inserting a row into a table in strored procedure but getting the following error,How can i fix tat.

    Server: Msg 8152, Level 16, State 9, Procedure proc_name, Line 74

    String or binary data would be truncated.

    The statement has been terminated.

    Thanks in Advance.

  • October 20, 2003 at 4:43 pm

    #478879

    How about open your stored procedure up and look for the code that start with insert ....

    look at the table difinition to see what what type of data and how long of a string can the table hold. For example if the field is varchar(10) and you are trying to put 11 character in that field it will result in this error. In this case, you can make changes to your table definition or simple input less data for that particular field.

    mom

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

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