On Jul 28, 2004, at 19:04, David Naseby wrote:

>> From: Nathaniel Talbott [mailto:nathaniel / talbott.ws]
>>
>> Here's the code I used for SQL Server:
>>
>>    SELECT @@identity
>>
>> I forget all the forms of that, and the exact scope it operates in, 
>> but
>> it should at least get you started.
>
> I believe its recommended to use
>
> 	SELECT scope_identity()
>
> on Sql Server. Ref:
> http://weblogs.asp.net/rosherove/archive/2003/11/13/37217.aspx

Ah, I should have said, "SQL Server 7"... it didn't have 
scope_identity(). Which of course means that you can't just have a 
specific method per DB because you may actually need one per DB version 
:-/


Nathaniel
Terralien, Inc.

<:((><