How to save a foreign key to another table
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 ?