Pressing the Red Button

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...

SQL Hacks: Sequentially Numbering Records

It is a simple concept, I want each record of a SQL result set to be numbered 1 through X. Well SQL wasn't really designed to do this so here come some the ugliest hacks you'll every see to "just get it done". Here is some more background. I got contracted to write some fixes […]

Continue reading...