www.sqlservercentral.com

Question

www.sqlservercentral.com

nevergiveupjohnbenny

Newbie

Points: 7
More actions
April 21, 2008 at 4:30 am

#185626

sir i have a problem while creating a procedure to insert values with a table containing foregin key please help

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

Hi

Are you getting the Foreign key violation error. Foreign keys are mean to to enfore relationships between tables. A foreign key column(s) in one table points to PrimaryKey or Unique Index column(s) in another table. The values you are inserting into a Foreign key column should be the same that are in the Perimay key columns.

Ex:- Employee table (EmpID , Name...) - EmpID is the Pkey

EmployeeLeaves table (EmpID,LeaveType,LeaveDate...). EmpID is the Foreign key, it points to EmpId in employee table.

"Keep Trying"

ChiragNS One Orange Chip Points: 26137 More actions · Answer 2

ChiragNS

One Orange Chip

Points: 26137

April 23, 2008 at 12:03 am

#805878

No response 😉

"Keep Trying"

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 3

hi

r u getting any errors.

thanks -- vj

http://dotnetvj.blogspot.com

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 4

The OP "left the building" 2 months ago...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

karthik M One Orange Chip Points: 29139 More actions · Answer 5

I think lot of peoples are coming here for one day and leaving.

karthik