I always like to use explicit references if possible-- @@IDENTITY is used
here because it is the only way to do this.
"Faster" in terms of time difference between these two techniques should
not even be a consideration because, for all intents and purposes, it is
negligible, and there are countless other better opportunities in any app
to pick up speed.
Hope this helps.
Well, it's time for me to feed my trusty horse, Gefilte, so I simply must go...
At 02:39 PM 8/25/00 +0100, you wrote:
>I stand corrected!...thanks.
>
>Out of curiosity - When faced with this sort of thing I always reference the
>INSERTED table to get the ID rather than @@IDENTITY. I know it will be
>marginal if anything but will @@IDENTITY be quicker? are there any other
>advantages or is it essentially the same thing?
Respectfully,
Adam Phillip Churvis
President
Productivity Enhancement, Inc.
****************************************************************************
* PRODUCTIVITY ENHANCEMENT, INC. *
* *
* Publishers of the CommerceBlocks line of modular development tools *
* for ColdFusion *
* *
* Website: http://www.commerceblocks.com E-mail: [EMAIL PROTECTED] *
* Phone: 770-446-8866 Fax: 770-242-0410 *
* *
****************************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
