Click here to Skip to main content
Click here to Skip to main content
Search within:



Articles » Database » Database » SQL Server » Revisions
 
Comments & Discussions

Flexible numbering sequences in T-SQL

By , 13 Nov 2012
 

Revisions


  

Compare Revision Minor Date Status Editor
publicly available No 13 Nov '12 - 18:41 Available Smitha Vijayan
Updates in content.
10 No 13 Nov '12 - 18:06 Pending Michael Abramovitch
Corrected statement on creating UDF, it is not possible
9 No 13 Nov '12 - 17:44 Pending Michael Abramovitch
Fixed a syntax error in the code.
8 No 10 Feb '09 - 15:02 Available Smitha Vijayan
7 No 10 Feb '09 - 15:02 Composing Michael Abramovitch
6 No 10 Feb '09 - 11:48 Composing Michael Abramovitch
5 No 10 Feb '09 - 11:48 Composing Michael Abramovitch
4 No 10 Feb '09 - 11:48 Composing Michael Abramovitch
3 No 10 Feb '09 - 11:48 Composing Michael Abramovitch
2 No 10 Feb '09 - 11:48 Composing Michael Abramovitch
1 No 10 Feb '09 - 11:48 Composing Michael Abramovitch

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

 Michael Abramovitch
Architect
Canada Canada
Member
No Biography provided

About Article
A flexible way to generate unique numbers for things like invoice numbers.
Type Article
Licence CPOL
First Posted 10 Feb 2009
Views 14,608
Downloads 148
Bookmarked 31 times
Top News

The Next Version of Android - Some of What's Coming

Get the Insider News free each morning.
Related Videos
97 Construct 2 - rounding numbers
More on Returns
Using SQL Server 2012 T-SQL New Features
An Introduction to Sql 11 (Code Name Denali) –Part I (SSMS Features in CTP 1)
Sequence Classifiers in C# - Part I: Hidden Markov Models
Auto generated sequence number in SQL Server
The Product Aggregate in T-SQL Versus the CLR
SQL Server DO's and DONT's
An Introduction to Sql 11 (Code Name Denali) –Part II (T-Sql Features in CTP 1)
Continuous Integration for Databases with Visual Studio
Smart Card Framework for .NET
Integer Arrays Using T-SQL
The SEQUENCE object in SQL Server codenamed “Denali”
Advanced Unit Testing, Part III - Testing Processes
Use Table-Valued Functions as Arrays in SQL Server
Monitor your Web Services usage via .NET SOAP Extensions
Asynchronous T-SQL Execution Without Service Broker
Overview of SQL Server Stored Procedure
Handling multiple pending socket read and write operations
.NET random number generators and distributions
Reset PLSQL sequence value
Oracle Sequence Promotes Poorly Maintainable Code
Permalink | Advertise | Privacy | Mobile
Web04 | 2.6.130523.1 | Last Updated 13 Nov 2012
Article Copyright 2009 by Michael Abramovitch
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid