Hello,
I have tables which have relation. I want to know how can I set the PK value of table A which is the FK of table B while I can’t have “SET IDENTITY_INSERT BATTERY ON” for two table at one time?
Thank you,
csharpa
0
Newbie Poster
Recommended Answers
Jump to PostYou can't have SET IDENTITY_INSERT for more than one table at a time per database. This is a Microsoft SQL rule.
Second, if you have related two tables through a foreign key constraint, and both are using an Identity Column as their primary key... and the contraint is between …
All 3 Replies
strharl
0
Newbie Poster
What kind of relationship does your 2 tables have. eg: one2one, one2many, many2many?
csharpa
0
Newbie Poster
It is one2many
JerryShaw
46
Posting Pro in Training
You can't have SET IDENTITY_INSERT for more than one table at a time per database. This is a Microsoft SQL rule.
Second, if you have related two tables through a foreign key constraint, and both are using an Identity Column as their primary key... and the contraint is between these two table...you have bigger problems.
Primary Keys that use an Identity column should only be used on Prime tables in a relational model.
--Jerry
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.