It looks like the only difference is one of precision.
A related but probably useless quesion on the usage of
scope_identity(). I've always used the following:
select keywordid = @@identity
select keywordid = SCOPE_IDENTITY()
The examples I've seen use:
select SCOPE_IDENTITY() as keywordid
I assume that this is just a style difference rather than one with any
real effect.
Thanks
--
Michael Dinowitz
On Tue, Apr 20, 2010 at 2:02 PM, DK <[email protected]> wrote:
>
> check this out:
> http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/
>
>
> ----- Original Message -----
> From: "Michael Dinowitz" <[email protected]>
> To: "sql" <[email protected]>
> Sent: Tuesday, April 20, 2010 1:45 PM
> Subject: Re: query returns data comparison statement
>
>
>>
>> DK,
>>
>> What would be the difference in this case? I'm looking for the most
>> optimal if at all possible.
>>
>> Thanks
>>
>> --
>> Michael Dinowitz
>>
>>
>>
>>
>> On Tue, Apr 20, 2010 at 1:42 PM, DK <[email protected]> wrote:
>>>
>>> The only other tweak I would make is use scope_identity() instead of
>>> @@IDENTITY
>>>
>>>
>>>
>>> ----- Original Message -----
>>> From: "Michael Dinowitz" <[email protected]>
>>> To: "sql" <[email protected]>
>>> Sent: Tuesday, April 20, 2010 1:29 PM
>>> Subject: Re: query returns data comparison statement
>>>
>>>
>>>>
>>>> OK, other than a few minor tweaks, it works.
>>>>
>>>> create procedure getkeywordid @keyword varchar(100)
>>>> as
>>>> SET NOCOUNT ON;
>>>>
>>>> select keywordid
>>>> from keyword
>>>> where keyword = @keyword
>>>>
>>>> if @@ROWCOUNT <> 1
>>>> begin
>>>> insert into keywords (keyword)
>>>> values (@keyword)
>>>>
>>>> select keywordid=@@identity
>>>> end
>>>> SET NOCOUNT OFF;
>>>>
>>>> Thanks Carl and DK
>>>>
>>>> --
>>>> Michael Dinowitz
>>>>
>>>>
>>>
>>>
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3331
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
