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)
 retrieve a automatic generated primary key

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-08-25 : 07:44:20
Gerwin writes "I use a SP to store information collected from a form en send It to a table white a automatic generated primary key option. The problem is that it is very hard to retrieve the primary key from de record I've just saved. I have tried to use the GET LAST ROW option but it is not working, besides this will fail when many users are online.

Is there a option to use a select statement in a insert or is there a special syntax I've not heard from

Thanks in advanced

Gerwin
Holland


windows nt
sql server 7"

   

- Advertisement -