Posted by Martijn Tonies on 11/30/06 14:57

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

Microsoft SQL Server doesn't have sequences. It does have some sort
of auto-increment integer thingy for columns, check out "identity" in the
documentation.


--
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: Re: Oracle Sequence/Link 2 MS SQL SERVER 2005
• Prev in forum: Re: Need Emergency Help with SQL Query (difficulty: moderate)
• Thread view: Re: Oracle Sequence/Link 2 MS SQL SERVER 2005

[Reply to this message]