generating unique sequence number

[vj]

Is there wa way to generate unique sequence numbers in SQL server?
(just like the way it is in Oracle i.e. seqeuence and then use nextval)

[Craig]

Identity column datatype generate a unique number and are well documented in BOL.......


------------
vj at 7/19/00 2:58:32 PM

Is there wa way to generate unique sequence numbers in SQL server?
(just like the way it is in Oracle i.e. seqeuence and then use nextval)

[vj]

I know about identity column, I need these numbers to do buisness processing
such as make each file name unique, not to insert in tables.
SQL server does seem to have newid() function but that's in hex.
Something like that I am looking for, i.e. function, or sequence, etc.


------------
vj at 7/19/00 2:58:32 PM

Is there wa way to generate unique sequence numbers in SQL server?
(just like the way it is in Oracle i.e. seqeuence and then use nextval)