Dear all

I want to write a SP to insert some new record and those new reocrd has
input into an temp_table call "new_rec"

So if I want to check whether a record exist in old table before copy record
from "new_rec"
, how I can achieve this ?

Should I use "cursor" and a loop to achieve this ?


Thanks~

Ken

Ken,

Why not use INSERT ON EXISTING SKIP (see the documentation of INSERT for
details)?

Frank

On Tue, 27 Nov 2007 06:01:37 +0100, K2 <hk (AT) hk (DOT) com> wrote:

"K2" <hk (AT) hk (DOT) com> wrote:

if not exists (select * from mytable where <some_condition> then
insert into mytable
(
select *
from temp_table
where <...>
)
end if ;

Dmitri.