{"id":2075,"date":"2023-09-25T06:19:00","date_gmt":"2023-09-25T04:19:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=2075"},"modified":"2023-11-09T17:19:15","modified_gmt":"2023-11-09T16:19:15","slug":"modifier-une-procedure-stockee-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/","title":{"rendered":"Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ?"},"content":{"rendered":"\n<p class=\"has-text-align-left\"><strong><em>Comment modifier le code d&rsquo;une proc\u00e9dure stock\u00e9e SQL Server avec un script T-SQL ?<\/em><\/strong><\/p>\n\n\n\n<p>Utiliser la commande SQL Server ALTER PROCEDURE pour modifier le code \u00e0 ex\u00e9cuter par la proc\u00e9dure stock\u00e9e. La modification consiste \u00e0 ajouter la possibilit\u00e9 de filtrer et d&rsquo;afficher tous les clients dont la ville ressemble au param\u00e8tre @Ville. La proc\u00e9dure stock\u00e9e tri maintenant les donn\u00e9es par num\u00e9ro de client descendant, c&rsquo;est \u00e0 dire du dernier num\u00e9ro de client au premier. <\/p>\n\n\n\n<p>Ce tutoriel permet de modifier <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\">une proc\u00e9dure stock\u00e9e<\/a> SQL Server existante dans la base. La commande utile est ALTER PROCEDURE. La d\u00e9finition d&rsquo;une proc\u00e9dure stock\u00e9e est une suite d&rsquo;op\u00e9rations d\u00e9finies au pr\u00e9alable et ex\u00e9cut\u00e9es pour accomplir un ensemble de t\u00e2che. La proc\u00e9dure est enregistr\u00e9e pour \u00eatre r\u00e9p\u00e9t\u00e9e de mani\u00e8re industrialis\u00e9e.<\/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\/modifier-une-procedure-stockee-sql-server\/#creer-au-prealable-la-table-et-la-procedure-a-modifier\" >Cr\u00e9er au pr\u00e9alable la table et la proc\u00e9dure \u00e0 modifier<\/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\/modifier-une-procedure-stockee-sql-server\/#exemple-de-code-pour-mettre-a-jour-une-procedure-ms-sql\" >Exemple de code pour mettre \u00e0 jour une proc\u00e9dure MS SQL<\/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\/modifier-une-procedure-stockee-sql-server\/#conclusion\" >Conclusion<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#tutoriels-pour-gerer-les-procedures-stockees-sql-server\" >Tutoriels pour g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"creer-au-prealable-la-table-et-la-procedure-a-modifier\"><\/span>Cr\u00e9er au pr\u00e9alable la table et la proc\u00e9dure \u00e0 modifier<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ex\u00e9cuter au pr\u00e9alable le script pour cr\u00e9er la proc\u00e9dure T-SQL \u00e0 modifier. La proc\u00e9dure de base permet simplement d&rsquo;afficher les donn\u00e9es contenues dans la table des clients, sans filtre.<\/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 PROCEDURE uspListeClients\nAS\n   SELECT *\n   FROM   dbo.CLIENTS\nGO\n<\/pre>\n\n\n\n<p>La table utilis\u00e9e en source est <a href=\"https:\/\/expert-only.com\/transact-sql\/exemple-script-sql-server-create-table\/\">la table des clients<\/a> cr\u00e9\u00e9e dans une base 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=\"\">-- Cr\u00e9er la table CLIENTS avec la colonne NOM d\u00e9clar\u00e9e comme UNIQUE\nCREATE TABLE [dbo].[CLIENTS] (\n   [NOCLIENT]  int IDENTITY(1,1),\n   [NOM]       nvarchar(20) UNIQUE,\n   [VILLE]     nvarchar(20)\n)\nGO\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"exemple-de-code-pour-mettre-a-jour-une-procedure-ms-sql\"><\/span>Exemple de code pour mettre \u00e0 jour une proc\u00e9dure MS SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici un exemple de script pour modifier une <a href=\"https:\/\/www.larousse.fr\/dictionnaires\/francais\/proc%C3%A9dure\/64055\" target=\"_blank\" rel=\"noreferrer noopener\">proc\u00e9dure<\/a> stock\u00e9e en T-SQL. Pour l&rsquo;adapter et l&rsquo;ex\u00e9cuter, se connecter \u00e0 <a href=\"https:\/\/expert-only.com\/base-sql-server\/creer-une-base-de-donnees-avec-sql-server-management-studio\/\">la base de donn\u00e9es<\/a> avec SSMS et ex\u00e9cuter le code. La proc\u00e9dure modifi\u00e9e utilise deux param\u00e8tres en entr\u00e9e: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><em>NoClient <\/em>qui est le num\u00e9ro du client<\/li>\n\n\n\n<li><em>Ville<\/em> qui est le nom de la ville du client<\/li>\n<\/ol>\n\n\n\n<p>Les param\u00e8tres sont facultatifs et sont renseign\u00e9s \u00e0 l&rsquo;appel de la fonction. La proc\u00e9dure filtre alors le contenu de la table avec les valeurs des param\u00e8tres. Le filtre sur le num\u00e9ro de client est strict car un num\u00e9ro de client est unique et car c&rsquo;est un entier.<\/p>\n\n\n\n<p>Le filtre sur le nom de la ville est large car il retourne tous les clients associ\u00e9s \u00e0 la ville renseign\u00e9e, c&rsquo;est \u00e0 dire avec une ville contenant texte saisi \u00e0 l&rsquo;appel de la proc\u00e9dure modifi\u00e9e.<\/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=\"\">ALTER PROCEDURE uspGetClient\n   @NoClient int = NULL,\n   @Ville nvarchar(20) = NULL\nAS\n   SELECT *\n   FROM   [dbo].[CLIENTS]\n   WHERE  [NOCLIENT] = @NoClient\n      OR  [VILLE] LIKE '%@Ville%'\n   ORDER BY 1 DESC\nGO\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La modification d&rsquo;une proc\u00e9dure stock\u00e9e du serveur SQL \u00e0 l&rsquo;aide de la commande ALTER PROCEDURE est une t\u00e2che simple qui peut am\u00e9liorer de mani\u00e8re significative la fonctionnalit\u00e9 et l&rsquo;efficacit\u00e9 des op\u00e9rations de votre base de donn\u00e9es. Comme expliqu\u00e9 et illustr\u00e9 par le code, nous pouvons \u00e9tendre les capacit\u00e9s d&rsquo;une proc\u00e9dure stock\u00e9e non seulement pour effectuer des op\u00e9rations plus complexes de r\u00e9cup\u00e9ration et de tri des donn\u00e9es.<\/p>\n\n\n\n<p>La mise en \u0153uvre de ces meilleures pratiques dans le d\u00e9veloppement de bases de donn\u00e9es peut contribuer \u00e0 la cr\u00e9ation d&rsquo;applications de bases de donn\u00e9es robustes, fiables et \u00e9volutives. Maintenant, pour aller plus loin dans l&rsquo;apprentissage de T-SQL, voici un court <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-fonction-sql-server-avec-un-script\/\">tutoriel sur la cr\u00e9ation d&rsquo;une fonction SQL Server<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter 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=\"TYOTfYwwSr\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-fonction-sql-server-avec-un-script\/\">Comment cr\u00e9er une fonction SQL Server avec un script T-SQL ?<\/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\u00a0Comment cr\u00e9er une fonction SQL Server avec un script T-SQL ?\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-fonction-sql-server-avec-un-script\/embed\/#?secret=WiqqHov2QV#?secret=TYOTfYwwSr\" data-secret=\"TYOTfYwwSr\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"tutoriels-pour-gerer-les-procedures-stockees-sql-server\"><\/span>Tutoriels pour g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/\">Supprimer une proc\u00e9dure stock\u00e9e SQL Server sans erreur<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\">Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec des param\u00e8tres.<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment modifier le code d&rsquo;une proc\u00e9dure stock\u00e9e SQL Server avec un script T-SQL ? Utiliser la commande SQL Server ALTER PROCEDURE pour modifier le code \u00e0 ex\u00e9cuter par la proc\u00e9dure stock\u00e9e. La modification consiste \u00e0 ajouter la possibilit\u00e9 de <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/\" title=\"Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10837,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[240],"class_list":{"0":"post-2075","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql","8":"tag-alter"},"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>Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ? T-SQL<\/title>\n<meta name=\"description\" content=\"Pour modifier une proc\u00e9dure stock\u00e9e SQL Server avec un script, utiliser la commande Alter Procedure et mettre \u00e0 jour le code T-SQL.\" \/>\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\/modifier-une-procedure-stockee-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ?\" \/>\n<meta property=\"og:description\" content=\"Pour modifier une proc\u00e9dure stock\u00e9e SQL Server avec un script, utiliser la commande Alter Procedure et mettre \u00e0 jour le code T-SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/\" \/>\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=\"2023-09-25T04:19:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T16:19:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/programming-1857236_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\/modifier-une-procedure-stockee-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ?\",\"datePublished\":\"2023-09-25T04:19:00+00:00\",\"dateModified\":\"2023-11-09T16:19:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/\"},\"wordCount\":577,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/programming-1857236_1920x1080.jpg\",\"keywords\":[\"alter\"],\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/\",\"name\":\"Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/programming-1857236_1920x1080.jpg\",\"datePublished\":\"2023-09-25T04:19:00+00:00\",\"dateModified\":\"2023-11-09T16:19:15+00:00\",\"description\":\"Pour modifier une proc\u00e9dure stock\u00e9e SQL Server avec un script, utiliser la commande Alter Procedure et mettre \u00e0 jour le code T-SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/programming-1857236_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/programming-1857236_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment modifier une proc\u00e9dure stock\u00e9e 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":"Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ? T-SQL","description":"Pour modifier une proc\u00e9dure stock\u00e9e SQL Server avec un script, utiliser la commande Alter Procedure et mettre \u00e0 jour le code T-SQL.","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\/modifier-une-procedure-stockee-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ?","og_description":"Pour modifier une proc\u00e9dure stock\u00e9e SQL Server avec un script, utiliser la commande Alter Procedure et mettre \u00e0 jour le code T-SQL.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-09-25T04:19:00+00:00","article_modified_time":"2023-11-09T16:19:15+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/programming-1857236_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\/modifier-une-procedure-stockee-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ?","datePublished":"2023-09-25T04:19:00+00:00","dateModified":"2023-11-09T16:19:15+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/"},"wordCount":577,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/programming-1857236_1920x1080.jpg","keywords":["alter"],"articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/","name":"Comment modifier une proc\u00e9dure stock\u00e9e SQL Server ? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/programming-1857236_1920x1080.jpg","datePublished":"2023-09-25T04:19:00+00:00","dateModified":"2023-11-09T16:19:15+00:00","description":"Pour modifier une proc\u00e9dure stock\u00e9e SQL Server avec un script, utiliser la commande Alter Procedure et mettre \u00e0 jour le code T-SQL.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/programming-1857236_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/programming-1857236_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Comment modifier une proc\u00e9dure stock\u00e9e 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\/2075","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=2075"}],"version-history":[{"count":1,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/2075\/revisions"}],"predecessor-version":[{"id":28939,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/2075\/revisions\/28939"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10837"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=2075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=2075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=2075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}