how to fake an objectid in sql server

written by Geoff Bowers on Friday, 15 August, 2008 @ 01:18 PM

We work with UUIDs a lot. If you have to work with application code bases that are cross platform and support multiple database servers its the most flexible primary key you'll find. But not all universally unique ids are the same. For example, ColdFusion uses an algorithm for generating them that is not the same as MS SQL Server.