{"id":1126,"date":"2023-08-03T06:38:00","date_gmt":"2023-08-03T04:38:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1126"},"modified":"2023-10-21T20:24:44","modified_gmt":"2023-10-21T18:24:44","slug":"inserer-donnees-depuis-procedure-stockee","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/","title":{"rendered":"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><strong><em>Exemple complet de scripts pour ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server<\/em><\/strong>.<\/h4>\n\n\n\n<p>Exemple de proc\u00e9dure stock\u00e9e pour ins\u00e9rer des donn\u00e9es dans une table SQL Server. Et aussi comment  afficher ou masquer le nombre de lignes ins\u00e9r\u00e9es par la proc\u00e9dure. Cet exemple de proc\u00e9dure T-SQL ins\u00e8re des lignes dans une table de clients.<\/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\/inserer-donnees-depuis-procedure-stockee\/#1-inserer-des-lignes-depuis-une-procedure-stockee-sql-server\" >1. Ins\u00e9rer des lignes depuis une proc\u00e9dure stock\u00e9e SQL Server<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#11-creer-la-table-des-ventes\" >1.1 Cr\u00e9er la table des ventes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#12-exemple-de-procedure-stockee-sql-pour-inserer-des-donnees\" >1.2 Exemple de proc\u00e9dure stock\u00e9e SQL pour ins\u00e9rer des donn\u00e9es<\/a><\/li><\/ul><\/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\/inserer-donnees-depuis-procedure-stockee\/#2-masquer-laffichage-du-nombre-de-lignes-inserees\" >2. Masquer l&rsquo;affichage du nombre de lignes ins\u00e9r\u00e9es<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-inserer-des-lignes-depuis-une-procedure-stockee-sql-server\"><span class=\"ez-toc-section\" id=\"1-inserer-des-lignes-depuis-une-procedure-stockee-sql-server\"><\/span>1. Ins\u00e9rer des lignes depuis une proc\u00e9dure stock\u00e9e SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici un tutoriel en 3 \u00e9tapes pour apprendre \u00e9 ins\u00e9rer des lignes depuis une proc\u00e9dure stock\u00e9e avec des variables.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"11-creer-la-table-des-ventes\"><\/span>1.1 Cr\u00e9er la table des ventes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Tout d&rsquo;abord, v\u00e9rifier au pr\u00e9alable que la table d&rsquo;exemple n&rsquo;existe pas. Si la table existe, alors la supprimer avec la commande DROP TABLE. Ensuite cr\u00e9er la table des clients pour ins\u00e9rer les lignes de l&rsquo;exemple.<\/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=\"\">IF EXISTS ( \n\tSELECT 1 FROM sys.objects \n\tWHERE  object_id = object_id(N'[dbo].[CLIENTS]') \n\t\t  AND type in (N'U') \n)\nDROP TABLE [dbo].[CLIENTS];\n\nCREATE TABLE [dbo].[CLIENTS] (\n  [NOCLIENT] int IDENTITY(1,1),\n  [NOM]\tnvarchar(20),\n  [VILLE] nvarchar(20)\n);\n\nGO\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"12-exemple-de-procedure-stockee-sql-pour-inserer-des-donnees\"><\/span>1.2 Exemple de proc\u00e9dure stock\u00e9e SQL pour ins\u00e9rer des donn\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Commencer par v\u00e9rifier si la <a href=\"https:\/\/www.lalanguefrancaise.com\/dictionnaire\/definition\/procedure-stockee\" target=\"_blank\" rel=\"noreferrer noopener\">proc\u00e9dure stock\u00e9e<\/a> existe d\u00e9j\u00e0 dans la base et la supprimer si n\u00e9cessaire. Dans un deuxi\u00e8me temps cr\u00e9er la proc\u00e9dure stock\u00e9e <em><strong>uspInsertClient<\/strong><\/em> pour ins\u00e9rer dans la table des clients deux champs pass\u00e9s en param\u00e8tres, le nom et la ville.<\/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=\"\">IF EXISTS(\tSELECT 1 FROM sys.objects \n      WHERE object_id = object_id(N'uspInsertClient') AND type in (N'P') )\nDROP PROCEDURE uspInsertClient;\nGO\n\nCREATE PROCEDURE uspInsertClient\n  @Nom\tnvarchar(20),\n  @Ville\tnvarchar(20)\nAS\nBEGIN\n  INSERT INTO dbo.CLIENTS (NOM, VILLE) \n  VALUES (@Nom, @Ville);\nEND\n\nGO<\/pre>\n\n\n\n<p>Ex\u00e9cuter la proc\u00e9dure trois fois pour ins\u00e9rer des nouveaux clients dans la table.<\/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=\"\">-- Ins\u00e9rer trois nouveaux clients\nSET NOCOUNT OFF;\nEXECUTE uspInsertClient\t@Nom = 'MAMMADOU', @Ville = 'Toulouse';\nEXECUTE uspInsertClient\t@Nom = 'KARIM',\t@Ville = 'Nantes';\nEXECUTE uspInsertClient\t@Nom = 'ISAAC',\t@Ville = 'Versailles';\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"746\" height=\"463\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL-Server-procedure-stockee-insert.png\" alt=\"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server\" class=\"wp-image-1127\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL-Server-procedure-stockee-insert.png 746w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL-Server-procedure-stockee-insert-300x186.png 300w\" sizes=\"auto, (max-width: 746px) 100vw, 746px\" \/><figcaption class=\"wp-element-caption\"><em>Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Cet exemple de requ\u00eate insert dans la proc\u00e9dure stock\u00e9e SQL Server permet d&rsquo;ins\u00e9rer des lignes dans une table. Le code v\u00e9rifie au pr\u00e9alable l&rsquo;existence de la proc\u00e9dure pour \u00e9viter les erreurs \u00e0 la cr\u00e9ation. Le code permet d&rsquo;appeler facilement la proc\u00e9dure cr\u00e9\u00e9e avec les param\u00e8tres. Et donc de standardiser l&rsquo;insertion des donn\u00e9es dans cette table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-masquer-laffichage-du-nombre-de-lignes-inserees\"><\/span>2. Masquer l&rsquo;affichage du nombre de lignes ins\u00e9r\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A chaque insertion de donn\u00e9es avec du code T-SQL, par d\u00e9faut, le syst\u00e8me affiche le nombre de lignes ins\u00e9r\u00e9es. La commande <em>SET NOCOUNT ON<\/em> indique \u00e0 SQL Server de ne pas afficher le nombre de lignes affect\u00e9es. Dans notre cas, ins\u00e9r\u00e9es par la requ\u00eate SQL INSERT. Ainsi, si l&rsquo;option est activ\u00e9e, le nombre de ligne n&rsquo;est pas remont\u00e9, comme dans l&rsquo;exemple ci-dessous.<\/p>\n\n\n\n<p>Cette option d&rsquo;affichage permet de ne pas polluer les fichiers ou les tables de logs pendant l&rsquo;ex\u00e9cution de proc\u00e9dures stock\u00e9es complexes.<\/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=\"\">-- Ins\u00e9rer trois clients avec l'option activ\u00e9e\nSET NOCOUNT ON;\nEXECUTE uspInsertClient\t@Nom = 'MAMMADOU',\t@Ville = 'Toulouse';\nEXECUTE uspInsertClient\t@Nom = 'KARIM',\t\t@Ville = 'Nantes';\nEXECUTE uspInsertClient\t@Nom = 'ISAAC',\t\t@Ville = 'Versailles';<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"220\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL-Server-procedure-stockee-insert-nocount-on.png\" alt=\"Ex\u00e9cuter la proc\u00e9dure avec un INSERT INTO avec du code T-SQL \" class=\"wp-image-1129\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL-Server-procedure-stockee-insert-nocount-on.png 700w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL-Server-procedure-stockee-insert-nocount-on-300x94.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><figcaption class=\"wp-element-caption\"><em>Ex\u00e9cuter la proc\u00e9dure avec un INSERT INTO avec du code T-SQL <\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Enfin, contr\u00f4ler le r\u00e9sultat de la requ\u00eate et lire les donn\u00e9es avec <strong><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/requetes-select-sql-server\/\">une requ\u00eate SELECT<\/a> <\/strong>sur la table des clients. Noter que les trois clients sont pr\u00e9sents deux fois chacun dans la table. Ce qui correspond aux six ex\u00e9cutions de la commande SQL. Soit trois fois avec l&rsquo;option d&rsquo;affichage du nombre de ligne activ\u00e9e et trois fois avec l&rsquo;option d&rsquo;affichage d\u00e9sactiv\u00e9e.<\/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=\"\">SELECT * FROM dbo.CLIENTS;\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"616\" height=\"252\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL-Server-procedure-stockee-insert-select.png\" alt=\"\" class=\"wp-image-1128\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL-Server-procedure-stockee-insert-select.png 616w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL-Server-procedure-stockee-insert-select-300x123.png 300w\" sizes=\"auto, (max-width: 616px) 100vw, 616px\" \/><\/figure><\/div>\n\n\n<p>Ce tutoriel sur le d\u00e9veloppement T-SQL explique comment ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server. Voici enfin un tutoriel pour <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/retourner-des-variables-procedure-sql-server\/\">cr\u00e9er une proc\u00e9dure stock\u00e9e SQL qui retourne des valeurs<\/a> avec l&rsquo;option OUTPUT.<\/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=\"3dyvJEW9rT\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/retourner-des-variables-procedure-sql-server\/\">Retourner des variables avec une proc\u00e9dure stock\u00e9e SQL Server et OUTPUT<\/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\u00a0Retourner des variables avec une proc\u00e9dure stock\u00e9e SQL Server et OUTPUT\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/retourner-des-variables-procedure-sql-server\/embed\/#?secret=LO6gwSxlNH#?secret=3dyvJEW9rT\" data-secret=\"3dyvJEW9rT\" 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>Exemple complet de scripts pour ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server. Exemple de proc\u00e9dure stock\u00e9e pour ins\u00e9rer des donn\u00e9es dans une table SQL Server. Et aussi comment afficher ou masquer le nombre de lignes ins\u00e9r\u00e9es par <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/\" title=\"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10712,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-1126","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>Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server<\/title>\n<meta name=\"description\" content=\"Exemple de code pour ins\u00e9rer des donn\u00e9es dans une table depuis une proc\u00e9dure stock\u00e9e SQL Server avec une commande Insert Into.\" \/>\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\/inserer-donnees-depuis-procedure-stockee\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server\" \/>\n<meta property=\"og:description\" content=\"Exemple de code pour ins\u00e9rer des donn\u00e9es dans une table depuis une proc\u00e9dure stock\u00e9e SQL Server avec une commande Insert Into.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/\" \/>\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-03T04:38:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-21T18:24:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_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\/inserer-donnees-depuis-procedure-stockee\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server\",\"datePublished\":\"2023-08-03T04:38:00+00:00\",\"dateModified\":\"2023-10-21T18:24:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/\"},\"wordCount\":575,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/\",\"name\":\"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg\",\"datePublished\":\"2023-08-03T04:38:00+00:00\",\"dateModified\":\"2023-10-21T18:24:44+00:00\",\"description\":\"Exemple de code pour ins\u00e9rer des donn\u00e9es dans une table depuis une proc\u00e9dure stock\u00e9e SQL Server avec une commande Insert Into.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server","description":"Exemple de code pour ins\u00e9rer des donn\u00e9es dans une table depuis une proc\u00e9dure stock\u00e9e SQL Server avec une commande Insert Into.","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\/inserer-donnees-depuis-procedure-stockee\/","og_locale":"fr_FR","og_type":"article","og_title":"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server","og_description":"Exemple de code pour ins\u00e9rer des donn\u00e9es dans une table depuis une proc\u00e9dure stock\u00e9e SQL Server avec une commande Insert Into.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-08-03T04:38:00+00:00","article_modified_time":"2023-10-21T18:24:44+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_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\/inserer-donnees-depuis-procedure-stockee\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server","datePublished":"2023-08-03T04:38:00+00:00","dateModified":"2023-10-21T18:24:44+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/"},"wordCount":575,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/","name":"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg","datePublished":"2023-08-03T04:38:00+00:00","dateModified":"2023-10-21T18:24:44+00:00","description":"Exemple de code pour ins\u00e9rer des donn\u00e9es dans une table depuis une proc\u00e9dure stock\u00e9e SQL Server avec une commande Insert Into.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/keyboard-6578692B4E6_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/inserer-donnees-depuis-procedure-stockee\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Ins\u00e9rer des donn\u00e9es depuis une proc\u00e9dure stock\u00e9e SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1126","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=1126"}],"version-history":[{"count":5,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1126\/revisions"}],"predecessor-version":[{"id":27619,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1126\/revisions\/27619"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10712"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}