retrieving record id after adding a new record

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

retrieving record id after adding a new record

Author

Topic

NickVanOrton
Starting Member

2 Posts

Posted - 2002-07-26 : 06:55:23

hello,

i'm working on a website where i have to retrieve the id (unique identifier) from the record i just created (using addnew), without using a stored proc.
Can somebody help me ?

Thanxs

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2002-07-26 : 07:30:00

I discussed different methods in this article:
http://www.sqlteam.com/redir.asp?ItemID=9510

--
HTH,
Vyas
http://vyaskn.tripod.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources