{"id":19875,"date":"2022-11-25T07:53:00","date_gmt":"2022-11-25T06:53:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=19875"},"modified":"2022-12-28T20:03:14","modified_gmt":"2022-12-28T19:03:14","slug":"requete-select-case-when-en-t-sql","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/","title":{"rendered":"Requ\u00eate SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Exemples de requ\u00eates SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions depuis les valeurs des colonnes.<\/em><\/strong><\/h4>\n\n\n\n<p>La requ\u00eate SELECT CASE WHEN en T-SQL est utilis\u00e9e pour effectuer des tests sur une colonne de donn\u00e9es et renvoyer diff\u00e9rentes valeurs en fonction des r\u00e9sultats de ces tests. Cette requ\u00eate est particuli\u00e8rement utile lorsque vous voulez afficher des donn\u00e9es de mani\u00e8re conditionnelle dans une requ\u00eate SELECT. Voici donc comment utiliser la requ\u00eate SELECT CASE WHEN en T-SQL.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#1-creer-la-table-des-produits-et-ecrire-une-requete-select\" >1. Cr\u00e9er la table des produits et \u00e9crire une requ\u00eate SELECT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#2-construire-la-clause-case-when\" >2. Construire la clause CASE WHEN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#3-finir-la-clause-case-par-le-mot-end\" >3. Finir la clause CASE par le mot END<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#4-exemple-concret-dans-une-requete-t-sql\" >4. Exemple concret dans une requ\u00eate T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#5-case-when-combine-avec-une-requete-where\" >5. CASE WHEN combin\u00e9 avec une requ\u00eate WHERE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#6-exemple-de-case-when-avec-un-group-by\" >6. Exemple de CASE WHEN avec un GROUP BY<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#7-requete-case-pour-afficher-le-nom-du-mois-a-partir-du-numero\" >7. Requ\u00eate CASE pour afficher le nom du mois \u00e0 partir du num\u00e9ro<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#8-conclusion-sur-la-requete-select-case-when-en-t-sql\" >8. Conclusion sur la requ\u00eate SELECT CASE WHEN en T-SQL<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-creer-la-table-des-produits-et-ecrire-une-requete-select\"><span class=\"ez-toc-section\" id=\"1-creer-la-table-des-produits-et-ecrire-une-requete-select\"><\/span>1. Cr\u00e9er la table des produits et \u00e9crire une requ\u00eate SELECT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici comment cr\u00e9er la table \u00ab\u00a0produits\u00a0\u00bb et ins\u00e9rer des lignes en utilisant <a href=\"https:\/\/blog.digitalcook.fr\/la-difference-entre-sql-et-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">T-SQL<\/a>. Pour cr\u00e9er la table \u00ab\u00a0produits\u00a0\u00bb, utilisez la commande CREATE TABLE suivie de la d\u00e9finition de la table et de ses colonnes.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE dbo.Produits (\n   id INT PRIMARY KEY,\n   Nom_Produit NVARCHAR(255),\n   Categorie_Produit INT,\n   Prix DECIMAL(10, 2)\n);\n<\/pre>\n\n\n\n<p>Les commandes ci-dessous permettent d&rsquo;ins\u00e9rer des lignes dans la table des produits.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">INSERT INTO produits (id, Nom_Produit, Code_Categorie , Prix)\nVALUES (1, 'Banane', 1, 1.39),\n       (2, 'Ordinateur', 2, 899.99),\n       (3, 'Livre', 3, 12.99);\n\t  \nINSERT INTO produits (id, Nom_Produit, Code_Categorie , Prix)\nVALUES (4, 'T\u00e9l\u00e9viseur', 2, 599.99),\n       (5, 'Aspirateur', 2, 299.99),\n       (6, 'Cafeti\u00e8re', 2, 89.99),\n       (7, 'Poulet', 1, 7.99),\n       (8, 'Pommes', 1, 1.69),\n       (9, 'P\u00e2tes', 1, 1.99);\n\t  \nINSERT INTO produits (id, Nom_Produit, Code_Categorie , Prix)\nVALUES (10, 'Lave-vaisselle', 2, 399.99),\n       (11, 'Four micro-ondes', 2, 99.99),\n       (12, 'Lit double', 3, 399.99),\n       (13, 'Canap\u00e9', 3, 499.99),\n       (14, 'Veste', 4, 99.99),\n       (15, 'Plante', 4, 199.99);\n<\/pre>\n\n\n\n<p>Ecrire ensuite votre requ\u00eate SELECT comme d&rsquo;habitude, en s\u00e9lectionnant les colonnes que vous souhaitez afficher et en sp\u00e9cifiant la source de donn\u00e9es \u00e0 partir de laquelle vous souhaitez s\u00e9lectionner les donn\u00e9es.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-construire-la-clause-case-when\"><\/span>2. Construire la clause CASE WHEN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ensuite, utilisez la clause CASE WHEN pour effectuer un test sur une colonne de donn\u00e9es. Voici la syntaxe g\u00e9n\u00e9rale de cette clause. Voici un exemple simple g\u00e9n\u00e9rique d&rsquo;utilisation du SELECT CASE WHEN avec SQL Server: <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   CASE\n      WHEN condition-1 THEN resultat-1\n      WHEN condition-2 THEN resultat-2\n      WHEN condition-3 THEN resultat-3\n   ELSE resultat-4\n   END\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-finir-la-clause-case-par-le-mot-end\"><\/span>3. Finir la clause CASE par le mot END<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La clause CASE WHEN commence par la mot-cl\u00e9 \u00ab\u00a0CASE\u00a0\u00bb et se termine par la mot-cl\u00e9 \u00ab\u00a0END\u00a0\u00bb. Entre ces deux mots-cl\u00e9s, vous pouvez inclure plusieurs \u00ab\u00a0WHEN condition THEN result\u00a0\u00bb pour effectuer plusieurs tests et renvoyer diff\u00e9rentes valeurs en fonction des r\u00e9sultats de ces tests. Si aucune des conditions n&rsquo;est vraie, vous pouvez utiliser la clause \u00ab\u00a0ELSE result\u00a0\u00bb pour renvoyer une valeur par d\u00e9faut.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-exemple-concret-dans-une-requete-t-sql\"><\/span>4. Exemple concret dans une requ\u00eate T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Par exemple, supposez que vous avez une table de produits avec une colonne \u00ab\u00a0cat\u00e9gorie\u00a0\u00bb qui peut prendre les valeurs \u00ab\u00a0alimentaire\u00a0\u00bb, \u00ab\u00a0\u00e9lectronique\u00a0\u00bb ou \u00ab\u00a0autre\u00a0\u00bb. Vous pouvez utiliser la requ\u00eate SELECT CASE WHEN pour afficher la colonne \u00ab\u00a0cat\u00e9gorie\u00a0\u00bb sous forme de texte lisible par l&rsquo;homme au lieu de l&rsquo;identifiant num\u00e9rique utilis\u00e9 en interne.<\/p>\n\n\n\n<p>Voici par exemple les 4 valeurs possible pour notre requ\u00eate :<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Alimentaire<\/li>\n\n\n\n<li>Electronique<\/li>\n\n\n\n<li>Mobilier<\/li>\n\n\n\n<li>Hygi\u00e8ne<\/li>\n\n\n\n<li>Autre<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   Nom_Produit,\n   CASE\n      WHEN Code_Categorie = 1 THEN 'Alimentaire'\n      WHEN Code_Categorie = 2 THEN 'Electronique'\n      WHEN Code_Categorie = 3 THEN 'Mobilier'\n      WHEN Code_Categorie = 4 THEN 'Hygi\u00e8ne'\n      ELSE 'Autre'\n   END\n   AS Categorie_Produit\nFROM dbo.Produits;\n<\/pre>\n\n\n\n<p>Cette requ\u00eate affichera donc la colonne <em>Nom_Produit<\/em> et une colonne <em>Categorie_Produit<\/em> qui affichera Alimentaire pour les produits de la cat\u00e9gorie alimentaire, <em>Electronique<\/em> pour les produits de la cat\u00e9gorie \u00e9lectronique, etc. Et enfin \u00ab\u00a0Autre\u00a0\u00bb pour tous les autres produits. C&rsquo;est \u00e0 dire les produits sans cat\u00e9gorie.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-case-when-combine-avec-une-requete-where\"><\/span>5. CASE WHEN combin\u00e9 avec une requ\u00eate WHERE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Vous pouvez \u00e9galement utiliser la requ\u00eate SELECT CASE WHEN dans d&rsquo;autres clauses de requ\u00eate, <a href=\"https:\/\/expert-only.com\/t-sql\/requetes-select-sql-server\/\">comme la clause WHERE<\/a> ou la clause GROUP BY.<\/p>\n\n\n\n<p>Par exemple, vous pouvez utiliser la clause WHERE pour filtrer les r\u00e9sultats de votre requ\u00eate en fonction de la valeur de la colonne <em>Code_Categorie<\/em>. Cette requ\u00eate ne retournera donc que les produits de la cat\u00e9gorie \u00ab\u00a0alimentaire\u00a0\u00bb.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   Nom_Produit,\n   CASE\n      WHEN Code_Categorie = 1 THEN 'Alimentaire'\n      WHEN Code_Categorie = 2 THEN 'Electronique'\n      WHEN Code_Categorie = 3 THEN 'Mobilier'\n      ELSE 'Autre'\n   END\n   AS Categorie_Produit\nWHERE Code_Categorie = 1;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-exemple-de-case-when-avec-un-group-by\"><\/span>6. Exemple de CASE WHEN avec un GROUP BY<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Vous pouvez \u00e9galement utiliser la clause GROUP BY pour regrouper les r\u00e9sultats de votre requ\u00eate en fonction de la valeur de la colonne \u00ab\u00a0categorie\u00a0\u00bb :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   Nom_Produit,\n   CASE\n      WHEN Code_Categorie = 1 THEN 'Alimentaire'\n      WHEN Code_Categorie = 2 THEN 'Electronique'\n      WHEN Code_Categorie = 3 THEN 'Mobilier'\n      WHEN Code_Categorie = 4 THEN 'Hygi\u00e8ne'\n      ELSE 'Autre'\n   END\n   AS Categorie_Produit,\n   COUNT(*) AS Nombre_Produits\nFROM dbo.Produits\nGROUP BY Code_Categorie;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7-requete-case-pour-afficher-le-nom-du-mois-a-partir-du-numero\"><\/span>7. Requ\u00eate CASE pour afficher le nom du mois \u00e0 partir du num\u00e9ro<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Cette requ\u00eate retournera le nombre de produits dans chaque cat\u00e9gorie, affich\u00e9 sous forme de texte lisible par l&rsquo;homme au lieu de l&rsquo;identifiant num\u00e9rique utilis\u00e9 en interne. Supposons que vous avez une table \u00ab\u00a0ventes\u00a0\u00bb avec une colonne \u00ab\u00a0mois\u00a0\u00bb qui contient le num\u00e9ro du mois (de 1 \u00e0 12).<\/p>\n\n\n\n<p>Vous pouvez utiliser la requ\u00eate SELECT CASE WHEN pour afficher le nom du mois au lieu du num\u00e9ro. Cette requ\u00eate affichera l&rsquo;ann\u00e9e, le nom du mois et le total des ventes pour chaque mois.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT\n   Annee,\n   CASE\n      WHEN mois = 1  THEN 'Janvier'\n      WHEN mois = 2  THEN 'F\u00e9vrier'\n      WHEN mois = 3  THEN 'Mars'\n      WHEN mois = 4  THEN 'Avril'\n      WHEN mois = 5  THEN 'Mai'\n      WHEN mois = 6  THEN 'Juin'\n      WHEN mois = 7  THEN 'Juillet'\n      WHEN mois = 8  THEN 'Ao\u00fbt'\n      WHEN mois = 9  THEN 'Septembre'\n      WHEN mois = 10 THEN 'Octobre'\n      WHEN mois = 11 THEN 'Novembre'\n      WHEN mois = 12 THEN 'D\u00e9cembre'\n      ELSE 'erreur'\n   END AS Mois,\n   SUM(montant) AS Total_Ventes\nFROM dbo.Ventes\nGROUP BY\n   Annee\n   Mois;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"8-conclusion-sur-la-requete-select-case-when-en-t-sql\"><\/span>8. Conclusion sur la requ\u00eate SELECT CASE WHEN en T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voil\u00e0, vous savez maintenant comment utiliser la requ\u00eate SELECT CASE WHEN en T-SQL pour afficher des donn\u00e9es de mani\u00e8re conditionnelle dans une requ\u00eate SELECT. N&rsquo;h\u00e9sitez pas \u00e0 jouer avec cette requ\u00eate et \u00e0 la combiner avec d&rsquo;autres clauses pour cr\u00e9er des requ\u00eates plus complexes.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Exemples de requ\u00eates SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions depuis les valeurs des colonnes. La requ\u00eate SELECT CASE WHEN en T-SQL est utilis\u00e9e pour effectuer des tests sur une colonne de donn\u00e9es et renvoyer diff\u00e9rentes valeurs <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/\" title=\"Requ\u00eate SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10862,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-19875","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Requ\u00eate SELECT CASE WHEN en T-SQL - Op\u00e9rateurs - MS SQL<\/title>\n<meta name=\"description\" content=\"La requ\u00eate SELECT CASE WHEN en T-SQL permet de faire des tests sur une colonne de donn\u00e9es avec des conditions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Requ\u00eate SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions\" \/>\n<meta property=\"og:description\" content=\"La requ\u00eate SELECT CASE WHEN en T-SQL permet de faire des tests sur une colonne de donn\u00e9es avec des conditions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-25T06:53:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-28T19:03:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Requ\u00eate SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions\",\"datePublished\":\"2022-11-25T06:53:00+00:00\",\"dateModified\":\"2022-12-28T19:03:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/\"},\"wordCount\":726,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/\",\"name\":\"Requ\u00eate SELECT CASE WHEN en T-SQL - Op\u00e9rateurs - MS SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"datePublished\":\"2022-11-25T06:53:00+00:00\",\"dateModified\":\"2022-12-28T19:03:14+00:00\",\"description\":\"La requ\u00eate SELECT CASE WHEN en T-SQL permet de faire des tests sur une colonne de donn\u00e9es avec des conditions.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Requ\u00eate SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Requ\u00eate SELECT CASE WHEN en T-SQL - Op\u00e9rateurs - MS SQL","description":"La requ\u00eate SELECT CASE WHEN en T-SQL permet de faire des tests sur une colonne de donn\u00e9es avec des conditions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"Requ\u00eate SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions","og_description":"La requ\u00eate SELECT CASE WHEN en T-SQL permet de faire des tests sur une colonne de donn\u00e9es avec des conditions.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-11-25T06:53:00+00:00","article_modified_time":"2022-12-28T19:03:14+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Requ\u00eate SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions","datePublished":"2022-11-25T06:53:00+00:00","dateModified":"2022-12-28T19:03:14+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/"},"wordCount":726,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/","name":"Requ\u00eate SELECT CASE WHEN en T-SQL - Op\u00e9rateurs - MS SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","datePublished":"2022-11-25T06:53:00+00:00","dateModified":"2022-12-28T19:03:14+00:00","description":"La requ\u00eate SELECT CASE WHEN en T-SQL permet de faire des tests sur une colonne de donn\u00e9es avec des conditions.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-7E25D084595_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-select-case-when-en-t-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Requ\u00eate SELECT CASE WHEN en T-SQL pour g\u00e9rer les conditions"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/19875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=19875"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/19875\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10862"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=19875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=19875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=19875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}