sequence in oracle ..what is there in sql expect identity

[luv]

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

[DaveSatz]

Identity should work fine with an INSERT/SELECT if that is what you mean.
Here is an ex.:

drop TABLE #x

CREATE TABLE #x
( id int identity
, name sysname )
go

INSERT #x (name)
SELECT name
FROM sysobjects
WHERE TYPE = 'u'
ORDER BY name

SELECT *
FROM #X

GO
--

HTH,
David Satz
Principal Software Engineer
Hyperion Solutions
{ SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------

"luv" <luvaru@yahoo.com> wrote in message news:3b8e5462$1@news.devx.com...
>
> 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
>
>