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 |
03-27-2008, 01:56 AM
| |||
| |||
 How to get @@error and @@rowcount at the same time? How to get @@error and @@rowcount at the same time?
__________________ S.VinothkumaR Behind me is infinite power, Before me is Endless Possibility, Around me is Boundless Opportunity, Why should I fear!     |
| Sponsored Links |
|
03-28-2008, 03:34 AM
| |||
| |||
 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. |
|
04-02-2008, 03:47 AM
| |||
| |||
 Re: How to get @@error and @@rowcount at the same time? Hi, look at here... 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
__________________ S.VinothkumaR Behind me is infinite power, Before me is Endless Possibility, Around me is Boundless Opportunity, Why should I fear! |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 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 09:15 PM |
| How can I set the time zone for MySQL to UK time? | itbarota | PHP Programming | 1 | 09-12-2007 12:13 AM |
| Handling of run time error in java? | prasath | Java Programming | 1 | 07-20-2007 06:30 AM |
| How to get @@error and @@rowcount at the same time? | Archer | Database Support | 3 | 07-18-2007 11:31 PM |
| Diff between Transaction-time and Server response-time | vadivelanvaidyanathan | Software Testing | 0 | 03-21-2007 06:29 AM |
All times are GMT -7. The time now is 11:23 AM.
