Posted by Martijn Tonies on 11/30/06 18:26

> > 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).

And InterBase, Firebird, PostgreSQL, Mimer, ThinkSQL and probably some
others that
I don't know about :-)


btw, SEQUENCE is in the SQL 2003 standard.


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

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

[Reply to this message]