Results 1 to 2 of 2

Thread: Sequence tables

  1. #1
    Join Date
    Jan 2006
    Posts
    119

    Unanswered: Sequence tables

    Hi,
    I am migrating a project from Oracle to SQLServer and must use the same DDL.
    The entities have compound primary keys. In Oracle I ensure the compound key is unique by using a sequence table to generate one of the values for the compound key.
    Does SQL Server have sequence tabels or does anybody know a way to get it do something similar?
    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    similar: IDENTITY column
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •