How to get the sequence in SQLServer like in ORacle?
If not exit in SQLServer, How to get it?
thankS
-
How to get the sequence in SQLServer like in ORacle? (1 messages)
- Posted by: afancy liu
- Posted on: December 06 2001 23:03 EST
Threaded Messages (1)
- How to get the sequence in SQLServer like in ORacle? by Darren Abbruzzese on December 07 2001 05:19 EST
-
How to get the sequence in SQLServer like in ORacle?[ Go to top ]
- Posted by: Darren Abbruzzese
- Posted on: December 07 2001 05:19 EST
- in response to afancy liu
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.