title: What is the best way to generate an ID for a SQL Insert?
body: <p>What is the best, DBMS-independent way of generating an ID number that will be used immediately in an INSERT statement, keeping the IDs roughly in sequence?</p>