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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

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

  1. #1
    luv Guest

    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



  2. #2
    DaveSatz Guest

    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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center