Code: Alles auswählen
WHEN NOT MATCHED INSERT (...feldliste...) VALUES (...werteliste...)
Code: Alles auswählen
MERGE TableA AS ta
USING TableB AS tb
ON ( ta.ID = tb.ID )
WHEN MATCHED THEN
UPDATE SET ta.value = tb.value
WHEN NOT MATCHED THEN
INSERT VALUES ( tb.ID, tb.value )
Code: Alles auswählen
// create table plz(plz integer, ort cichar(50));
MERGE plz ON (plz=12345)
WHEN NOT MATCHED THEN INSERT(plz, ort) VALUES(12345, 'Hamburg');
SELECT * FROM plz;
Code: Alles auswählen
if exists (select * from system.columns where name='F1' and Parent = 'TabelleC') then
select true from system.iota;
else
select false from system.iota;
end if;