primary key

[Matt Mercer]

Hi all,

Hope I am not posting too many questions...cannot find the answer
anywhere, though. I need to know when I insert a record into my
database table what the primary key is for that record. It is
generated by SQL automatically, but I need to associate data in other
tables with it.

I can pull the highest primary key # from the table but if someone
else submits info before this happens I may get the wrong number. Is
there a way to find out what they primary key assigned is as I do the
insert? Thanks again.

 

[Hermit Dave]

if you primary key field is identity field then all you do is start a

strat trans myinsert

insert statement here

declare @myprimarykey int
select @myprimarykey == @@identity

commit trans myinsert

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)

 

[Lucas Tam]

(e-mail address removed) (Matt Mercer) wrote in

Is
there a way to find out what they primary key assigned is as I do the
insert? Thanks again.

INSERT INTO MyTable Values (1,2,3,4,5); SELECT @@IDENTITY;

Just use the statement above with a ADO.NET Command ExecuteScalar Method.