create table a1
(
imgid int primary key identity(1,1),
headline varchar(100),
description varchar(400)
)
create table a2(imgid int foreign key references a1(imgid) on delete cascade,a5 varchar(10),a6 varchar(10))
select * from a2
create table a1
(
imgid int primary key identity(1,1),
headline varchar(100),
description varchar(400)
)
create table a2(imgid int foreign key references a1(imgid) on delete cascade,a5 varchar(10),a6 varchar(10))
insert into a2 values(1,'b','c')-----this one is wrong
select * from a2
in this case i am not entering the imgid values from frontend now wat can i do?
|
| Author: sathiyasivam 01 Sep 2007 | Member Level: Diamond | Rating:  Points: 2 |
Hi Raaj
I can't get you ,coulg you explain me claerly. What error ur getting ?
|