Insertion SQL conditionnelle

Bonjour,

Je souhaite réaliser une requête qui insère un enregistrement si celui ci n'existe pas.

Voila en gros ce que je voudrais faire en SQL pseudo algo:

Code:

---

1 2 3 4 5

Insert into Intervenant (Nom, Prenom) Values ('Brassens', 'Georges') if (select count(Nom) from intervenant where nom='Brassens' and prenom='Georges')=0

---

Merci d'avance pour votre aide.

Utiliser MERGE qui permet de faire un INSERT ou UPDATE suivant condition.

Syntaxe du MERGE :

Code:

---

1 2 3 4 5 6 7

MERGE [ INTO ] <target_table> [ [ AS ] table_alias ] USING <table_source> ON <merge_search_condition> [ WHEN MATCHED [ AND <clause_search_condition> ] THEN <merge_matched> ] [ WHEN NOT MATCHED [ AND <clause_search_condition> ] THEN <merge_not_matched> ]

---

Exemple :

Code:

---

1 2 3 4 5 6

MERGE Production.UnitMeasure AS target USING (SELECT @UnitMeasureCode, @Name) AS source (UnitMeasureCode, Name) ON (target.UnitMeasureCode = source.UnitMeasureCode) WHEN NOT MATCHED THEN INSERT (UnitMeasureCode, Name) VALUES (source.UnitMeasureCode, source.Name)

---

A +

Essaye:

Code:

---

1 2 3 4 5

insert into intervenant (nom,prenom) SELECT "Brassens" AS nom, "Georges" AS prenom FROM Intervenant where ((Intervenant.nom)="Brassens") AND ((Intervenant.prenom)="Georges") HAVING (((Count(Intervenant.nom))=0) AND ((Count(Intervenant.prenom))=0));

---

SQL Server 2008