Post reply

Multiple Repeated Insertions

  • March 6, 2007 at 10:11 pm

    #116396

    Dear All!

    I am facing problem while inserting data to SQL Server 2000.

    I am inserting a row of records but in SQL Server it is inserting same row more than 1 at a time, just like creating more than 1 copies of a row.

    There are more than 70,000 records.

    The Front end is in ASP and SQL Server is at the back end.

    First the application gets max(ReferenceNo) then increments and inserts a new row.

    What could be the reason?

    Thanks in advance.

    Regards,

     

    Thanx + Regardz,

    Jan whY? Jan

  • March 7, 2007 at 4:16 am

    #693510

    Hi

    You can do the following way,

    > Create a primary key on ReferenceNo column or ReferenceNo column is an Identity.

    > All the operation can be handled in stored procedure.

    Hopes to solve your problem.

    Kishore.P

  • March 8, 2007 at 2:20 am

    #693737

    Thank you dear

     

    Thanx + Regardz,

    Jan whY? Jan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply