Re: update multiple rows continue past exceptions
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Sun, 13 Dec 2009 16:21:14 -0800 (PST)
Message-ID: <db455a8e-55d8-4883-82e9-e5d09880805a_at_j4g2000yqe.googlegroups.com>
On Dec 12, 1:41 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
>
> Why not simply use the merge statement?
>
> --http://mgogala.byethost5.com
Date: Sun, 13 Dec 2009 16:21:14 -0800 (PST)
Message-ID: <db455a8e-55d8-4883-82e9-e5d09880805a_at_j4g2000yqe.googlegroups.com>
On Dec 12, 1:41 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
>
> Why not simply use the merge statement?
>
> --http://mgogala.byethost5.com
This is a regular event in our shop. Our developers used to try to insert, and then handle the exception if it existed and update it. We cut our redo by a large factor when we asked them to switch to MERGE. Received on Sun Dec 13 2009 - 18:21:14 CST