Just Learned - How to get @@error and @@rowcount at the same time?

Getting Started with Adobe After Effects - Part 6: Motion Blur

A collection of quick technology learning tips from what people around you learn every day

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

How to get @@error and @@rowcount at the same time?

Jun 2 2011 4:30AM by Dinesh Sodani

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

Read More.. [0 clicks]

Published under: SQL Server Tips · · · ·

Dinesh Sodani

30 · 6% · 1807

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it

It's funny how we generally overlook such simple solutions. Thank-you for sharing this, Dinesh!

commented on Jun 8 2011 5:43AM

Nakul Vachhrajani

4 · 33% · 10587

Sign Up or Login to post a comment.