{"id":952,"date":"2023-11-17T06:36:00","date_gmt":"2023-11-17T05:36:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=952"},"modified":"2023-11-22T18:39:19","modified_gmt":"2023-11-22T17:39:19","slug":"creer-une-procedure-stockee-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/","title":{"rendered":"Comment cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server ?"},"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 script T-SQL ?<\/em><\/h4>\n\n\n\n<p>Une proc\u00e9dure SQL n&rsquo;est rien de plus que du code T-SQL stock\u00e9 de mani\u00e8re \u00e0 \u00eatre r\u00e9utilis\u00e9 facilement. Dans ce court tutoriel SQL Server en Fran\u00e7ais voici comment cr\u00e9er une proc\u00e9dure stock\u00e9e simple en langage Transact-SQL ? Avant de cr\u00e9er une proc\u00e9dure stock\u00e9e, il faut savoir quel sera le r\u00e9sultat final.<\/p>\n\n\n\n<p>Autrement dit, la finalit\u00e9 est-elle d&rsquo;afficher des donn\u00e9es, d&rsquo;<a href=\"https:\/\/expert-only.com\/t-sql\/requete-sql-server-insert-into-depuis-select\/\">ins\u00e9rer des donn\u00e9es<\/a> par exemple. Ou encore mettre \u00e0 jour des donn\u00e9es existantes ? Il est aussi possible de supprimer des donn\u00e9es. C&rsquo;est \u00e0 dire toutes les commandes de type <a href=\"https:\/\/www.techopedia.com\/definition\/1179\/data-manipulation-language-dml\" target=\"_blank\" rel=\"noreferrer noopener\">Data Manipulation Language<\/a> (DML). Et bien s\u00fbr de combiner plusieurs op\u00e9rations. Comme appeler une ou plusieurs autres proc\u00e9dures.<\/p>\n\n\n\n<p>D&rsquo;autre part, toutes les commande de manipulation d&rsquo;objets SQL sont aussi possibles. C&rsquo;est \u00e0 dire toutes les commandes dites Data Definition Language en Anglais (DDL). Le but de cet exemple est de s\u00e9lectionner toutes les donn\u00e9es de la table des clients stock\u00e9es dans la base de donn\u00e9es.<\/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\/creer-une-procedure-stockee-sql-server\/#1-selectionner-des-donnees-depuis-une-procedure-sql\" >1. S\u00e9lectionner des donn\u00e9es depuis 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-2\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#2-creer-une-procedure-stockee-sql-server-basique\" >2. Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server basique<\/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\/creer-une-procedure-stockee-sql-server\/#3-executer-une-procedure-stockee-en-t-sql\" >3. Ex\u00e9cuter une proc\u00e9dure stock\u00e9e en T-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\/creer-une-procedure-stockee-sql-server\/#4-remarques-sur-les-procedures-ms-sql\" >4. Remarques sur les proc\u00e9dures MS SQL<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-selectionner-des-donnees-depuis-une-procedure-sql\"><\/span>1. S\u00e9lectionner des donn\u00e9es depuis une proc\u00e9dure SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La table se trouve dans le sch\u00e9ma par d\u00e9faut dbo, pour Database Owner. Ainsi, le code T-SQL suivant renvoie toutes les lignes de cette table.<\/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=\"\">SELECT \t*\nFROM \tdbo.CLIENTS;\n<\/pre>\n\n\n\n<p>Le code de cr\u00e9ation de la table des clients est disponible dans cet article sur <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-sql-server\/\">la cr\u00e9ation et la gestion des tables SQL Server<\/a>.<\/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 des clients\nCREATE TABLE [dbo].[CLIENTS] (\n   [CLIENTID] int IDENTITY(1,1),\n   [NAME] nvarchar(20) UNIQUE,\n   [CITY] nvarchar(20)\n)\nGO\n\n-- Ins\u00e9rer des donn\u00e9es\nINSERT INTO dbo.CLIENTS (NAME, CITY) VALUES ('MAMMADOU', 'Lyon');\nINSERT INTO dbo.CLIENTS (NAME, CITY) VALUES ('SERGEI', 'Lyon');\nINSERT INTO dbo.CLIENTS (NAME, CITY) VALUES ('CHRISTOPHE', 'Paris');\n\n-- V\u00e9rifier les lignes ins\u00e9r\u00e9es\nSELECT *\nFROM   dbo.CLIENTS;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-creer-une-procedure-stockee-sql-server-basique\"><\/span>2. Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server basique<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Le code de cr\u00e9ation de la table des CLIENTS est disponible dans ce <a href=\"https:\/\/expert-only.com\/t-sql\/creer-table-sql-server\/\" target=\"_blank\" rel=\"noreferrer noopener\">tutoriel pour cr\u00e9er une table SQL Server<\/a>. Pour cr\u00e9er une proc\u00e9dure stock\u00e9e simple, utiliser par exemple ce code. Pour cr\u00e9er la proc\u00e9dure stock\u00e9e, utiliser la commande CREATE PROCEDURE ou CREATE PROC. Apr\u00e8s le nom de la proc\u00e9dure stock\u00e9e, utiliser le mot cl\u00e9 <strong><em>AS<\/em><\/strong>. Le reste est tout simplement du <a href=\"https:\/\/expert-only.com\/t-sql\/\">code T-SQL<\/a> standard \u00e0&nbsp;ex\u00e9cuter.<\/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\tSELECT \t*\n\tFROM \tdbo.CLIENTS\nGO\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-executer-une-procedure-stockee-en-t-sql\"><\/span>3. Ex\u00e9cuter une proc\u00e9dure stock\u00e9e en T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour ex\u00e9cuter la <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/relational-databases\/stored-procedures\/execute-a-stored-procedure?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">proc\u00e9dure<\/a> stock\u00e9e et afficher le contenu de la table Clients sp\u00e9cifi\u00e9e dans la requ\u00eate, il suffit d\u2019ex\u00e9cuter le code suivant. Il existe plusieurs fa\u00e7ons d&rsquo;ex\u00e9cuter une proc\u00e9dure stock\u00e9e depuis SSMS:<\/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=\"\">EXECUTE dbo.uspListeClients;\nGO\n\n-- Ou encore \nEXEC dbo.uspListeClients;\nGO\n\n-- Ou simplement \nuspListeClients;\nGO\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"579\" height=\"592\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png\" alt=\"Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server pour s\u00e9lectionner une table\" class=\"wp-image-3674\" style=\"width:579px;height:auto\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png 579w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple-293x300.png 293w\" sizes=\"auto, (max-width: 579px) 100vw, 579px\" \/><figcaption class=\"wp-element-caption\"><em>Cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server pour s\u00e9lectionner une table<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-remarques-sur-les-procedures-ms-sql\"><\/span>4. Remarques sur les proc\u00e9dures MS SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Premi\u00e8rement, ne pas utiliser le mot-cl\u00e9 <em><strong>GO<\/strong><\/em> \u00e0 l&rsquo;int\u00e9rieur de la proc\u00e9dure stock\u00e9e. En effet, une fois que le compilateur SQL Server rencontre \u00ab\u00a0GO\u00a0\u00bb il suppose que c&rsquo;est la fin de la proc\u00e9dure stock\u00e9e.<\/li>\n\n\n\n<li>Enfin, ne pas changer de base de donn\u00e9es \u00e0 l\u2019int\u00e9rieur de la proc\u00e9dure stock\u00e9e. Soit l&rsquo;utilisation de la commande <strong><em>USE UneAutreBase<\/em><\/strong> par exemple ne fonctionne pas.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-les-procedures-stockees-sont-largement-utilisees-en-t-sql\">Les proc\u00e9dures stock\u00e9es sont largement utilis\u00e9es en T-SQL<\/h3>\n\n\n\n<p>Dans ce tutoriel, nous avons appris \u00e0 cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server de base \u00e0 l&rsquo;aide de l&rsquo;instruction CREATE, qui permet de stocker du code T-SQL afin de pouvoir le r\u00e9utiliser facilement. Nous avons abord\u00e9 le processus de d\u00e9finition du r\u00e9sultat final, l&rsquo;incorporation des commandes DML (Data Manipulation Language) et l&rsquo;ex\u00e9cution de la proc\u00e9dure stock\u00e9e \u00e0 l&rsquo;aide du code d&rsquo;exemple.<\/p>\n\n\n\n<p>Nous avons \u00e9galement soulign\u00e9 quelques aspects essentiels \u00e0 prendre en compte, tels que la non-utilisation du mot-cl\u00e9 GO \u00e0 l&rsquo;int\u00e9rieur de la proc\u00e9dure stock\u00e9e et le fait d&rsquo;\u00e9viter les modifications de la base de donn\u00e9es dans le code de la proc\u00e9dure.<\/p>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1658048568473\"><strong class=\"schema-faq-question\">Qu&rsquo;est-ce qu&rsquo;une proc\u00e9dure stock\u00e9e SQL Server ?<\/strong> <p class=\"schema-faq-answer\">Une proc\u00e9dure stock\u00e9e SQL Server est un script \u00e9crit en langage Transact-SQL (T-SQL) et ex\u00e9cut\u00e9 dans une base de donn\u00e9es. Une proc\u00e9dure regroupe une ou plusieurs instructions SQL. Elle peut g\u00e9rer des param\u00e8tres d&rsquo;entr\u00e9e et des param\u00e8tres de sortie. Les \u00e9tapes sont r\u00e9p\u00e9t\u00e9es chaque fois qu&rsquo;une proc\u00e9dure stock\u00e9e est appel\u00e9e.<\/p> <\/div> <\/div>\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=\"ETANDpxuVb\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/gerer-les-fonctions-sql-server\/\">G\u00e9rer les fonctions SQL Server avec des scripts<\/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\u00a0G\u00e9rer les fonctions SQL Server avec des scripts\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/gerer-les-fonctions-sql-server\/embed\/#?secret=ACgykboGkW#?secret=ETANDpxuVb\" data-secret=\"ETANDpxuVb\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\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 script T-SQL ? Une proc\u00e9dure SQL n&rsquo;est rien de plus que du code T-SQL stock\u00e9 de mani\u00e8re \u00e0 \u00eatre r\u00e9utilis\u00e9 facilement. Dans ce court tutoriel SQL Server en <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/\" title=\"Comment cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-952","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"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>Comment cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server ? T-SQL<\/title>\n<meta name=\"description\" content=\"Pour cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server et l&#039;ex\u00e9cuter, utiliser du code T-SQL et adapter les colonnes et la s\u00e9lection.\" \/>\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\/creer-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 cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server ?\" \/>\n<meta property=\"og:description\" content=\"Pour cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server et l&#039;ex\u00e9cuter, utiliser du code T-SQL et adapter les colonnes et la s\u00e9lection.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-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-11-17T05:36:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-22T17:39:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png\" \/>\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\/creer-une-procedure-stockee-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Comment cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server ?\",\"datePublished\":\"2023-11-17T05:36:00+00:00\",\"dateModified\":\"2023-11-22T17:39:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/\"},\"wordCount\":718,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#respond\"]}]},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/\",\"name\":\"Comment cr\u00e9er 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\/creer-une-procedure-stockee-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png\",\"datePublished\":\"2023-11-17T05:36:00+00:00\",\"dateModified\":\"2023-11-22T17:39:19+00:00\",\"description\":\"Pour cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server et l'ex\u00e9cuter, utiliser du code T-SQL et adapter les colonnes et la s\u00e9lection.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#faq-question-1658048568473\"}],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-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 cr\u00e9er 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\"}},{\"@type\":\"Question\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#faq-question-1658048568473\",\"position\":1,\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#faq-question-1658048568473\",\"name\":\"Qu'est-ce qu'une proc\u00e9dure stock\u00e9e SQL Server ?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Une proc\u00e9dure stock\u00e9e SQL Server est un script \u00e9crit en langage Transact-SQL (T-SQL) et ex\u00e9cut\u00e9 dans une base de donn\u00e9es. Une proc\u00e9dure regroupe une ou plusieurs instructions SQL. Elle peut g\u00e9rer des param\u00e8tres d'entr\u00e9e et des param\u00e8tres de sortie. Les \u00e9tapes sont r\u00e9p\u00e9t\u00e9es chaque fois qu'une proc\u00e9dure stock\u00e9e est appel\u00e9e.\",\"inLanguage\":\"fr-FR\"},\"inLanguage\":\"fr-FR\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Comment cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server ? T-SQL","description":"Pour cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server et l'ex\u00e9cuter, utiliser du code T-SQL et adapter les colonnes et la s\u00e9lection.","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\/creer-une-procedure-stockee-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server ?","og_description":"Pour cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server et l'ex\u00e9cuter, utiliser du code T-SQL et adapter les colonnes et la s\u00e9lection.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-11-17T05:36:00+00:00","article_modified_time":"2023-11-22T17:39:19+00:00","og_image":[{"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png","type":"","width":"","height":""}],"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\/creer-une-procedure-stockee-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Comment cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server ?","datePublished":"2023-11-17T05:36:00+00:00","dateModified":"2023-11-22T17:39:19+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/"},"wordCount":718,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#respond"]}]},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/","name":"Comment cr\u00e9er 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\/creer-une-procedure-stockee-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png","datePublished":"2023-11-17T05:36:00+00:00","dateModified":"2023-11-22T17:39:19+00:00","description":"Pour cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server et l'ex\u00e9cuter, utiliser du code T-SQL et adapter les colonnes et la s\u00e9lection.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#faq-question-1658048568473"}],"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/creer_executer_procedure_stockee_simple.png"},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-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 cr\u00e9er 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"}},{"@type":"Question","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#faq-question-1658048568473","position":1,"url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-une-procedure-stockee-sql-server\/#faq-question-1658048568473","name":"Qu'est-ce qu'une proc\u00e9dure stock\u00e9e SQL Server ?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Une proc\u00e9dure stock\u00e9e SQL Server est un script \u00e9crit en langage Transact-SQL (T-SQL) et ex\u00e9cut\u00e9 dans une base de donn\u00e9es. Une proc\u00e9dure regroupe une ou plusieurs instructions SQL. Elle peut g\u00e9rer des param\u00e8tres d'entr\u00e9e et des param\u00e8tres de sortie. Les \u00e9tapes sont r\u00e9p\u00e9t\u00e9es chaque fois qu'une proc\u00e9dure stock\u00e9e est appel\u00e9e.","inLanguage":"fr-FR"},"inLanguage":"fr-FR"}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/952","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=952"}],"version-history":[{"count":3,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/952\/revisions"}],"predecessor-version":[{"id":29316,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/952\/revisions\/29316"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}