How to get the sequence in SQLServer like in ORacle?

Discussions

EJB programming & troubleshooting: How to get the sequence in SQLServer like in ORacle?

  1. How to get the sequence in SQLServer like in ORacle? (1 messages)

    How to get the sequence in SQLServer like in ORacle?
    If not exit in SQLServer, How to get it?
    thankS
  2. SQLServer doesn't have sequences. The nearest thing to it is an identity column which automatically generates a new id when a row is inserted.