MysteryJimbo (9/7/2012)

The best way to do it would be to update the rows iteratively in batches. I would create a working table with all the primary keys and use...

No. I meant updating the rows ( values ) of some columns

sorry for not being clear. I want to update all the rows which may take quite some time but many users are accessing the table. I was asking is there...

Thank you 🙂

Thank you very much :-). Its interesting to know that the Try catch doesn't work with all the errors. Is there any specific list of error numbers that Try Catch...

Thank you very much :-). Its interesting to know that the Try catch doesn't work with all the errors. Is there any specific list of error numbers that Try Catch...

Can anybody pls help on this issue ?

No trigger on the table, in fact no table exists as such.

I don't understand the transaction error, shouldn't it directly jump to the catch block and rollback the transaction...

Go it, Thanks Lowell 🙂

ek

It happens. It is a learning process every body go through. Have fun

Eranna Kuruva

Pls ignore this, i did a complete reinstall for SQL 2005 and it worked for me 🙂

Thanks

I just got the prod version and it has try catch block to eat the exception ,ooo what a crud way http::crazy:

Never mind, pls ignore this

Hi Paul,

Thanks for your reply. I am actually running a report from the UAT website which is connecting to Oracle database. So, i need to to know when i click...

You are right. the only issue is it updates the empty rows (with blank spaces )with 00 and i have to write another statement to update them to blank. But...

Thanks for clearing all my doubts 🙂