Tag Archive | "database"

GUID Primary Keys in SQL

Thursday, June 18, 2009

Comments Off on GUID Primary Keys in SQL

Creating a GUID in Microsoft SQL Server: select newid(); Creating a GUID in MYSQL: select uuid(); Why use a GUID as a primary key? The main reason is if you want to guarantee uniqueness between databases and servers. I have never been a fan of GUIDs. Especially when having to write sql statements for reports. […]

Continue reading...