I need to be able to create a new record in a table and return the
AutoIncremented ID fields contents so I can be sure that no two people can
try to use the same ID Number.

Any suggestions, I have been looking for a while now, and I just do not seem
to making any headway.

Check out SCOPE_IDENTITY() in the BOL.

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com


"Atley" <atley_1 (AT) homtmail (DOT) com> wrote

I need to be able to create a new record in a table and return the
AutoIncremented ID fields contents so I can be sure that no two people can
try to use the same ID Number.

Any suggestions, I have been looking for a while now, and I just do not seem
to making any headway.

See SCOPE_IDENTIY() and @@IDENTITY in BOL.



AMB

"Atley" wrote:

Could you tell me What is BOL ? Thx

--
..
"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> ???
news:Oo23jwW3EHA.3840 (AT) tk2msftngp13 (DOT) phx.gbl ???...

Books Online (BOL) is the documentation that comes with SQL Server. When you
install the product you'll get the Books Online installed also.
It should always be the first place you look for answers.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


"Agnes" <agnes (AT) dynamictech (DOT) com.hk> wrote

Books On Line - the help file in SQL Server 2000

--
David Gugick
Imceda Software
www.imceda.com

I looked at those,

But I am worried because this is for an application where several people (up
to 20) could be making a new record at the same time. They just seem to
return the last identity entered.

I also didn't see in either of the examples if it could really help me
create a new record and then return the value of the ID field I specify.

Has anyone had to do this before and if so, how did you do it?




"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

I looked at those,

But I am worried because this is for an application where several people (up
to 20) could be making a new record at the same time. They just seem to
return the last identity entered.

I also didn't see in either of the examples if it could really help me
create a new record and then return the value of the ID field I specify.

Has anyone had to do this before and if so, how did you do it?



"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

I looked at those,

But I am worried because this is for an application where several people (up
to 20) could be making a new record at the same time. They just seem to
return the last identity entered.

I also didn't see in either of the examples if it could really help me
create a new record and then return the value of the ID field I specify.

Has anyone had to do this before and if so, how did you do it?

"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

Read the documentation more closely. Tom's suggestion is correct, assuming
the table involved uses an identity column. However, I can also interpret
your comments as an issue with a custom identity-column alternative design.
If so, then perhaps you should re-state the problem and show us the DDL and
code.

"Atley" <atley_1 (AT) homtmail (DOT) com> wrote