hi

is there any equlent(equal) statment in sql server 2000 like create sequence
in Oracle .which suppose to be help for multiple user when inserting value
for same table , i know identity in sql is it help for when user insert multiple
simltenouls 2 recorsd for which record the first no will assign.

thanks