>>PS: Warning if inserting via a stored procedure than SCOPE_IDENTITY wouldn't work. However you could query directly:<

I just wanted to comment on this Cetin. SCOPE_IDENTITY with a Stored Proc works just fine. You'd set an OUTPUT parameter to the SCOPE_IDENTITY value.

~~Bonnie




>>I have an application in Asp.Net that writes to a SQL Server table. This SQL Server table has an Identity column.
>>
>>How can I return the value of the Identity column after performing an Insert into the table?
>>
>>Thanks,
>>
>>Jerry
>
>Jerry,
>You would request SCOPE_IDENTITY back. Instead I suggest you to use GUID as unique IDs. You don't need to request back then because you know them before inserting.
>PS: Warning if inserting via a stored procedure than SCOPE_IDENTITY wouldn't work. However you could query directly:
>select IDENTCOLUMN from inserted
>Cetin