-
sequence in oracle ..what is there in sql expect identity
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
-
Re: sequence in oracle ..what is there in sql expect identity
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
>
>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|