3 ms·
MSSQL does have a similar identifier, though - NEWSEQUENTIALID.
by zamalek 10y ago
MSSQL does have a similar identifier, though - NEWSEQUENTIALID.
- lazulicurio 10y agoYes, but NEWSEQUENTIALID isn't globally ordered, it's only ordered for the computer on which it was generated. For that matter, on a single computer the ordering isn't guaranteed[1]. This makes NEWSEQUENTIALID fairly useless if you're looking to merge records from disparate sources and sort them independently of origin. [1] https://connect.microsoft.com/SQLServer/feedback/details/475131/newsequentialid-is-not-sequential https://connect.microsoft.com/SQLServer/feedback/details/475...
- zamalek 10y agoAh right, I stand corrected.