Dear programmers;
I have the follwing:
Create table CHILD
(
UNIQUEIDENTIFIER CID PRIMARY KEY,
fNAME VARCHAR(25),
LNAME VARCHAR(50),
)
Create table Parent
(
UNIQUEIDENTIFIER PARID PRIMARY KEY,
fNAME VARCHAR(25),
LNAME VARCHAR(50),
UNIQUEIDENTIFIER CID FOREIGN KEY REFERENCES(cHILD) CID
)
i have details of a parent and that of the parent's child.
need to save the PK of the child table into the parent table.
the input( details) come from a windows form application
How do i achieve this USING STORED PROCEDURES ?
Loading

Pradeep ChandrakerPosted Jun 27, 2011, 9:10 PM
Suthish NairPosted Jun 27, 2011, 8:16 AM