{"id":1224,"date":"2022-11-04T07:05:00","date_gmt":"2022-11-04T06:05:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1224"},"modified":"2022-11-21T12:26:58","modified_gmt":"2022-11-21T11:26:58","slug":"procedure-t-sql-avec-une-variable-en-dur","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/","title":{"rendered":"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Comment ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable stock\u00e9e en dur ?<\/em><\/strong><\/h4>\n\n\n\n<p>Tutoriel pour g\u00e9rer l\u2019ex\u00e9cution d&rsquo;une proc\u00e9dure T-SQL avec une variable en dur, c&rsquo;est \u00e0 dire dans une cha\u00eene de charact\u00e8re. En effet, une ex\u00e9cution normale ne fonctionne pas avec la commande EXEC seule. Alors comment contourner cette erreur ? La solution au probl\u00e8me est d\u2019utiliser la fonction T-SQL EXEC sp_executesql.<\/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\/procedure-t-sql-avec-une-variable-en-dur\/#1-executer-une-procedure-t-sql-avec-une-variable-en-dur\" >1. Ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable en dur<\/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\/procedure-t-sql-avec-une-variable-en-dur\/#2-eviter-lerreur-sql-server-must-declare-the-scalar-variable\" >2. Eviter l&rsquo;erreur SQL Server Must declare the scalar variable<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#21-construire-le-code-t-sql-dynamique-etape-par-etape\" >2..1 Construire le code T-SQL dynamique \u00e9tape par \u00e9tape<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#22-autres-avantages-de-la-fonction-exec-sp-executesql\" >2.2 Autres avantages de la fonction&nbsp;EXEC sp_executesql<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-executer-une-procedure-t-sql-avec-une-variable-en-dur\"><span class=\"ez-toc-section\" id=\"1-executer-une-procedure-t-sql-avec-une-variable-en-dur\"><\/span>1. Ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable en dur<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En effet, voici un exemple de code pour ex\u00e9cuter une cha\u00eene de caract\u00e8res en T-SQL avec la commande dans une variable contenant elle-m\u00eame une variable \u00e9crite en dur dans le texte. Tout d&rsquo;abord, cr\u00e9er la table des clients pour ins\u00e9rer les donn\u00e9es comme dans l\u2019exemple ci-dessous. Le but est de construire et d&rsquo;ex\u00e9cuter une requ\u00eate dynamique de ce type: <\/p>\n\n\n\n<p>\u00ab\u00a0@SQL = &lsquo;SELECT CHAMPS1, CHAMPS2 FROM TABLE_1 WHERE CHAMPS1 = @VARIABLE&rsquo; EXEC @SQL\u00a0\u00bb.&nbsp;<\/p>\n\n\n\n<p>Le message d&rsquo;erreur suivant s&rsquo;affiche : <em>Must declare the scalar variable \u00ab\u00a0@SQL<\/em>\u00ab\u00a0.<\/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=\"\">-- Tester si la table CLIENTS existe, au besoin alors supprimer la table\nIF EXISTS(   \n\tSELECT  1 FROM sys.objects\n\tWHERE   object_id = object_id(N'[dbo].[CLIENTS]') \n\t\tAND type in (N'U')\n)\nBEGIN DROP TABLE [dbo].[CLIENTS]\nEND\nGO\n\n-- Cr\u00e9er la table CLIENTS avec la colonne NOM d\u00e9clar\u00e9e comme UNIQUE\n-- Le mot clef UNIQUE d\u00e9finit la colonne avec une valeur unique\n-- Ins\u00e9rer deux clients avec le m\u00eame nom est impossible\n\nCREATE TABLE [dbo].[CLIENTS](\n  [NOCLIENT]  \tint IDENTITY(1,1),\n  [NOM]     \tnvarchar(20) UNIQUE,\n  [VILLE]   \tnvarchar(20)\n)\nGO\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-eviter-lerreur-sql-server-must-declare-the-scalar-variable\"><\/span>2. Eviter l&rsquo;erreur SQL Server Must declare the scalar variable<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici la solution en T-SQL pour ex\u00e9cuter une requ\u00eate SQL Server avec une variable. Construire en plusieurs \u00e9tapes, au besoin les inclure dans une <a href=\"https:\/\/fr.wiktionary.org\/wiki\/proc%C3%A9dure_stock%C3%A9e\" target=\"_blank\" rel=\"noreferrer noopener\">proc\u00e9dure stock\u00e9e<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21-construire-le-code-t-sql-dynamique-etape-par-etape\"><\/span>2..1 Construire le code T-SQL dynamique \u00e9tape par \u00e9tape<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>D\u00e9claration des variables<\/strong> utilis\u00e9es, comme le compteur pour la boucle, et la variable avec une cha\u00eene de caract\u00e8res, des param\u00e8tres, etc.<\/li>\n\n\n\n<li><strong>La construction de la boucle<\/strong> pour chacune des valeurs du compteur.<\/li>\n\n\n\n<li><strong>L&rsquo;ex\u00e9cution de la requ\u00eate<\/strong> INSERT dans la boucle<\/li>\n\n\n\n<li><strong>L&rsquo;affichage de la valeur<\/strong> du compteur<\/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=\"\">-- D\u00e9clarer les variables utilis\u00e9e dans la proc\u00e9dure stock\u00e9e.\nDECLARE @COMPTEUR INT;\t\t\t\t--  Le compteur\nDECLARE @VARIABLE_NOM NVARCHAR(20);\t--  La variable pour le nom du client\nDECLARE @VARIABLE_VILLE NVARCHAR(20);\t--  La variable pour le nom de la ville\nDECLARE @PARAMETRE NVARCHAR(100);\t\t--  La cha\u00eene de param\u00e9trage sert \u00e0 d\u00e9clarer les variables\nDECLARE @SQL NVARCHAR(100);\t\t\t--  La cha\u00eene SQL est dans le cas pr\u00e9sent une requ\u00eate d'insertion des lignes\n\n-- D\u00e9clarer une cha\u00eene en dur dans la variable @PARAMETRE\nSET @PARAMETRE = '@VARIABLE_NOM NVARCHAR(20),@VARIABLE_VILLE NVARCHAR(20)';\n\n-- Construire une requ\u00eate T-SQL basique d'Insertion avec un membre dynamique\nSET @SQL = 'INSERT INTO [dbo].[CLIENTS] VALUES (@VARIABLE_NOM,@VARIABLE_VILLE)';\n\n-- D\u00e9but de la boucle\nSET @COMPTEUR = 0 \nWHILE @COMPTEUR &lt; 10\n  BEGIN\n  SET @COMPTEUR = @COMPTEUR + 1\n  SET @VARIABLE_NOM = 'NOM-' + CAST(@COMPTEUR AS CHAR);\n  SET @VARIABLE_VILLE = 'VILLE-' + CAST(@COMPTEUR AS CHAR);\n  \n  -- Ex\u00e9cuter la requ\u00eate, d\u00e9clarer la variable et passer de la valeur via @VARIABLE_CHAR\n  EXEC\tsp_executesql @SQL,@PARAMETRE, @VARIABLE_NOM,@VARIABLE_VILLE;\n  \n  PRINT\t'LE COMPTEUR VAUT : ' + CAST(@COMPTEUR AS CHAR)\nEND\n-- Fin de la boucle\n<\/pre>\n\n\n<div class=\"wp-block-image wp-image-1228 size-full\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"829\" height=\"602\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-executer-chaine-variable-dur-exec.png\" alt=\"Code dans SSMS pour ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable en dur\" class=\"wp-image-1228\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-executer-chaine-variable-dur-exec.png 829w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-executer-chaine-variable-dur-exec-300x218.png 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-executer-chaine-variable-dur-exec-768x558.png 768w\" sizes=\"auto, (max-width: 829px) 100vw, 829px\" \/><figcaption class=\"wp-element-caption\"><strong>Code dans SSMS pour ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable en dur<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Enfin l\u2019affichage des r\u00e9sultats de l&rsquo;insertion des donn\u00e9es avec une simple <a href=\"https:\/\/expert-only.com\/t-sql\/requetes-select-sql-server\/\">requ\u00eate SELECT SQL Server<\/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=\"\">SELECT\t*\nFROM\t[dbo].[CLIENTS];\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"560\" height=\"330\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-executer-chaine-variable-dur-exec-2.png\" alt=\"S\u00e9lection depuis SSMS pour v\u00e9rifier le r\u00e9sultat de la requ\u00eate avec des variables en dur\" class=\"wp-image-1230\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-executer-chaine-variable-dur-exec-2.png 560w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-executer-chaine-variable-dur-exec-2-300x177.png 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><figcaption class=\"wp-element-caption\">S\u00e9lection depuis SSMS pour v\u00e9rifier le r\u00e9sultat de la requ\u00eate avec des variables en dur<\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-2-autres-avantages-de-la-fonction-exec-sp-executesql\"><span class=\"ez-toc-section\" id=\"22-autres-avantages-de-la-fonction-exec-sp-executesql\"><\/span>2.2 Autres avantages de la fonction&nbsp;EXEC sp_executesql<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Enfin, utiliser la fonction<strong> EXEC sp_executesql<\/strong> \u00e0 la place de EXECUTE. Cette proc\u00e9dure g\u00e9n\u00e8re des plans d&rsquo;ex\u00e9cutions r\u00e9utilisables pendant les ex\u00e9cutions en boucle. De cette mani\u00e8re, les performances sont am\u00e9lior\u00e9es. Utiliser cette fonction se r\u00e9v\u00e8le tr\u00e8s utile pour une requ\u00eate complexe ex\u00e9cut\u00e9e un nombre cons\u00e9quent de fois.<\/p>\n\n\n\n<p>Cette m\u00e9thode permet de g\u00e9n\u00e9rer du code particuli\u00e8rement dynamique et donc d&rsquo;ex\u00e9cuter une requ\u00eate avec une variable en T-SQL qui est remplac\u00e9e \u00e0 la vol\u00e9e pendant l&rsquo;ex\u00e9cution du code. Apr\u00e8s cet article avec un exemple pour ex\u00e9cuter une cha\u00eene de caract\u00e8res avec une variable en T-SQL, voici un article pour <a href=\"https:\/\/expert-only.com\/t-sql\/gerer-champs-textes-sql-server-plus-8000-caracteres\/\">g\u00e9rer les champs SQL Server de plus de 8000 caract\u00e8res<\/a>. Ou encore un article pour <a href=\"https:\/\/expert-only.com\/t-sql\/couper-un-texte-delimite-xml-string-split-sql-server\/\">d\u00e9couper une cha\u00eene de caract\u00e8res avec s\u00e9parateurs<\/a> de type point-virgule.<\/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\">\nhttps:\/\/expert-only.com\/transact-sql\/gerer-champs-textes-sql-server-plus-8000-caracteres\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable stock\u00e9e en dur ? Tutoriel pour g\u00e9rer l\u2019ex\u00e9cution d&rsquo;une proc\u00e9dure T-SQL avec une variable en dur, c&rsquo;est \u00e0 dire dans une cha\u00eene de charact\u00e8re. En effet, une ex\u00e9cution normale ne fonctionne <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/\" title=\"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10542,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-1224","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>Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique<\/title>\n<meta name=\"description\" content=\"Script pour ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable en dur, et \u00e9viter l&#039;erreur SQL Server, Must declare the scalar variable.\" \/>\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\/procedure-t-sql-avec-une-variable-en-dur\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique\" \/>\n<meta property=\"og:description\" content=\"Script pour ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable en dur, et \u00e9viter l&#039;erreur SQL Server, Must declare the scalar variable.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/\" \/>\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-04T06:05:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-21T11:26:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-cup-wood-8137318DEF8_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=\"4 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\/procedure-t-sql-avec-une-variable-en-dur\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique\",\"datePublished\":\"2022-11-04T06:05:00+00:00\",\"dateModified\":\"2022-11-21T11:26:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/\"},\"wordCount\":523,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-cup-wood-8137318DEF8_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/\",\"name\":\"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-cup-wood-8137318DEF8_1920x1080.jpg\",\"datePublished\":\"2022-11-04T06:05:00+00:00\",\"dateModified\":\"2022-11-21T11:26:58+00:00\",\"description\":\"Script pour ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable en dur, et \u00e9viter l'erreur SQL Server, Must declare the scalar variable.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-cup-wood-8137318DEF8_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-cup-wood-8137318DEF8_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique\"}]},{\"@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":"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique","description":"Script pour ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable en dur, et \u00e9viter l'erreur SQL Server, Must declare the scalar variable.","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\/procedure-t-sql-avec-une-variable-en-dur\/","og_locale":"fr_FR","og_type":"article","og_title":"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique","og_description":"Script pour ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable en dur, et \u00e9viter l'erreur SQL Server, Must declare the scalar variable.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-11-04T06:05:00+00:00","article_modified_time":"2022-11-21T11:26:58+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-cup-wood-8137318DEF8_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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique","datePublished":"2022-11-04T06:05:00+00:00","dateModified":"2022-11-21T11:26:58+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/"},"wordCount":523,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-cup-wood-8137318DEF8_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/","name":"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-cup-wood-8137318DEF8_1920x1080.jpg","datePublished":"2022-11-04T06:05:00+00:00","dateModified":"2022-11-21T11:26:58+00:00","description":"Script pour ex\u00e9cuter une proc\u00e9dure T-SQL avec une variable en dur, et \u00e9viter l'erreur SQL Server, Must declare the scalar variable.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-cup-wood-8137318DEF8_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/coffee-cup-wood-8137318DEF8_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique"}]},{"@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\/1224","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=1224"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1224\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10542"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}