SQL Server 2000: Use
SCOPE_IDENTITY() Instead Of
As I'm not working with SQL Server the whole day, my knowledge about the platform is not extensive. I was alway under the impression that using SQL Server 2000, you can get the identity value of the last inserted row by issuing a
SELECT @@identity. Apparently, it is not according to the following article
Check Your SQL Server Identity: Since SQL Server 2000 you have to use SCOPE_IDENTITY() instead, as the former could give unexpected results.
When you work with SQL Server and don't know this SQL Server Central, check it out as it contains a lot of interesting articles