{"id":963,"date":"2023-11-16T07:41:00","date_gmt":"2023-11-16T06:41:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=963"},"modified":"2023-11-22T11:44:28","modified_gmt":"2023-11-22T10:44:28","slug":"procedure-stockee-sql-server-parametres","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/","title":{"rendered":"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><em>Comment cr\u00e9er et ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec un ou plusieurs param\u00e8tres ?<\/em><\/h4>\n\n\n\n<p>Pour rappel, cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec des param\u00e8tres revient \u00e0 grouper et organiser un ensemble de commandes T-SQL avec des variables en entr\u00e9es. Ce tutoriel explique donc comment utiliser une requ\u00eate SELECT sur la table Clients depuis une proc\u00e9dure stock\u00e9e SQL Server. Par exemple, au lieu d&rsquo;afficher toutes les donn\u00e9es de la table, pour afficher un seul client, il suffit de filtrer la table gr\u00e2ce au param\u00e8tre pass\u00e9 en entr\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\/procedure-stockee-sql-server-parametres\/#1-preparer-la-table-des-clients-utilisee-dans-la-procedure\" >1. Pr\u00e9parer la table des clients utilis\u00e9e dans la proc\u00e9dure<\/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-stockee-sql-server-parametres\/#2-code-sql-pour-creer-une-procedure-avec-un-parametre\" >2. Code SQL pour cr\u00e9er une proc\u00e9dure avec un param\u00e8tre<\/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\/procedure-stockee-sql-server-parametres\/#3-valeur-par-defaut-des-variables-dans-une-procedure-stockee\" >3. Valeur par d\u00e9faut des variables dans une proc\u00e9dure stock\u00e9e<\/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\/procedure-stockee-sql-server-parametres\/#4-procedure-stockee-sql-avec-plusieurs-parametres\" >4. Proc\u00e9dure stock\u00e9e SQL avec plusieurs param\u00e8tres<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-preparer-la-table-des-clients-utilisee-dans-la-procedure\"><\/span>1. Pr\u00e9parer la table des clients utilis\u00e9e dans la proc\u00e9dure<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Avant d&rsquo;utiliser le script de cr\u00e9ation de la proc\u00e9dure stock\u00e9e, cr\u00e9er d&rsquo;abord la table des Clients. Ensuite, utiliser ce&nbsp;script SQL Server pour <a href=\"https:\/\/expert-only.com\/t-sql\/creer-table-sql-server\/\">cr\u00e9er la table des Clients<\/a>. Pour rappel, voici le script pour cr\u00e9er la table depuis une fen\u00eatre SSMS:<\/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\n-- Ins\u00e9rer des donn\u00e9es pour les exemples de manipulation\nINSERT INTO dbo.CLIENTS ( NOM, VILLE ) VALUES ( N'MAMMADOU', 'Lyon');\nINSERT INTO dbo.CLIENTS ( NOM, VILLE ) VALUES ( N'SERGEI', 'Lyon');\nINSERT INTO dbo.CLIENTS ( NOM, VILLE ) VALUES ( N'CHRISTOPHE', 'Paris');\n\n-- V\u00e9rifier 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=\"640\" height=\"263\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/sql-server-exemple-table-clients.png\" alt=\"Requ\u00eate SQL Server pour afficher le contenu de la table des clients depuis SSMS\" 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\"><em>Requ\u00eate SQL Server pour afficher le contenu de la table des clients depuis SSMS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-code-sql-pour-creer-une-procedure-avec-un-parametre\"><span class=\"ez-toc-section\" id=\"2-code-sql-pour-creer-une-procedure-avec-un-parametre\"><\/span>2. Code SQL pour cr\u00e9er une proc\u00e9dure avec un param\u00e8tre<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici un exemple de proc\u00e9dure stock\u00e9e SQL Server qui utilise un seul et unique param\u00e8tre. Ce dernier est le num\u00e9ro de client. La proc\u00e9dure affiche le client dont le num\u00e9ro est pass\u00e9 en param\u00e8tre. Pour appeler la proc\u00e9dure stock\u00e9e, ex\u00e9cuter le code comme suit avec EXEC ou EXECUTE. D\u00e9finir la variable avec un num\u00e9ro de client.<\/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=\"\">CREATE PROCEDURE uspGetClient \n   @NoClient INT\nAS\n   SELECT *\n   FROM   [dbo].[CLIENTS]\n   WHERE  [NOCLIENT] = @NoClient\nGO\n\nEXEC uspGetClient @NoClient = 3;\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"665\" height=\"304\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/procedure-stockee-sql-server-un-parametre.png\" alt=\"Script pour cr\u00e9er une proc\u00e9dure SQL Server avec un param\u00e8tre\" class=\"wp-image-965\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/procedure-stockee-sql-server-un-parametre.png 665w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/procedure-stockee-sql-server-un-parametre-300x137.png 300w\" sizes=\"auto, (max-width: 665px) 100vw, 665px\" \/><figcaption class=\"wp-element-caption\"><em>Script pour cr\u00e9er une proc\u00e9dure SQL Server avec un param\u00e8tre<\/em><\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\">Ex\u00e9cuter une proc\u00e9dure sans valeur de param\u00e8tre g\u00e9n\u00e8re une erreur<\/h3>\n\n\n\n<p>Dans l&rsquo;exemple pr\u00e9c\u00e9dent, l&rsquo;appel de la proc\u00e9dure utilise la valeur du param\u00e8tre. De la m\u00eame mani\u00e8re, ex\u00e9cuter la <a href=\"https:\/\/fr.wikibooks.org\/wiki\/Oracle_Database\/Proc\u00e9dures_stock\u00e9es\" target=\"_blank\" rel=\"noreferrer noopener\">proc\u00e9dure<\/a> SQL Server sans d\u00e9finir de valeur au param\u00e8tre du num\u00e9ro de client:<\/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=\"\">EXEC uspGetClient;\n<\/pre>\n\n\n\n<p>Alors le message d&rsquo;erreur SQL suivant est affich\u00e9 car le param\u00e8tre num\u00e9ro de client est obligatoire et n&rsquo;est pas de valeur par d\u00e9faut assign\u00e9e : <\/p>\n\n\n\n<p><em>Msg 201, Level 16, State 4, Procedure uspGetClient, Line 0<br>Procedure or function &lsquo;uspGetClient&rsquo; expects parameter &lsquo;@NoClient&rsquo;, which was not supplied.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-valeur-par-defaut-des-variables-dans-une-procedure-stockee\"><span class=\"ez-toc-section\" id=\"3-valeur-par-defaut-des-variables-dans-une-procedure-stockee\"><\/span>3. Valeur par d\u00e9faut des variables dans une proc\u00e9dure stock\u00e9e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dans la plupart des cas, il est conseill\u00e9 de passer une valeur aux param\u00e8tres. Dans la pratique, ce n&rsquo;est pas toujours possible voire utile. Pour pr\u00e9voir le cas o\u00f9 un appel \u00e0 la proc\u00e9dure se fait sans param\u00e8tre, utiliser par exemple la valeur NULL. En effet NULL permet de cr\u00e9er une valeur de param\u00e8tre dans la proc\u00e9dure et \u00e9viter les erreurs.<\/p>\n\n\n\n<p>Apr\u00e8s cela, utiliser cette deuxi\u00e8me version de la proc\u00e9dure stock\u00e9e sans param\u00e8tre. Cette fois, aucune erreur n&rsquo;est affich\u00e9e. En effet, la requ\u00eate ne renvoie aucune ligne car tous les clients dans la table ont un num\u00e9ro de client.<\/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=\"\">-- Tester si la proc\u00e9dure existe et la supprimer\nIF EXISTS (\n\tSELECT name \n\tFROM sysobjects \n\tWHERE name = 'uspGetClient' AND type = 'P'\n)\n  DROP PROCEDURE uspGetClient\nGO\n\n-- Cr\u00e9er la proc\u00e9dure avec une valeur par d\u00e9faut\nCREATE PROCEDURE uspGetClient \n  @NoClient int = NULL\nAS\n  SELECT\t*\n  FROM\t[dbo].[CLIENTS]\n  WHERE\t[NOCLIENT] = @NoClient\nGO\n\n-- Ex\u00e9cuter la proc\u00e9dure stock\u00e9e sans passer de param\u00e8tre\nEXEC uspGetClient; \n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"729\" height=\"355\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/procedure-sql-server-parametre-defaut-null.png\" alt=\"Supprimer, cr\u00e9er et ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec un param\u00e8tre par d\u00e9faut\" class=\"wp-image-969\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/procedure-sql-server-parametre-defaut-null.png 729w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/procedure-sql-server-parametre-defaut-null-300x146.png 300w\" sizes=\"auto, (max-width: 729px) 100vw, 729px\" \/><figcaption class=\"wp-element-caption\"><em>Supprimer, cr\u00e9er et ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec un param\u00e8tre par d\u00e9faut<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-procedure-stockee-sql-avec-plusieurs-parametres\"><span class=\"ez-toc-section\" id=\"4-procedure-stockee-sql-avec-plusieurs-parametres\"><\/span>4. Proc\u00e9dure stock\u00e9e SQL avec plusieurs param\u00e8tres<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C&rsquo;est la m\u00eame chose qu&rsquo;avec un seul param\u00e8tre, mais il faut lister, cr\u00e9er et appeler chaque param\u00e8tre de mani\u00e8re isol\u00e9e. Ainsi, lister et s\u00e9parer par une virgule chaque param\u00e8tre et son type de donn\u00e9es, comme dans l&rsquo;exemple de code ci-dessous:<\/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=\"\">-- Tester si la proc\u00e9dure existe et la supprimer\nIF EXISTS (\n\tSELECT name \n\tFROM sysobjects \n\tWHERE name = 'uspGetClient' AND type = 'P'\n)\n  DROP PROCEDURE uspGetClient\nGO\n\n-- Cr\u00e9er la m\u00eame proc\u00e9dure avec deux param\u00e8tres et les valeurs par d\u00e9faut\nCREATE PROCEDURE uspGetClient \n  @NoClient\tint = NULL, \n  @Ville\tnvarchar(20) = NULL\nAS\n  SELECT\t*\n  FROM\t[dbo].[CLIENTS]\n  WHERE\t[NOCLIENT]\t= @NoClient\n    OR\t[VILLE]\t\t= @Ville\nGO\n\n-- Appeler la proc\u00e9dure avec diff\u00e9rentes combinaisons de param\u00e8tres\nEXEC uspGetClient @NoClient = 1, @Ville = 'Lyon';\n\nEXEC uspGetClient @NoClient = 1;\n\nEXEC uspGetClient @Ville = 'Paris';\n<\/pre>\n\n\n\n<p>En effet, on peut appeler chacun des param\u00e8tres seuls, ou les deux en m\u00eame temps. Il est aussi possible de ne passer aucun param\u00e8tre car la proc\u00e9dure utilise alors les valeurs par d\u00e9faut avec la valeur NULL.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"681\" height=\"559\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/procedure-sql-server-plusieurs-parametres.png\" alt=\"Ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec plusieurs param\u00e8tres par d\u00e9faut\" class=\"wp-image-971\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/procedure-sql-server-plusieurs-parametres.png 681w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/procedure-sql-server-plusieurs-parametres-300x246.png 300w\" sizes=\"auto, (max-width: 681px) 100vw, 681px\" \/><figcaption class=\"wp-element-caption\"><em>Ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec plusieurs param\u00e8tres par d\u00e9faut<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Enfin, appeler la proc\u00e9dure stock\u00e9e <em>uspGetClient<\/em> sans param\u00e8tre est aussi possible. Elle renvoie dans ce cas toutes les donn\u00e9es depuis la table des clients. Car c&rsquo;est l&rsquo;op\u00e9rateur logique OR qui est utilis\u00e9 dans la clause WHERE et donc le filtre est sans effet.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Les proc\u00e9dures SQL avec param\u00e8tres permettent du code flexible<\/h3>\n\n\n\n<p>En conclusion, cet article explique comment cr\u00e9er et ex\u00e9cuter des proc\u00e9dures stock\u00e9es SQL Server avec des param\u00e8tres, et nous permet donc :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>De pr\u00e9parer la table des clients pour l&rsquo;utilisation dans les proc\u00e9dures stock\u00e9es.<\/li>\n\n\n\n<li>De cr\u00e9er des proc\u00e9dures avec un ou plusieurs param\u00e8tres.<\/li>\n\n\n\n<li>De g\u00e9rer les valeurs par d\u00e9faut pour les param\u00e8tres.<\/li>\n\n\n\n<li>D&rsquo;ex\u00e9cuter les proc\u00e9dures avec diff\u00e9rentes combinaisons de param\u00e8tres.<\/li>\n<\/ul>\n\n\n\n<p>Ces connaissances permettent d&rsquo;optimiser l&rsquo;utilisation des proc\u00e9dures stock\u00e9es SQL Server dans les projets, en tirant parti de la flexibilit\u00e9 et de la modularit\u00e9 qu&rsquo;elles offrent. Voici un autre tutoriel qui explique comment cr\u00e9er <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-insert-into-depuis-select\/\">une requ\u00eate SQL pour ins\u00e9rer des donn\u00e9es depuis une requ\u00eate de s\u00e9lection<\/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=\"dHxmQ9mr43\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-insert-into-depuis-select\/\">Requ\u00eate SQL Server Insert Into depuis un Select<\/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\u00eate SQL Server Insert Into depuis un Select\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-insert-into-depuis-select\/embed\/#?secret=ybZ4aDZoTs#?secret=dHxmQ9mr43\" data-secret=\"dHxmQ9mr43\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p class=\"has-text-align-center\"><strong><em>Vous trouvez cet article utile? Partagez-le.<\/em><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment cr\u00e9er et ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec un ou plusieurs param\u00e8tres ? Pour rappel, cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec des param\u00e8tres revient \u00e0 grouper et organiser un ensemble de commandes T-SQL avec des variables <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\" title=\"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10922,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-963","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>Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres - T-SQL<\/title>\n<meta name=\"description\" content=\"Comment cr\u00e9er et ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec des param\u00e8tres en entr\u00e9e et leur assigner une valeur par d\u00e9faut.\" \/>\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-stockee-sql-server-parametres\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres\" \/>\n<meta property=\"og:description\" content=\"Comment cr\u00e9er et ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec des param\u00e8tres en entr\u00e9e et leur assigner une valeur par d\u00e9faut.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\" \/>\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-11-16T06:41:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-22T10:44:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_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-stockee-sql-server-parametres\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres\",\"datePublished\":\"2023-11-16T06:41:00+00:00\",\"dateModified\":\"2023-11-22T10:44:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\"},\"wordCount\":866,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\",\"name\":\"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_1920x1080.jpg\",\"datePublished\":\"2023-11-16T06:41:00+00:00\",\"dateModified\":\"2023-11-22T10:44:28+00:00\",\"description\":\"Comment cr\u00e9er et ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec des param\u00e8tres en entr\u00e9e et leur assigner une valeur par d\u00e9faut.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres\"}]},{\"@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":"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres - T-SQL","description":"Comment cr\u00e9er et ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec des param\u00e8tres en entr\u00e9e et leur assigner une valeur par d\u00e9faut.","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-stockee-sql-server-parametres\/","og_locale":"fr_FR","og_type":"article","og_title":"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres","og_description":"Comment cr\u00e9er et ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec des param\u00e8tres en entr\u00e9e et leur assigner une valeur par d\u00e9faut.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-11-16T06:41:00+00:00","article_modified_time":"2023-11-22T10:44:28+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_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-stockee-sql-server-parametres\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres","datePublished":"2023-11-16T06:41:00+00:00","dateModified":"2023-11-22T10:44:28+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/"},"wordCount":866,"commentCount":2,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/","name":"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_1920x1080.jpg","datePublished":"2023-11-16T06:41:00+00:00","dateModified":"2023-11-22T10:44:28+00:00","description":"Comment cr\u00e9er et ex\u00e9cuter une proc\u00e9dure stock\u00e9e SQL Server avec des param\u00e8tres en entr\u00e9e et leur assigner une valeur par d\u00e9faut.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres"}]},{"@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\/963","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=963"}],"version-history":[{"count":10,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/963\/revisions"}],"predecessor-version":[{"id":29292,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/963\/revisions\/29292"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10922"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}