Re: FN-FORUM: asp/sql - the correct way to get the ID of the record you just added?

date posted 9th January 2007 11:38

Assuming ID is an identity, you can use SCOPE_IDENTITY


http://msdn2.microsoft.com/en-us/library/ms190315.aspx


Bruno


On 9 Jan 2007 12:11:52 -0000, Juraj Seffer [EMAIL REMOVED] wrote:
>
> Hi there,
>
> I would love to know this as well. When I had to, I searched for the
> ID of the just added record by other columns such as name, title,
> description etc to ensure that I get the one I want.
>
> Juraj
>
>
>
> On 9 Jan 2007 11:55:45 -0000, [EMAIL REMOVED]
> [EMAIL REMOVED] wrote:
> >
> > This isnt something I'm doing now, but its something I've often wondered if I do the right way, I'm fairly sure I dont.
> >
> > Imagine you have a membership database, a user signs up and you add their info to your table which automatically assigns an ID to the record. You then need to add records to a 'link' table to associate (for example) the user with a particular mailing list/s. To do that you need the ID of the record you just added for the user.
> >
> > In the past I've just done a select statement to pull out the highest ID number based on the assumtion that the highest ID will be the last record added - however if, on the rare occasion this might happen, another user signs up at the same time that ID will be wrong.
> >
> > Whats the correct way of doing it? is there one?
> >
> > --
> > Freelancers, contractors earn more with Prosperity4
> > Call 0870 870 4414 or visit www.prosperity4.com
> > and benefit from Inland Revenue approved expenses today.
> >
> > To advertise here: http://www.freelancers.net/advertising.html
> >
> >
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>