search

BCRDC / Tech-Care

0 stars 0 forks source link

how to apply sequential id into your development of server-end #19

Open JHinW opened 3 years ago

JHinW commented 3 years ago

https://www.codeproject.com/Articles/388157/GUIDs-as-fast-primary-keys-under-multiple-database

what i think is most important:

It gets even more complicated, because one eccentricity of Microsoft SQL Server is that it orders GUID values 
according to the least significant six bytes (i.e. the last six bytes of the Data4 block).  
So, if we want to create a sequential GUID for use with SQL Server, 
we have to put the sequential portion at the end.  Most other database systems will want it at the beginning.