title: AutoIncrement fields on databases without autoincrement field
body: <p>In MS Sql Server is easy create autoincrement fields. In my systems I stopped to use autoincrement fields for primary keys, and now I use Guid's. It was awesome, I've got a lot of advantages with that change. But in another non-primary key fields, I really was needing implement a "soft autoincrement". It's because my system is DB independent, so I create the autoinc value programatically in c#. </p>
  
  <p>I would like about solutions for autoincrement fields on databases without autoincrement, what the solution that your use and why? There is some Sql Ansi statement about this? and generating directly from my c#, is a better solution?</p>
  
  <p>PS: I know that <em>select max(id)+1 from table</em> it's not really concurrent friendly...</p>