Freigeben über

FAQ: SQL Server and Sequence Objects/Generators

  • Artikel

SQL Server 2005 includes a lot of changes to help make moving from Oracle to SQL Server easier, these include;

- User Schema separation

- Multiple Active Result Sets (MARS)

- Synonyms

- Recursive Queries(CTEs)

and some other smaller issues. However there is one feature if you have any serious Orcle development, especially as an ISV, that SQL Server is missing, and thats sequence objects(this also applies to Interbase customers looking for Generator replacements).

Well I found this old post from the SQL Server Customer Advisory Team that has a good discussion.

Comments

  • Anonymous
    February 09, 2007
    Is MARS supported on the sql server compact edition?

  • Anonymous
    February 19, 2007
    MARS is not supported against CE