Great SQL tip: @@IDENTITY==bad, scope_identity()==good

3 Comments

• scope_identity() is not supported in SqlServer 7. Consider that when using scope_identity() as it can cause code to become non-portable.
  

• Good grief! What a tip! What other commands do I need to avoid? The plus operator?
  
  
  
  Oh well, I'm sending this around to some other people that I know. This'll be new to a lot of folks.
  
  

• I have recently come accross this one myself. @@identity is not thread safe. I think there will be a lot of developers unaware of this.
  
  It seems to have slipped under the radar for most.