quote:

---

Originally posted by cadnaani

I created this table and I am getting this syntax error please help!
Cannot insert explicit value for identity column in table 'fudgemart_timesheets' when IDENTITY_INSERT is set to OFF.

create table fudgemart_timesheets
(
timesheet_id int identity (1,1)not null ,
timesheet_payrolldate datetime not null,
timesheet_employee_id int not null,
timesheet_hours decimal(3,1)
);

--add foriegn key constriants
alter table fudgemart_timesheets
add
constraint pk_timesheet_id
primary key (timesheet_id),
constraint fk_timesheet_employee_id
foreign key (timesheet_employee_id)
references fudgemart_employees(employee_id),
constraint ck_timesheet_hours check (timesheet_hours between 0 and 60)


--Add six employees in the timesheets table

insert into fudgemart_timesheets
(
timesheet_id,
timesheet_employee_id,
timesheet_payrolldate,
timesheet_hours
)
values
(
1,
'010101007',
'9/10/2007',
'36'
)


Thanks, I did what you told me but it did not work. Now I am getting this syntax error.
The INSERT statement conflicted with the FOREIGN KEY constraint "fk_timesheet_employee_id". The conflict occurred in database table "dbo.fudgemart_employees", column 'employee_id'.

---