Thread: How to get @@error and @@rowcount at the same time?
View Single Post
  #2 (permalink)  
Old 03-28-2008, 04:34 AM
mobilegeek mobilegeek is offline
D-Web Analyst
  
Join Date: Jun 2007
Posts: 205
mobilegeek is on a distinguished road
Smile Re: How to get @@error and @@rowcount at the same time?
Hi,

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.
Reply With Quote