>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