quote:

---

Originally posted by Jeaneene

So, I'm getting that message, and I'm not sure what to do.

Here is my code for creating my "Employee" table:

CREATE TABLE Employee
(
Employee_ID BigInt PRIMARY KEY IDENTITY(100,25),
Last_name Varchar(50) NOT NULL,
First_name Varchar(50) NOT NULL,
Address Varchar(100) NOT NULL,
City Varchar(50) NOT NULL,
State Varchar(2) NOT NULL,
Telephone_area_code Varchar(3) NOT NULL,
Telephone_number Varchar(8) NOT NULL,
EEO_1_classification VarChar(50) NOT NULL,
Hire_date Varchar(10) NOT NULL,
Salary Decimal(7,2) NOT NULL,
Gender Varchar(1) NOT NULL,
Age Varchar(2) NOT NULL
);
GO

Now, here is my code to insert 1 row of data:
INSERT INTO Employee
(Last_name,First_name,Address,City,State,Telephone_area_code,Telephone_number,EEO_1_classification,Hire_date,Salary,Gender,Age)

VALUES
('Edelman','Glenn','175 Bishops Lane','La Jolla','CA','619','555-0199','Sales Workers','10-07-2003','$21,500.00','M','64')


What have I done wrong? Please help! Thanks in advance!

---