List:General Discussion« Previous MessageNext Message »
From:Gerhard Gaupp Date:May 5 2004 10:12am
Subject:if exists
View as plain text  
Hello

I'm looking for something like

if not exists( select 1 from PERSON where NAME = 'Test' ) then
   insert into PERSON ( NAME ) values ( 'Test');
end if;

I did it with Sybase Database.
I need to get Data from Excel and have to be shure that there is no data more than once in
the table.
So I have to generate a script with test, if this data is in teh table yet, or not, before
inserting.

Did You Understand? Sorry for my English

Greetings from Germany

Gerhard
Thread
if existsGerhard Gaupp5 May
  • Re: if existsPaul DuBois5 May