{"id":1073,"date":"2022-04-06T06:10:00","date_gmt":"2022-04-06T04:10:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1073"},"modified":"2022-11-23T10:40:35","modified_gmt":"2022-11-23T09:40:35","slug":"maj-meme-colonne-sql-server-autre-ligne","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/","title":{"rendered":"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Comment mettre \u00e0 jour la m\u00eame colonne de la m\u00eame table sur une autre ligne avec SQL Server ? <\/em><\/strong><\/h4>\n\n\n\n<p>Exemple de code pour mettre \u00e0 jour la m\u00eame colonne SQL Server sur une autre ligne depuis une autre ligne, sur la m\u00eame table. Il faut identifier cette ligne par une autre clef, une simple requ\u00eate <a href=\"https:\/\/fr.wikipedia.org\/wiki\/Update_(SQL)\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">UPDATE<\/a> de ce type ne suffit pas. En effet cette requ\u00eate met \u00e0 jour toutes les lignes avec cette clef.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Une requ\u00eate simple met \u00e0 jour toutes les lignes<\/h2>\n\n\n\n<p>En effet, une requ\u00eate de MAJ avec une commande UPDATE ne suffit pas, car elle met \u00e0 jour toutes les lignes identifi\u00e9es par la clef, avec la valeur cible.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Cette requ\u00eate ne fonctionne pas car c'est une simple mise \u00e0 jour SQL\nUPDATE MaTable \nSET MonChamps1 = 'Valeur' \nWHERE MonChampsClef = 'Ma clef';\n<\/pre>\n\n\n\n<p>Donc, pour mettre \u00e0 jour le champ avec SQL Server, identifier le tuple contenant l&rsquo;autre valeur puis r\u00e9cup\u00e9rer la valeur. Cet article montre comment mettre \u00e0 jour un champ \u00e0 partir de la valeur contenue dans une autre ligne, identifi\u00e9e par une clef.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-creer-au-prealable-la-table-pour-la-maj\">Cr\u00e9er au pr\u00e9alable la table pour la MAJ<\/h2>\n\n\n\n<p>Cr\u00e9er au pr\u00e9alable la table d&rsquo;exemple, des CLIENTS, dont le script est disponible sur ce tutoriel, <a href=\"https:\/\/expert-only.com\/t-sql\/creer-table-sql-server\/\">cr\u00e9er la table des clients sous SQL Server<\/a>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"263\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-exemple-table-clients.png\" alt=\"S\u00e9lection des donn\u00e9es SQL Server avec de mettre \u00e0 jour la m\u00eame colonne d'une autre ligne\" class=\"wp-image-967\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-exemple-table-clients.png 640w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-exemple-table-clients-300x123.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption class=\"wp-element-caption\">Selection des donn\u00e9es de la table SQL Server avant la mise \u00e0 jour<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne MS SQL<\/h2>\n\n\n\n<p>Afin de r\u00e9cup\u00e9rer la valeur du champ et de mettre \u00e0 jour la colonne, se servir d\u2019une requ\u00eate de ce type. C&rsquo;est \u00e0 dire qu&rsquo;il faut utiliser 2 fois la m\u00eame table avec 2 alias diff\u00e9rents: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Clients C1 : l&rsquo;alias de la table \u00e0 mettre \u00e0 jour<\/li>\n\n\n\n<li>Clients C2 : l&rsquo;alias de la m\u00eame table pour lire la valeur source<\/li>\n<\/ul>\n\n\n\n<p>Ex\u00e9cuter cette requ\u00eate <a href=\"https:\/\/en.wikipedia.org\/wiki\/Update_(SQL)\" target=\"_blank\" rel=\"noreferrer noopener\">UPDATE<\/a> avec la version SQL Server 2016, mais elle fonctionnelle sous d&rsquo;autres versions, comme SQL Server 2012 ou encore <a href=\"https:\/\/expert-only.com\/dba\/telecharger-sql-server-2019-gratuit-edition-developer\/\">SQL Server 2019<\/a>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Mettre \u00e0 jour la table des clients\n-- depuis la m\u00eame colonne d'une ligne diff\u00e9rente\nUPDATE\tC1\nSET\t[VILLE] = C2.[VILLE]\nFROM\n  [dbo].[CLIENTS] C1 ,\n  [dbo].[CLIENTS] C2\nWHERE C1.[NOM] = 'MAMMADOU'\n  AND C2.[NOM] = 'CHRISTOPHE';\n\n-- V\u00e9rification des lignes ins\u00e9r\u00e9es\nSELECT *\nFROM dbo.CLIENTS;\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"611\" height=\"295\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-update-meme-table.png\" alt=\"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server\" class=\"wp-image-1074\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-update-meme-table.png 611w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-update-meme-table-300x145.png 300w\" sizes=\"auto, (max-width: 611px) 100vw, 611px\" \/><figcaption class=\"wp-element-caption\"><strong>Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>On note que le client <em>MAMMADOU<\/em> est maintenant rattach\u00e9 \u00e0 Paris.\u00a0Dans une requ\u00eate avec des alias et des jointures, les champs de la table sont accessibles uniquement en utilisant l&rsquo;alias comme par exemple <strong><em>C1.VILLE<\/em><\/strong>. Ou encore le nom complet <strong><em>dbo.CLIENTS.VILLE<\/em><\/strong> pour distinguer les deux appels \u00e0 la m\u00eame table.\u00a0Ainsi les r\u00e8gles s&rsquo;appliquent comme dans une <a href=\"https:\/\/expert-only.com\/t-sql\/ecrire-requete-jointure-left-join-sql-server\/\">requ\u00eate SQL classique avec une jointure<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"EZhdBBY994\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\">Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Requ\u00eates SELECT SQL Server pour s\u00e9lectionner et filtrer\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/embed\/#?secret=VABkTTAHut#?secret=EZhdBBY994\" data-secret=\"EZhdBBY994\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Ce tutoriel sur la requ\u00eate SQL Update explique comment, avec une jointure simple il est possible de r\u00e9cup\u00e9rer la valeur d&rsquo;une ligne. Puis comment utiliser cette valeur pour mettre \u00e0 jour la m\u00eame colonne mais cette fois d&rsquo;une ligne cible.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment mettre \u00e0 jour la m\u00eame colonne de la m\u00eame table sur une autre ligne avec SQL Server ? Exemple de code pour mettre \u00e0 jour la m\u00eame colonne SQL Server sur une autre ligne depuis une autre ligne, <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/\" title=\"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10932,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-1073","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>Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server<\/title>\n<meta name=\"description\" content=\"Pour mettre \u00e0 jour la m\u00eame colonne SQL Server d&#039;une autre ligne avec une requ\u00eate identifier les lignes source et cible avec des alias.\" \/>\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\/maj-meme-colonne-sql-server-autre-ligne\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server\" \/>\n<meta property=\"og:description\" content=\"Pour mettre \u00e0 jour la m\u00eame colonne SQL Server d&#039;une autre ligne avec une requ\u00eate identifier les lignes source et cible avec des alias.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/\" \/>\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-04-06T04:10:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-23T09:40:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/white-office-desk-chair-0AEEF15FCE6_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=\"3 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\/maj-meme-colonne-sql-server-autre-ligne\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server\",\"datePublished\":\"2022-04-06T04:10:00+00:00\",\"dateModified\":\"2022-11-23T09:40:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/\"},\"wordCount\":457,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/white-office-desk-chair-0AEEF15FCE6_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/\",\"name\":\"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/white-office-desk-chair-0AEEF15FCE6_1920x1080.jpg\",\"datePublished\":\"2022-04-06T04:10:00+00:00\",\"dateModified\":\"2022-11-23T09:40:35+00:00\",\"description\":\"Pour mettre \u00e0 jour la m\u00eame colonne SQL Server d'une autre ligne avec une requ\u00eate identifier les lignes source et cible avec des alias.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/white-office-desk-chair-0AEEF15FCE6_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/white-office-desk-chair-0AEEF15FCE6_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server\"}]},{\"@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":"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server","description":"Pour mettre \u00e0 jour la m\u00eame colonne SQL Server d'une autre ligne avec une requ\u00eate identifier les lignes source et cible avec des alias.","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\/maj-meme-colonne-sql-server-autre-ligne\/","og_locale":"fr_FR","og_type":"article","og_title":"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server","og_description":"Pour mettre \u00e0 jour la m\u00eame colonne SQL Server d'une autre ligne avec une requ\u00eate identifier les lignes source et cible avec des alias.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-04-06T04:10:00+00:00","article_modified_time":"2022-11-23T09:40:35+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/white-office-desk-chair-0AEEF15FCE6_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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server","datePublished":"2022-04-06T04:10:00+00:00","dateModified":"2022-11-23T09:40:35+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/"},"wordCount":457,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/white-office-desk-chair-0AEEF15FCE6_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/","name":"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/white-office-desk-chair-0AEEF15FCE6_1920x1080.jpg","datePublished":"2022-04-06T04:10:00+00:00","dateModified":"2022-11-23T09:40:35+00:00","description":"Pour mettre \u00e0 jour la m\u00eame colonne SQL Server d'une autre ligne avec une requ\u00eate identifier les lignes source et cible avec des alias.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/white-office-desk-chair-0AEEF15FCE6_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/white-office-desk-chair-0AEEF15FCE6_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server"}]},{"@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\/1073","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=1073"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1073\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10932"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}