I was hoping to get a little help with a problem I am having with an insert statement that keeps returning this error message:
"Msg 8152, Level 16, State 14, Line 2 String or binary data would be truncated. The statement has been terminated."
I have created this table:
CREATE TABLE Job_title ( Job_title_id int IDENTITY NOT NULL, EEO_1_Classification varchar(35) NOT NULL, Job_title varchar(50) NOT NULL, Job_description varchar NOT NULL, Exempt_non_exempt_status varchar(15) NOT NULL, )
And I am trying to execute this Insert statement when I get the error message I noted above:
INSERT INTO Job_title (EEO_1_Classification, Job_title, Job_description, Exempt_non_exempt_status) VALUES ('Sales Workers', 'Cashier', 'Operates cash register to itemize and total customerís purchases in grocery store', 'Non-Exempt')
I have a feeling I am missing something simple, but I'm not sure and any help would be greatly appreciated.
Thank you in advance for any help offered.