'identity' is not the same as a sequence. An identity column is a self incrementing column for use as a PK. As it's only use is to increment a column value, it is not quite as powerful as a sequence.
Jared On Fri, 2003-10-24 at 11:44, Abey Joseph wrote: > My workplace is going in the same direction as David Mitchell's. Our OLTP > systems are Oracle, basically everything else is being (or being considered) > migrated to MSSQL2000. > > I am not that familiar with SQL Server, but I believe SQL2000 has sequences. > I think MS calls it identity. I think MS also has IOT, which they call > clustered indexes. MS might even have function based indexes with SQL2000, > but not very sure. Anyone care to comment? > > Abey. > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, October 23, 2003 11:19 PM > > > > > -----Original Message----- > > > From: Ryan [mailto:[EMAIL PROTECTED] > > > Sent: Friday, 24 October 2003 12:44 > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Oracle pricing ain't going down > > > > > > > > > what is MSEE lacking in? > > > > <sound of can of worms opening> > > > > Here's a start. MSSQLServer EE has ... > > > > No bitmap indexes, no partitioned indexes, no function-based indexes, no > domain indexes, no reverse key indexes, no object tables, no before triggers > (can be kludged, not pretty), no multiple actions per trigger event, no > 3rd-party language support a la Oracle's JVM and pro*... modules, no > built-in OLAP (it's a weird bolt-on), no control over extent size, no > control over block size, no star query optimisation, no sequences, no > synonyms, no packages, no structured exception handling in stored proc > language (TSQL), no MINUS union operator, no multiplexing or mirroring of > log files, no cyclical log management, no escalation-free locking, no index > organised tables. > > > > (Working with both every day, do you get the feeling I've been asked this > before? :-)) > > > > Half of those things are available in Oracle SE One :-) > > > > Ciao > > Fuzzy > > :-) > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Grant Allen > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Abey Joseph > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).