Michael T. Tangorre wrote: > > "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?
I have a preference for trigger/sequence based mechanisms. They are more flexible in generating unique number primary keys and sequences will be in SQL:200x. On the other hand, I don't think identity primary keys are evil per se. It just depends on how you use them. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
