Posted by Wes Groleau on 12/02/06 04:57

INSERT INTO X ...... ( A, B, C )
INSERT INTO Y ...... ( J, K, L )

If Y has a foreign key M which is the primary key D of X,
is there an easy and/or efficient way to have SQL Server
assign D, and tell us what it is so we can add M to the
list for Y ?

I know I can select D where A, B, C but I wondered about
other tricks.

--
Wes Groleau
Alive and Well
http://freepages.religions.rootsweb.com/~wgroleau/

• Next in forum: Re: SELECT UNTIL ?
• Prev in forum: Re: Table Partitioning on a RAID 5 Server
• Thread view: Setting foreign key on insert

[Reply to this message]