Post reply

String or binary data would be truncated

  • February 25, 2011 at 1:49 pm

    #147405

    When I run this statment:

    Update dbo.tbl_UserProfile_Info

    set

    Country=c.Country_Name,

    Hiring_Country=mit.dbo.propercase(RTrim(c.Country_Name)),

    Current_location=mit.dbo.propercase(Rtrim(c.Country_Name))

    From dbo.Employees ne,

    dbo.HRIS_CRS_Office_Country c, tbl_UserProfile_Info u

    I get the following error:

    Msg 8152, Level 16, State 14, Line 1

    String or binary data would be truncated.

    The statement has been terminated.

    How can I fix it?

    Thank you

  • February 25, 2011 at 1:56 pm

    #1291763

    One of the columns you are updating is smaller than the data you are trying to insert into it. You will have to figure out which one and adjust the column size.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

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

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