{"id":9614,"date":"2023-08-21T05:02:00","date_gmt":"2023-08-21T03:02:00","guid":{"rendered":"https:\/\/expert-only.com\/?page_id=9614"},"modified":"2023-10-30T18:05:21","modified_gmt":"2023-10-30T17:05:21","slug":"gerer-les-procedures-stockees-sql-server","status":"publish","type":"page","link":"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/","title":{"rendered":"Comment g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\" id=\"h-tutoriels-pour-gerer-les-procedures-stockees-sql-server-c-est-a-dire-creer-modifier-executer-ou-supprimer-une-procedure-en-t-sql\"><em><strong>Tutoriels pour g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server, c&rsquo;est \u00e0 dire cr\u00e9er, modifier, ex\u00e9cuter ou supprimer une proc\u00e9dure en T-SQL<\/strong>.<\/em><\/h4>\n\n\n\n<p>Apprendre \u00e0 g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server est une comp\u00e9tence essentielle pour les d\u00e9veloppeurs Microsoft. D\u00e9couvrez comment cr\u00e9er, mettre \u00e0 jour, et supprimer ces proc\u00e9dures via des scripts SQL. Ces scripts permettent d&rsquo;automatiser et de g\u00e9rer les proc\u00e9dures en utilisant le langage T-SQL.<\/p>\n\n\n\n<p><strong>Une proc\u00e9dure stock\u00e9e est un ensemble d&rsquo;instructions Transact-SQL<\/strong> ex\u00e9cut\u00e9es comme une unit\u00e9. Elles peuvent \u00eatre param\u00e9tr\u00e9es et s&rsquo;ex\u00e9cutent dans le cadre de la connexion actuelle \u00e0 la base de donn\u00e9es.<\/p>\n\n\n\n<p>A travers ces tutoriels, nous allons voir comment cr\u00e9er diff\u00e9rentes proc\u00e9dures stock\u00e9es avec des <a href=\"https:\/\/dictionnaire.lerobert.com\/definition\/script\" target=\"_blank\" rel=\"noreferrer noopener\">scripts<\/a>. Pour cela, depuis <a href=\"https:\/\/expert-only.com\/fr\/ssms\/telecharger-ssms-18\/\"><strong>SQL Server Management Studio<\/strong><\/a> (SSMS), ouvrir la fen\u00eatre Nouvelle requ\u00eate depuis l&rsquo;interface graphique ou depuis <em>le raccourci Ctrl+N<\/em>.<\/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\/gerer-les-procedures-stockees-sql-server\/#1-creer-une-procedure-stockee-avec-sql-server\" >1. Cr\u00e9er une proc\u00e9dure stock\u00e9e avec 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\/gerer-les-procedures-stockees-sql-server\/#2-procedure-sql-server-pour-retourner-des-variables\" >2. Proc\u00e9dure SQL Server pour retourner des variables<\/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\/gerer-les-procedures-stockees-sql-server\/#3-executer-une-procedure-stockee\" >3. Ex\u00e9cuter 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\/gerer-les-procedures-stockees-sql-server\/#4-modifier-une-procedure\" >4. Modifier une proc\u00e9dure<\/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\/gerer-les-procedures-stockees-sql-server\/#5-supprimer-une-procedure-sql-server\" >5. Supprimer une proc\u00e9dure SQL Server<\/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\/gerer-les-procedures-stockees-sql-server\/#6-inserer-des-donnees-depuis-une-procedure-stockee\" >6. Ins\u00e9rer des donn\u00e9es depuis 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-7\" href=\"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#7-exemple-de-procedure-sql-avec-du-code-dynamique\" >7. Exemple de proc\u00e9dure SQL avec du code dynamique<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-creer-une-procedure-stockee-avec-sql-server\"><span class=\"ez-toc-section\" id=\"1-creer-une-procedure-stockee-avec-sql-server\"><\/span>1. Cr\u00e9er une proc\u00e9dure stock\u00e9e avec SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dans cet article, nous allons voir <strong><a href=\"https:\/\/expert-only.com\/t-sql\/procedure-stockee-sql-server\/\">comment cr\u00e9er une proc\u00e9dure stock\u00e9e r\u00e9utilisable dans SQL Server<\/a><\/strong>. <\/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=\"63q9WL2erD\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/\">Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres<\/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\u00a0Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server avec param\u00e8tres\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-stockee-sql-server-parametres\/embed\/#?secret=3z2UNPMEX5#?secret=63q9WL2erD\" data-secret=\"63q9WL2erD\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-procedure-sql-server-pour-retourner-des-variables\"><\/span>2. Proc\u00e9dure SQL Server pour retourner des variables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Cette <strong><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/retourner-des-variables-procedure-sql-server\/\">proc\u00e9dure MS SQL permet de retourner des valeurs stock\u00e9es dans des variables T-SQL<\/a><\/strong> avec l&rsquo;option <strong><em>OUTPUT<\/em><\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-executer-une-procedure-stockee\"><span class=\"ez-toc-section\" id=\"3-executer-une-procedure-stockee\"><\/span>3. Ex\u00e9cuter une proc\u00e9dure stock\u00e9e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dans cet section, voici un tutoriel avec des examples de code pour<a href=\"https:\/\/expert-only.com\/fr\/t-sql\/executer-une-procedure-sql-avec-parametres\/\"><strong> ex\u00e9cuter une proc\u00e9dure SQL Server avec des param\u00e8tres<\/strong><\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-modifier-une-procedure\"><span class=\"ez-toc-section\" id=\"4-modifier-une-procedure\"><\/span>4. Modifier une proc\u00e9dure<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici maintenant <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-procedure-stockee-sql-server\/\"><strong>comment modifier une proc\u00e9dure stock\u00e9e<\/strong><\/a> avec une commande T-SQL de type ALTER PROCEDURE.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-5-supprimer-une-procedure-sql-server\"><span class=\"ez-toc-section\" id=\"5-supprimer-une-procedure-sql-server\"><\/span>5. Supprimer une proc\u00e9dure SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dans cette section, voici comment <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/supprimer-une-procedure-stockee-sql-server\/\"><strong>supprimer une proc\u00e9dure d\u00e9finitivement et sans erreur<\/strong><\/a> avec une requ\u00eate DROP PROCEDURE.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"840\" height=\"460\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-drop-stored-procedure-script.jpg\" alt=\"G\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server avec du code dynamique pour les supprimer\" class=\"wp-image-18421\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-drop-stored-procedure-script.jpg 840w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-drop-stored-procedure-script-300x164.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/11\/sql-server-drop-stored-procedure-script-768x421.jpg 768w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption class=\"wp-element-caption\"><em>G\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server avec du code dynamique pour les supprimer<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-6-inserer-des-donnees-depuis-une-procedure-stockee\"><span class=\"ez-toc-section\" id=\"6-inserer-des-donnees-depuis-une-procedure-stockee\"><\/span>6. Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici un autre article sur les proc\u00e9dures stock\u00e9es, qui aborde un des concepts du CRUD (Create, Read, Update, Delete),  tutoriel pour <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/\"><strong>ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server<\/strong><\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-7-exemple-de-procedure-sql-avec-du-code-dynamique\"><span class=\"ez-toc-section\" id=\"7-exemple-de-procedure-sql-avec-du-code-dynamique\"><\/span>7. Exemple de proc\u00e9dure SQL avec du code dynamique<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La proc\u00e9dure ci-dessous utilise des requ\u00eates SQL dynamiques pour ins\u00e9rer automatiquement des enregistrements dans une table. Ici, l&rsquo;utilisation de la proc\u00e9dure stock\u00e9e <em>sp_executesql<\/em> permet d&rsquo;ex\u00e9cuter une requ\u00eate SQL tout en passant des param\u00e8tres. Cette proc\u00e9dure est int\u00e9ressante permet de g\u00e9n\u00e9rer et ins\u00e9rer rapidement des donn\u00e9es de test dans une table, en utilisant des requ\u00eates dynamiques tout en <strong>\u00e9vitant les risques d&rsquo;injection SQL<\/strong> gr\u00e2ce \u00e0 l&rsquo;utilisation de param\u00e8tres.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/procedure-t-sql-avec-une-variable-en-dur\/\"><strong>Exemple de proc\u00e9dure T-SQL avec une variable en dur pour g\u00e9n\u00e9rer du code dynamique<\/strong><\/a>.<\/li>\n<\/ul>\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=\"eEVJzoxIyU\"><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=920M8KsrdV#?secret=eEVJzoxIyU\" data-secret=\"eEVJzoxIyU\" 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\" id=\"h-conclusion-sur-la-gestion-des-procedures-stockees-avec-sql-server\">Conclusion sur la gestion des proc\u00e9dures stock\u00e9es avec SQL Server<\/h3>\n\n\n\n<p>G\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server est crucial pour les d\u00e9veloppeurs et les administrateurs de base de donn\u00e9es. Ces proc\u00e9dures optimisent et s\u00e9curisent les processus de base de donn\u00e9es.<\/p>\n\n\n\n<p>Dans cet article, nous explorons la cr\u00e9ation, modification, et suppression de ces proc\u00e9dures en T-SQL. Les tutoriels montrent comment cr\u00e9er des proc\u00e9dures dynamiques avec des param\u00e8tres, les ex\u00e9cuter, les modifier via ALTER PROCEDURE et les supprimer avec DROP PROCEDURE.<\/p>\n\n\n\n<p>Les scripts SQL, comme soulign\u00e9, sont d&rsquo;une importance capitale pour automatiser les t\u00e2ches et pour une meilleure r\u00e9utilisabilit\u00e9. Ils offrent \u00e9galement l&rsquo;avantage de documenter et de standardiser les proc\u00e9dures au sein d&rsquo;une organisation.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Tutoriels pour g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server, c&rsquo;est \u00e0 dire cr\u00e9er, modifier, ex\u00e9cuter ou supprimer une proc\u00e9dure en T-SQL. Apprendre \u00e0 g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server est une comp\u00e9tence essentielle pour les d\u00e9veloppeurs Microsoft. D\u00e9couvrez comment cr\u00e9er, <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/\" title=\"Comment g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10867,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-9614","page","type-page","status-publish","has-post-thumbnail"],"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 g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server? T-SQL<\/title>\n<meta name=\"description\" content=\"G\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server avec des exemples pour cr\u00e9er, modifier, ex\u00e9cuter et supprimer les objets avec du 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\/gerer-les-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=\"Comment g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server?\" \/>\n<meta property=\"og:description\" content=\"G\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server avec des exemples pour cr\u00e9er, modifier, ex\u00e9cuter et supprimer les objets avec du code T-SQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/gerer-les-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:modified_time\" content=\"2023-10-30T17:05:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_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=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/\",\"name\":\"Comment g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg\",\"datePublished\":\"2023-08-21T03:02:00+00:00\",\"dateModified\":\"2023-10-30T17:05:21+00:00\",\"description\":\"G\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server avec des exemples pour cr\u00e9er, modifier, ex\u00e9cuter et supprimer les objets avec du code T-SQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment g\u00e9rer les 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\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Comment g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server? T-SQL","description":"G\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server avec des exemples pour cr\u00e9er, modifier, ex\u00e9cuter et supprimer les objets avec du 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\/gerer-les-procedures-stockees-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server?","og_description":"G\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server avec des exemples pour cr\u00e9er, modifier, ex\u00e9cuter et supprimer les objets avec du code T-SQL.","og_url":"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_modified_time":"2023-10-30T17:05:21+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@expert_only","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/","url":"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/","name":"Comment g\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg","datePublished":"2023-08-21T03:02:00+00:00","dateModified":"2023-10-30T17:05:21+00:00","description":"G\u00e9rer les proc\u00e9dures stock\u00e9es SQL Server avec des exemples pour cr\u00e9er, modifier, ex\u00e9cuter et supprimer les objets avec du code T-SQL.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/texture-design-9D617D2FB8C_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/gerer-les-procedures-stockees-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Comment g\u00e9rer les 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"]}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/pages\/9614","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/page"}],"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=9614"}],"version-history":[{"count":24,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/pages\/9614\/revisions"}],"predecessor-version":[{"id":27817,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/pages\/9614\/revisions\/27817"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10867"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=9614"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}