Data Direct
Frontiers in Data Access: The Coming Wave in Data Services
|
Did you read today's front page stories & breaking news?
BLOG-N-PLAY.COM Who is reading your blog anyway? -Start blogging at your favorite magazine's Website and get published in less than three minutes! blog-n-play.com SYS-CON MAGAZINES |
TOP MICROSOFT .NET LINKS SQL Server 2005
A Point of Order: Organize Your Data with SQL Ranking Functions
Sequential numbers. Sooner or later, you'll find a process that requires you to generate a series of sequential numbers. As a matter of fact, most database engines provide at least one method of producing such numbers. Microsoft Access, for example, has AutoNumber columns, while SQL Server has IDENTITY columns. However, these are features of tables. There are times when you need some sequential numbers, but creating a table is inconvenient or inefficient. So how does one proceed? How does one obtain a list of sequential numbers without creating tables?
Reader Feedback: Page 1 of 1
FEATURED WHITE PAPERS YOUR FEEDBACK
HOT DISCUSSIONS
SUBSCRIBE TO THE WORLD'S MOST POWERFUL NEWSLETTERS |
SYS-CON FEATURED WHITEPAPERS BREAKING NEWS FROM THE WIRES
IT SOLUTIONS GUIDE PARTNERS
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||