Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Next Number generator
Message
From
23/07/2001 10:23:45
Pascal Declercq
Enter Computers
Marke, Belgium
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Next Number generator
Miscellaneous
Thread ID:
00533898
Message ID:
00533898
Views:
63
I have a situation where I need to generate a next number where I can't use the identity column of a table.

Can anyone give me sample code on how doing this using an NEXT_NO table, handling locking, transaction etc ... ?
Pascal.declercq@advalvas.be
Next
Reply
Map
View

Click here to load this message in the networking platform