Options

Best increment practice

RedditorRedditor Member Posts: 2
Hi all.

Been reading about a lot of different practices to increment the primary key when it's an integer.

Let's say the situation is that we sometimes need to add one line (by c/al), sometimes to add n.

What is the best practice to deal with primary key? findlast on Insert trigger/auto increment/ ID := getLastId() before inserting every line/other

Comments

  • Options
    einsTeIn.NETeinsTeIn.NET Member Posts: 1,050
    That may help you.
    "Money is likewise the greatest chance and the greatest scourge of mankind."
Sign In or Register to comment.