Posted by Tony Rogerson on 12/01/06 06:49

> 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??

--
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials


"DA Morgan" <damorgan@psoug.org> wrote in message
news:1164904167.680393@bubbleator.drizzle.com...
> ruediger.michels@feltengmbh.de wrote:
>> hi,
>>
>> 1. is there a statement in ms sql, what creates a sequence? cant find
>> anything in web :-(
>> -> oracle: CREATE SEQUENCE XYZ INCREMENT BY 1 START WITH 1 NOCYCLE
>> CACHE 20;
>> -> ms sql: ???
>>
>> 2. hwo do i create a link to another ms-sql database
>>
>> thx a lot need help, urgend :-)
>
> The only other databases that have abilities similar to those of
> an Oracle SEQUENCE are DB2 and Informix (only the most recent release).
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

• Next in forum: Re: PLEASE PLEASE HELP - How can I get a return value from a SQL Stored Proc is ASP.NET?
• Prev in forum: Enterprise Manager reporting wrong server version
• Thread view: Re: Oracle Sequence/Link 2 MS SQL SERVER 2005

[Reply to this message]