Are there ways to generate a unique ID for a client, not in UUID or GUID format, but a simple integer?

Question

SQL

Are there ways to generate a unique ID for a client, not in UUID or GUID format, but a simple integer?

Answer 1

INT field with AUTO_INCREMENT in the database.
Most likely it is already there.

Answer 2

C# has the ability to create a unique int using System.Threading.Interlocked.Increment.
It looks like this:

private static int tick = Environment.TickCount;
public int Id
{
    get{return Interlocked.Increment(ref tick);}
}

For your specific case, I think it's still worth using the option described in other answers (using auto_increment). But in the general case, if a similar task arises not only within the framework of working with the database, it is useful to know about this possibility.

Answer 3

In MSSQL, there is a property of the IDENTITY field, one way or another, if you store it, then you should use it, do the clustered index by UUID, this is killing the database performance. What is wrong with such a field?