July 5, 2005
@ 01:40 AM
Comments [0]
SQL Server and Mistaken Identity
 have learned to really dislike SQL Servers IDENTITY feature. (Those of us more familiar with Oracle, think of an IDENTITY column as a Sequence built into a table.)

In a hurry I tossed in dozens of IDENTITY columns, used em as FK’s all over as well, and then had to re populate a table….  Oh oh, now I remember why you don’t use IDENTITY with impunity!

Sigh…..

Back to the drawing (design) board. Being sloppy because I was in a hurry is no excuse, but now we get to pay the piper. (Must be a rich SOB by now!)

-Robert Porter


 
Categories: Misc | Repost from Blogger | SQL


« Swanson's 25 Unwritten Rules of Manageme... | Home | Relaunch of BlogOfBob In Progress! »
Comments are closed.