And thanks to Tim Lucas who recently brought to light the ability to use @@IDENTITY in mySQL v4+.
Brett B)
Taco Fleur wrote:
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
-- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.au
--- 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
