I need a bulletproof routine to create unique integer IDs for inserting rows
into multiple tables in a MSSQL 7 database.

The catches are that I want the ID's to be unique in the database, not just
each table, and the generator must be available to stored procedures.

Also the generator needs to unaffected by transactions - rollbacks should
not reset the sequence of values - and the generator must not be locked by a
slow transaction.

Any bright ideas?

Stephen

 
---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"

Reply via email to