How to get @@ERROR and @@ROWCOUNT at the same time?
If @@Rowcount is checked after Error checking statement then it will
have 0 as the value of @@Recordcount as it would have been reset.
And if
@@Recordcount is checked before the error-checking statement then @@Error would
get reset.
To get @@error and @@rowcount at the same time do both in same
statement and store them in local variable.
SELECT @RC = @@ROWCOUNT, @ER = @@ERROR
No comments :
Post a Comment