Posted by DA Morgan on 12/01/06 16:32

Tony Rogerson wrote:
>> The only other databases that have abilities similar to those of
>> an Oracle SEQUENCE are DB2 and Informix (only the most recent release).
>
> What about ROWNUMBER() in SQL Server 2005 and PARTITION??

Totally different capabilities.

A sequence is not tied to a table: It is an independent object.

One can use a sequence to number count by any increment positive or
negative, assign the values to one table or to multiple tables, and
to repeatedly cycle through a fixed set of numbers (min to max and
back to min), and much more.

Maybe in SQL Server 2009?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[Back to original message]