|
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
Navigation:
[Reply to this message]
|