Trigger (INSTEAD OF INSERT) SCOPE_IDENTITY always null

ssteenkiste / nettiers

Automatically exported from code.google.com/p/nettiers

1 stars 0 forks source link

Trigger (INSTEAD OF INSERT) SCOPE_IDENTITY always null #402

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

Hi there, if you have a trigger INSTEAD OF INSERT, SCOPE_IDENTITY will always 
be null cause of the scope of execution to solve that:

ISNULL(SCOPE_IDENTITY(), @@IDENTITY)

Original issue reported on code.google.com by KarlK...@gmail.com on 30 Sep 2011 at 10:06