SQL, id will increase in case of unsuccessful insertion, how to change this behavior?

Question

SQL

If an error occurs during insertion, the id counter will still increase. Is there any way to change this behavior?

Answer 1

You can't, but you can use SEQUENCE instead of IDENTITY

Answer 2

You can do it, even wkololo_4ever showed you how, but sometimes it's better to understand the reasons for this behavior. If you make data imports sequential INSERT execution, then such things are extremely necessary to wrap in a transaction, and in case of an error, roll back the transaction and deal with the error.

Answer 3

Actually not how. If I'm not mistaken, this is protection against duplicated recording, under load.
Therefore, it is better to beat all this already in the logic of the program.