3 Comments

  • I've noticed that returning scope_identity() via a proc does not return an integer (as one might expect) but some other type that I can't remember.



    So everytime I return this in a script I have to cast it...



    select cast(scope_identity() as int)



    One of those quirks I believe

  • Another tip - don't use triggers in MSSQL. If you follow this tip, you can use @@identity :)

  • bah.. triggers are great... too great to give up just to use @@identity :P

Comments have been disabled for this content.