RE: Forcing a sequence in a table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jay Vinton (anonymous_at_discussions.microsoft.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 11:26:07 -0700

There is no point in worying about the physical arrangement of data. Add a column that is timestamp, autonumber, or some other scheme like max()+1 when inserting new rows. Then use an Order By clause to sort the result.

Relevant Pages

  • Re: Confirmation number
    ... That's going to be a bit tricky, as an Autonumber field value is created ... Therefore, after inserting the record, ... unique in the database, ...
    (microsoft.public.frontpage.programming)
  • inserting a new record and retriving an autonumber value immediately...
    ... based on an "autonumber" field. ... The problem is that, immediately after inserting this record, I also need to ... primary "autonumber" field, so in order to create the related record, I need ... Is it applicable with ADO?? ...
    (microsoft.public.vb.database.ado)
  • RE: INSERT INTO and autonum, and Access-specific SQL reference/book
    ... Some thoughts on your first question: ... I assume you are inserting the values for the fields in the table and not ... I received no error message and when I checked, the autonumber had been ...
    (microsoft.public.access.queries)
  • Re: One table not updating after a few insertions
    ... Where are you inserting the row? ... Is this row fully committed to the database before you run this strange ... Why did you not go ahead and set the HeaderID at the time you ... present and the new autonumber is there. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Saving concurrently on DB?
    ... SQL Server will take care of that ... basically check to see if the timestamp is different from the value you have ... My Employee class consists of several variables (emplcode, fname, ... several users are inserting "concurrently"? ...
    (microsoft.public.dotnet.languages.csharp)