This article is 5 years old.. "The problem with these is that finding the PK value of a newly inserted record requires another trip to the server and the DB -- and a lock on the database file while the DB determines the last ID inserted."
This is not true for MS SQL, you simple use @@IDENTITY or SCOPE_IDENTITY Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Yorke Hinds > Sent: Thursday, 12 February 2004 9:57 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Whats your Primary Key? > > > I am using SQL Server. > > In 1999 Hal Helms wrote a brief article on the subject - http://www.halhelms.com/index.cfm?fuseaction=newsletters.aug1999 Any comments regaring Hals Article? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
