Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ajit Ananthram Use of Identity Property to Resolve Concurrency Issues RE: Use of Identity Property to Resolve Concurrency Issues
peter.row
SSCarpal Tunnel
Points: 4319
More actions
February 24, 2011 at 3:32 am
#1290822
Why use the output syntax, table variable and dynamic sql?
Wouldn't the following be simpler (no permissions issue on table if user running it only has access to SP either) :
insert into ...
set @outputId = scope_identity()