This is my database it executes with no error.
--Kudler Fine Food Database Create Database [VALMKudler_Fine_Foods] On Primary (NAME=VALM_KudlerDB, FileName="C:\POS410\VALM_KudlerDB_dat.mdf", SIZE=10MB, MAXSIZE=100MB, FILEGROWTH=10%) --Kudler Fine Foods LOG ON (NAME="VALM_KudlerDB_log", FILENAME="C:\POS410\VALM_KudlerDB_log.Idf", SIZE=5MB, MAXSIZE=100MB, FILEGROWTH=20%)
This is my table it executes with no problems
--Job Tittle Table CREATE TABLE [VALMKudler_Fine_Foods].dbo.tbljobtitle ( jobID Int CONSTRAINT PK_jobID PRIMARY KEY Not Null, jobEEO_1Class char(40) Not Null, jobTitle char(40) Not Null, jobDesc char(300) Not Null, jobExempt_NonExe char(20) Not Null)
This is the insert I'm trying to execute but it keep coming up with errors.
--Accounting Clerk INSERT INTO[VALMKudler_Fine_Foods].dbo.tbljobtitle ( [jobID], [jobEEO_1Class], [jobTitle], [jobDesc], [jobExempt_NonExe] ) VALUES( '2000', 'Office/Clerical', 'Accounting Clerk' 'Computes, classifies, records, verifies numerical data for use in maintaining accounting records.', 'Non Exempt' ) --Assistant Manager INSERT INTO[VALMKudler_Fine_Foods].dbo.tbljobtitle ( [jobID], [jobEEO_1Class], [jobTitle], [jobDesc], [jobExempt_NonExe] ) VALUES( '2010', 'office/Clerical', 'Assistant Manager', 'Supervises and coordinates activities of workers in department of food store. Assists store manager in daily operations of store.', 'Exempt' )
And here is the error message:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near ']'.
Msg 102, Level 15, State 1, Line 51
Incorrect syntax near 'Places customer orders in bags. Performs carryout duties for customers.'.
No matter what I try I still get an error message when I try to execute my inserts. I'll take any suggestions or ideas!