Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get PK/IDENTITY for the next record?
Message
From
31/08/2006 17:31:14
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01150231
Message ID:
01150236
Views:
26
How do you guarantee that two people don't get the same PK?

>Is it possible to get an Identity/PK of a table without adding a record? Here is what I would like to do:
>
>1. Get Identity (next PK number) for a table.
>2. Add a record to a view/cursor.
>3. Once user commands to Save the record, add a row to the table using the PK that was obtained in step 1.
>
>Is it possible?
>
>Thank you.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform