On 27 jun, 12:51, mdipierro <mdipie...@cs.depaul.edu> wrote: > should we consider this a bug and use > > SELECT SCOPE_INDETITY() > > ?
I do not know MSSQLServer, especially regarding the different versions. Here [1] there is another alternative: SELECT IDENT_CURRENT ('tablename');. Someone who knows more about you can give some opinion. [1] http://www.sqlteam.com/article/alternatives-to-identity-in-sql-server-2000