September 4, 2002 at 4:54 pm
Is this what you are looking for:
create table t2 (id int identity primary key)
create table t3 (id int identity,
a int references t2(id),
b int references t2(id))
-------------------------
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
September 4, 2002 at 8:14 pm
Actually, I forgot one detail....I am trying to set up cascading updates on these FK's as well....your script works, but if you try to set up cascading updates with it, it will give you the multiple paths error...is there any way to set this up?
September 5, 2002 at 7:37 am
Details......
Check out this article for more information about your problem.....
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321843
-------------------------
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply