How to get @@error and @@rowcount at the same time?
This is a discussion on How to get @@error and @@rowcount at the same time? within the Database Support forums, part of the Web Development category; How to get @@error and @@rowcount at the same time?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
How to get @@error and @@rowcount at the same time? 
07-18-2007, 11:02 PM
| |||
| |||
 Re: How to get @@error and @@rowcount at the same time? Hi, To get the @@errror and @@rowcount at the sametime we can store them using Variables. For Ex: SELECT @RowCount = @@ROWCOUNT,@Error = @@ERROR;
__________________ -Murali..     |
|
07-19-2007, 12:16 AM
| |||
| |||
| Re: How to get @@error and @@rowcount at the same time? May be this could be a Detailed Answer 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 |
|
07-19-2007, 12:31 AM
| |||
| |||
| Re: How to get @@error and @@rowcount at the same time? Hi, Then this couldn't be enough for getting the answer? HTML Code: SELECT @RowCount = @@ROWCOUNT,@Error = @@ERROR;
__________________ -Murali.. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to get @@error and @@rowcount at the same time? | S.Vinothkumar | Database Support | 2 | 04-02-2008 04:47 AM |
| show clocks, one showing the current time, and another showing a time 12 hours behind | itbarota | HTML, CSS and Javascript Coding Techniques | 1 | 02-13-2008 10:15 PM |
| How can I set the time zone for MySQL to UK time? | itbarota | PHP Programming | 1 | 09-12-2007 01:13 AM |
| Handling of run time error in java? | prasath | Java Programming | 1 | 07-20-2007 07:30 AM |
| Diff between Transaction-time and Server response-time | vadivelanvaidyanathan | Software Testing | 0 | 03-21-2007 07:29 AM |
All times are GMT -7. The time now is 03:24 AM.
