Use OUTPUT clause instead of SCOPE_IDENTITY so that non-identity primary keys can be returned to the program.
Use OUTPUT clause instead of SCOPE_IDENTITY so that non-identity primary keys can be returned to the program.

mFingers/SQLProvider,bennylynch/SQLProvider,s952163/SQLProvider