Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by adrianblunt
-
Oracle-like Sequence Generator
I was thinking along those lines as well - I was just hoping that there was an out-of-the-box solution I had overlooked! Thanks for your help!- adrianblunt
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Oracle-like Sequence Generator
I need to be able to retrieve a unique number from a sequential list from a SQL Server 2000 database (like the SEQUENCE object in Oracle). There doesn't seem to be anything quite like this in SQL Server - I have read previous posts here, and all replies suggest using an IDENTITY fiels. However...- adrianblunt
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
