{"id":27860,"date":"2023-08-21T06:50:00","date_gmt":"2023-08-21T04:50:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=27860"},"modified":"2023-10-31T12:58:59","modified_gmt":"2023-10-31T11:58:59","slug":"exemples-procedures-stockees-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/","title":{"rendered":"Exemples de Proc\u00e9dures Stock\u00e9es SQL Server"},"content":{"rendered":"\n<p>Ces exemples de proc\u00e9dures stock\u00e9es SQL Server simples sont des outils puissants qui peuvent simplifier votre travail de d\u00e9veloppement de base de donn\u00e9es. Par exemple, lorsqu&rsquo;il s&rsquo;agit de logique m\u00e9tier complexe int\u00e9gr\u00e9e dans le code SQL. Une proc\u00e9dure stock\u00e9e est un groupe d&rsquo;instructions Transact-SQL compil\u00e9es dans un seul plan d&rsquo;ex\u00e9cution.<\/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\/exemples-procedures-stockees-sql-server\/#1-structure-dune-procedure-stockee-de-base-sql-server\" >1. Structure d&rsquo;une proc\u00e9dure stock\u00e9e de base SQL Server<\/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\/exemples-procedures-stockees-sql-server\/#2-travailler-avec-des-parametres-dans-les-procedures-stockees\" >2. Travailler avec des param\u00e8tres dans les proc\u00e9dures stock\u00e9es<\/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\/exemples-procedures-stockees-sql-server\/#3-gestion-des-erreurs-dans-les-procedures-stockees-sql\" >3. Gestion des erreurs dans les proc\u00e9dures stock\u00e9es SQL<\/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\/exemples-procedures-stockees-sql-server\/#4-utiliser-une-logique-conditionnelle-dans-une-procedure-sql\" >4. Utiliser une logique conditionnelle dans une proc\u00e9dure SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#5-procedure-t-sql-avec-une-boucle\" >5. Proc\u00e9dure T-SQL avec une boucle<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#conclusion-sur-lutilisation-des-procedures-stockees-sql-server\" >Conclusion sur l&rsquo;utilisation des proc\u00e9dures stock\u00e9es SQL Server<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-structure-d-une-procedure-stockee-de-base-sql-server\"><span class=\"ez-toc-section\" id=\"1-structure-dune-procedure-stockee-de-base-sql-server\"><\/span>1. Structure d&rsquo;une proc\u00e9dure stock\u00e9e de base SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Commen\u00e7ons par la structure de base d&rsquo;une proc\u00e9dure stock\u00e9e MS SQL. L&rsquo;instruction CREATE PROCEDURE est utilis\u00e9e pour cr\u00e9er une proc\u00e9dure stock\u00e9e. Elle est suivie du nom de la proc\u00e9dure et, \u00e9ventuellement, des param\u00e8tres que vous souhaitez passer \u00e0 la proc\u00e9dure. Voici un exemple simple pour cr\u00e9er une proc\u00e9dure g\u00e9n\u00e9rique appel\u00e9e <em>MaProcedure<\/em>.<\/p>\n\n\n\n<p>Dans l&rsquo;exemple, la proc\u00e9dure stock\u00e9e nomm\u00e9e <em>MaProcedure<\/em> s\u00e9lectionne simplement tous les enregistrements de la table SQL <em>MaTable<\/em>. Les mots-cl\u00e9s BEGIN et END encadrent les instructions SQL.<\/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 MaProcedure\nAS\n\nBEGIN\n  SELECT * FROM MaTable\nEND\n\nGO<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-travailler-avec-des-parametres-dans-les-procedures-stockees\"><span class=\"ez-toc-section\" id=\"2-travailler-avec-des-parametres-dans-les-procedures-stockees\"><\/span>2. Travailler avec des param\u00e8tres dans les proc\u00e9dures stock\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\"><strong>Les param\u00e8tres peuvent \u00eatre utilis\u00e9s pour transmettre des valeurs \u00e0 la proc\u00e9dure stock\u00e9e<\/strong><\/a>. Modifions maintenant <em>MaProcedure<\/em> pour qu&rsquo;elle accepte un param\u00e8tre unique. Comme vous pouvez le voir, le param\u00e8tre @MonParam est de type INT. Il est utilis\u00e9 dans la clause WHERE pour filtrer les enregistrements de <em>MaTable<\/em>.<\/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 MaProcedure\n   @MonParam INT\nAS\nBEGIN\n   SELECT *\n   FROM   MaTable\n   WHERE  MaColonne = @MonParam\nEND\nGO<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-gestion-des-erreurs-dans-les-procedures-stockees-sql\"><span class=\"ez-toc-section\" id=\"3-gestion-des-erreurs-dans-les-procedures-stockees-sql\"><\/span>3. Gestion des erreurs dans les proc\u00e9dures stock\u00e9es SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La gestion des erreurs est un aspect vital de l&rsquo;\u00e9criture de code T-SQL robuste. Heureusement, <strong>SQL Server fournit des constructions TRY CATCH<\/strong> \u00e0 cet effet. Ici, le bloc TRY contient le code SQL qui pourrait provoquer une exception.<\/p>\n\n\n\n<p>Techniquement, cela signifie que si une erreur se produit, le contr\u00f4le est transf\u00e9r\u00e9 au bloc CATCH o\u00f9 l&rsquo;erreur peut \u00eatre trait\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=\"\">CREATE PROCEDURE MaProcedure\n   @MonParam INT\nAS\n\nBEGIN TRY\n  SELECT *\n  FROM   MaTable\n  WHERE  MaColonne = @MonParam\nEND TRY\n\nBEGIN CATCH\n  SELECT ERROR_MESSAGE() AS MessageErreur;\nEND CATCH\n\nGO<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-utiliser-une-logique-conditionnelle-dans-une-procedure-sql\"><span class=\"ez-toc-section\" id=\"4-utiliser-une-logique-conditionnelle-dans-une-procedure-sql\"><\/span>4. Utiliser une logique conditionnelle dans une proc\u00e9dure SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Les exemples de proc\u00e9dures stock\u00e9es SQL Server utilisent souvent des instructions IF ELSE pour la logique conditionnelle.<\/strong> Cela peut grandement augmenter l&rsquo;efficacit\u00e9 et la maintenabilit\u00e9.<\/p>\n\n\n\n<p>En effet, l&rsquo;instruction IF-ELSE v\u00e9rifie si @MonParam est NULL. S&rsquo;il ne l&rsquo;est pas, une instruction SELECT filtr\u00e9e est ex\u00e9cut\u00e9e. S&rsquo;il est NULL, tous les enregistrements sont renvoy\u00e9s. Sinon, les r\u00e9sultats ne renverraient rien, une autre option consiste \u00e0 d\u00e9finir une valeur par d\u00e9faut pour le param\u00e8tre.<\/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 MaProcedure @MonParam INT\nAS\nBEGIN\n   IF @MonParam IS NOT NULL\n      BEGIN\n        SELECT *\n\t   FROM   MaTable \n\t   WHERE  MaColonne = @MonParam\n      END\n   ELSE\n      BEGIN\n        SELECT *\n\t   FROM   MaTable\n      END\nEND\nGO<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-5-procedure-t-sql-avec-une-boucle\"><span class=\"ez-toc-section\" id=\"5-procedure-t-sql-avec-une-boucle\"><\/span>5. Proc\u00e9dure T-SQL avec une boucle<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Les constructions de boucle, comme les boucles WHILE, peuvent \u00eatre utilis\u00e9es dans les proc\u00e9dures stock\u00e9es SQL pour it\u00e9rer sur un ensemble d&rsquo;enregistrements. Cette <a href=\"https:\/\/learn.microsoft.com\/fr-fr\/sql\/t-sql\/tutorial-writing-transact-sql-statements?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">documentation Microsoft<\/a> fournit plus de d\u00e9tails \u00e0 ce sujet.<\/p>\n\n\n\n<p>Ainsi, dans cet dernier exemple, une proc\u00e9dure stock\u00e9e nomm\u00e9e <em>ImprimerIterations<\/em> est cr\u00e9\u00e9e. Lorsque cette proc\u00e9dure est ex\u00e9cut\u00e9e, elle affiche un message pour chaque it\u00e9ration, 10 fois au total.<\/p>\n\n\n\n<p>L&rsquo;instruction GO est un s\u00e9parateur de lot qui signifie la fin de la cr\u00e9ation de la proc\u00e9dure stock\u00e9e et le d\u00e9but de toutes les commandes SQL ult\u00e9rieures. La commande EXEC ImprimerIterations est un simple appel \u00e0 la proc\u00e9dure stock\u00e9e pour ex\u00e9cuter sa logique.<\/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 ImprimerIterations\nAS\nBEGIN\n    DECLARE @Compteur INT = 1\n\n    WHILE @Compteur &lt;= 10\n    BEGIN\n        PRINT 'Il s'agit de l'it\u00e9ration de la boucle ' + CAST(@Compteur AS NVARCHAR(2))\n        SET @Compteur = @Compteur + 1\n    END\nEND\nGO\n\n-- Pour ex\u00e9cuter la proc\u00e9dure stock\u00e9e\nEXEC ImprimerIterations\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"820\" height=\"660\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/10\/sql-server_stored-procedure-loop-while.jpg\" alt=\"Exemples de proc\u00e9dures stock\u00e9es SQL Server utilisant une boucle WHILE\" class=\"wp-image-27834\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/10\/sql-server_stored-procedure-loop-while.jpg 820w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/10\/sql-server_stored-procedure-loop-while-300x241.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/10\/sql-server_stored-procedure-loop-while-768x618.jpg 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><figcaption class=\"wp-element-caption\"><em>Exemples de proc\u00e9dures stock\u00e9es SQL Server utilisant une boucle WHILE<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion-sur-l-utilisation-des-procedures-stockees-sql-server\"><span class=\"ez-toc-section\" id=\"conclusion-sur-lutilisation-des-procedures-stockees-sql-server\"><\/span>Conclusion sur l&rsquo;utilisation des proc\u00e9dures stock\u00e9es SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><b>Les proc\u00e9dures stock\u00e9es SQL utiles<\/b> peuvent grandement am\u00e9liorer l&rsquo;efficacit\u00e9, la lisibilit\u00e9 et la maintenance de votre code SQL server. Elles permettent d&rsquo;encapsuler la logique m\u00e9tier complexe dans des programmes r\u00e9utilisables et modulaires. De la gestion des erreurs \u00e0 l&rsquo;utilisation de la logique conditionnelle, en passant par les constructions de boucle, les proc\u00e9dures stock\u00e9es de base dans SQL Server offrent une large gamme de possibilit\u00e9s.<\/p>\n\n\n\n<p> Pensez \u00e0 les utiliser dans votre prochain projet SQL Server pour un code plus propre et plus efficace. IL est par exemple possible de g\u00e9n\u00e9rer <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/\"><strong>du code T-SQL dynamique<\/strong><\/a> avec des variables pour r\u00e9p\u00e9ter certaines op\u00e9rations.<\/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=\"8SASvOLm6i\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/\">Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique<\/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\u00a0Proc\u00e9dure T-SQL avec une variable en dur et du code dynamique\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/embed\/#?secret=KTLtj6yy2d#?secret=8SASvOLm6i\" data-secret=\"8SASvOLm6i\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Ces exemples de proc\u00e9dures stock\u00e9es SQL Server simples sont des outils puissants qui peuvent simplifier votre travail de d\u00e9veloppement de base de donn\u00e9es. Par exemple, lorsqu&rsquo;il s&rsquo;agit de logique m\u00e9tier complexe int\u00e9gr\u00e9e dans le code SQL. Une proc\u00e9dure stock\u00e9e <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/\" title=\"Exemples de Proc\u00e9dures Stock\u00e9es SQL Server\">&#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-27860","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>Exemples de Proc\u00e9dures Stock\u00e9es SQL Server - T-SQL<\/title>\n<meta name=\"description\" content=\"Tutoriel sur les bases de donn\u00e9es avec des exemples de proc\u00e9dures stock\u00e9es SQL Server simples, \u00e9cris avec des scripts T-SQL depuis SSMS.\" \/>\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\/exemples-procedures-stockees-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exemples de Proc\u00e9dures Stock\u00e9es SQL Server\" \/>\n<meta property=\"og:description\" content=\"Tutoriel sur les bases de donn\u00e9es avec des exemples de proc\u00e9dures stock\u00e9es SQL Server simples, \u00e9cris avec des scripts T-SQL depuis SSMS.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-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-08-21T04:50:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-31T11:58:59+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=\"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\/exemples-procedures-stockees-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Exemples de Proc\u00e9dures Stock\u00e9es SQL Server\",\"datePublished\":\"2023-08-21T04:50:00+00:00\",\"dateModified\":\"2023-10-31T11:58:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/\"},\"wordCount\":688,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#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\/exemples-procedures-stockees-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/\",\"name\":\"Exemples de Proc\u00e9dures Stock\u00e9es SQL Server - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_1920x1080.jpg\",\"datePublished\":\"2023-08-21T04:50:00+00:00\",\"dateModified\":\"2023-10-31T11:58:59+00:00\",\"description\":\"Tutoriel sur les bases de donn\u00e9es avec des exemples de proc\u00e9dures stock\u00e9es SQL Server simples, \u00e9cris avec des scripts T-SQL depuis SSMS.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#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\/exemples-procedures-stockees-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exemples de Proc\u00e9dures Stock\u00e9es 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":"Exemples de Proc\u00e9dures Stock\u00e9es SQL Server - T-SQL","description":"Tutoriel sur les bases de donn\u00e9es avec des exemples de proc\u00e9dures stock\u00e9es SQL Server simples, \u00e9cris avec des scripts T-SQL depuis SSMS.","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\/exemples-procedures-stockees-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Exemples de Proc\u00e9dures Stock\u00e9es SQL Server","og_description":"Tutoriel sur les bases de donn\u00e9es avec des exemples de proc\u00e9dures stock\u00e9es SQL Server simples, \u00e9cris avec des scripts T-SQL depuis SSMS.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-21T04:50:00+00:00","article_modified_time":"2023-10-31T11:58:59+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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Exemples de Proc\u00e9dures Stock\u00e9es SQL Server","datePublished":"2023-08-21T04:50:00+00:00","dateModified":"2023-10-31T11:58:59+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/"},"wordCount":688,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#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\/exemples-procedures-stockees-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/","name":"Exemples de Proc\u00e9dures Stock\u00e9es SQL Server - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/watch-C16A734EA20_1920x1080.jpg","datePublished":"2023-08-21T04:50:00+00:00","dateModified":"2023-10-31T11:58:59+00:00","description":"Tutoriel sur les bases de donn\u00e9es avec des exemples de proc\u00e9dures stock\u00e9es SQL Server simples, \u00e9cris avec des scripts T-SQL depuis SSMS.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/exemples-procedures-stockees-sql-server\/#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\/exemples-procedures-stockees-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Exemples de Proc\u00e9dures Stock\u00e9es 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\/27860","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=27860"}],"version-history":[{"count":3,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/27860\/revisions"}],"predecessor-version":[{"id":27866,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/27860\/revisions\/27866"}],"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=27860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=27860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=27860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}