MAX + 1

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dear Professional,

I am creating new stored procedure but before inserting new row in the table
I am using MAX(ID) + 1 to get the maximum nunmber and insert into table. I
don't want to use IDENTITY(1,1) becauase sometimes the IDs are not in
sequence.

I am wondering, if same stored procedure access simultaneously, do I get
primary violation error? I remember I encountered this problem three years
ago when I was working on e-commerce application.

Please advice

Thanks
.

Relevant Pages

  • RE: Database updating issue
    ... I started a transaction on the connection class, passed this to the dataadapter, invoked the Update method on the dataadapter and finally commit the transaction. ... try threading the these calls to the stored procedure. ... To accomplish this task, the inserting of all rows, at the moment, I'm using ...
    (microsoft.public.dotnet.framework)
  • Re: how to make rolling tables
    ... > it gets purges of a portion of the oldest data so that we can go on ... It is basically a rolling log, ... Just use a stored procedure. ... Inserting is easy. ...
    (comp.lang.java.databases)
  • Re: The fastest way to update a database
    ... For the whidbey alpha we released two features that are greatly going to ... >> new item that must be inserted an SQL stored procedure is invoked. ... each row in this object must be inserted into the database. ... >> To accomplish this task, the inserting of all rows, at the moment, I'm ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlTransaction wont commit
    ... > to commit after each record is inserted but it doesn't seem to work. ... > need to commit each time because I sleep the thread after inserting 10 ... > //assign parameter code etc etc ... Show the contents of the stored procedure as well as the parameters being ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How can I get records in batches instead of all at once ?
    ... I don't think inserting the rows from original table into the temp. ... > Can ADO return the records in batches? ... >> Paging through Records using a Stored Procedure: ...
    (microsoft.public.vb.general.discussion)