Post reply

NEED HELP WITH ERROR MESSAGE

  • February 14, 2012 at 2:36 pm

    #391558

    I'm not sure what I'm doing wrong. This is my syntax and the error:

    INSERT INTO Employee

    (EmployeeID, LastName, FirstName, Address, City, State, TelephoneArea, TelephoneNum, HireDate, Salary, Gender, Age, Job_title)

    values (123, 'Edelman', 'Glenn', '175 Bishops Lane', 'La Jolla', 'California', '619', '555-0199',' 2003-09-15', '10.00', 'Male', '25', 'Cashier')

    Msg 8152, Level 16, State 4, Line 1

    String or binary data would be truncated.

    The statement has been terminated.

    Thank you,

    Sara

  • February 14, 2012 at 2:41 pm

    #1447067

    You're trying to insert more data into a column than it will allow. Check the lengths of the various character fields in that table against the data you're trying to insert and see which column it is.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 14, 2012 at 2:47 pm

    #1447071

    Thank you! Thank you! Thank you! 😀

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

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