here are a few things to ponder.... identity is not a SQL standard (SQL-92 -- not sql server)
identity does not exist in Oracle, sybase, informix, db2, or any other large db platform. identity breaks one of the 4 basic rules of a relational db --you cannot update the unique and independent keys --can't update an identity column.... I just have to take the next value in line also, there are problems with replication using Identities... there are work-arounds, but they are a pain.... Just a few things I have come across from different people. Mike ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2003 11:05 AM Subject: RE: DB Design > id love to know the outcome of this one....since we use Identity PK's > like they are going out of style :) > > tony weeg > uncertified advanced cold fusion developer > tony at navtrak dot net > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 29, 2003 10:56 AM > To: CF-Talk > Subject: Re: DB Design > > > I welcome the discussion but back it up.. > > PITA? In what ways? > > > ----- Original Message ----- > From: "Boardwine, David L." <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 29, 2003 10:50 AM > Subject: RE: DB Design > > > > Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? > > GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB > > > > > > -----Original Message----- > > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, July 29, 2003 10:48 AM > > To: CF-Talk > > Subject: SOT: DB Design > > > > > > I am working on a new DB design for a CFMX app and was doing a little > > refresher research on keys and data types and ran across this quote > > from former SQL Server project manager Ron Soukup, > > > > "Identity primary keys are for people who believe there's never time > > to design a table right but there's always time to do it over." > > > > In another related article, another MS SQL guy says that the only > > reason identity made it into SQL server was because of Access.... (not > > > a direct quote). > > > > Anyone care to comment? > > > > Mike > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
