{"id":1232,"date":"2022-06-08T07:12:00","date_gmt":"2022-06-08T05:12:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1232"},"modified":"2022-11-30T11:45:26","modified_gmt":"2022-11-30T10:45:26","slug":"sql-server-insert-into-avec-des-variables","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/","title":{"rendered":"SQL Server INSERT INTO avec des variables"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Une requ\u00eate SQL Server Insert Into avec des variables permet d&rsquo;ins\u00e9rer des donn\u00e9es de mani\u00e8re dynamique.<\/em><\/strong><\/h4>\n\n\n\n<p>Comment construire une requ\u00eate SQL Server INSERT INTO avec des variables pour rendre le code dynamique ? Ce tutoriel est similaire au premier de la s\u00e9rie pour <a href=\"https:\/\/expert-only.com\/t-sql\/requete-sql-server-insert-into-depuis-select\/\">ins\u00e9rer des donn\u00e9es avec SQL Server depuis une requ\u00eate de s\u00e9lection<\/a>. Pour ce faire, modifier l\u00e9g\u00e8rement le code pour cr\u00e9er la table et utiliser des variables dans la requ\u00eate au lieu de coder en dur les valeurs \u00e0 ins\u00e9rer.<\/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\/sql-server-insert-into-avec-des-variables\/#1-requete-sql-insert-into-avec-des-variables-t-sql\" >1. Requ\u00eate SQL INSERT INTO avec des variables T-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\/sql-server-insert-into-avec-des-variables\/#2-creer-la-table-sql-pour-inserer-les-donnees\" >2. Cr\u00e9er la table SQL pour ins\u00e9rer les donn\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\/sql-server-insert-into-avec-des-variables\/#3-requete-insert-into-pour-inserer-des-donnees-avec-des-variables\" >3. Requ\u00eate INSERT INTO pour ins\u00e9rer des donn\u00e9es avec des variables<\/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\/sql-server-insert-into-avec-des-variables\/#4-avantages-des-variables-dans-le-developpement-t-sql\" >4. Avantages des variables dans le d\u00e9veloppement T-SQL<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-requete-sql-insert-into-avec-des-variables-t-sql\"><span class=\"ez-toc-section\" id=\"1-requete-sql-insert-into-avec-des-variables-t-sql\"><\/span>1. Requ\u00eate SQL INSERT INTO avec des variables T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ce tutoriel expose comment utiliser des variables dans une requ\u00eate pour ins\u00e9rer des donn\u00e9es dans une table SQL Server, r\u00e9utiliser le code de cet exemple d&rsquo;Insert Into depuis une requ\u00eate SELECT<strong>,<\/strong> et y ajouter les variables T-SQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-creer-la-table-sql-pour-inserer-les-donnees\"><\/span>2. Cr\u00e9er la table SQL pour ins\u00e9rer les donn\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Premi\u00e8rement, cr\u00e9er la table des Clients avec la colonne NOM d\u00e9clar\u00e9e comme unique pour ne pas ins\u00e9rer deux fois le m\u00eame client. Le num\u00e9ro de client NOCLIENT est auto-incr\u00e9ment\u00e9 pour avoir une liste suivie de num\u00e9ros de clients.<\/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\tAND type in (N'U') \n)\nDROP TABLE [dbo].[CLIENTS];\n\nCREATE TABLE [dbo].[CLIENTS] (\n\t[NOCLIENT] int IDENTITY(1,1),\n\t[NOM] nvarchar(20) UNIQUE,\n\t[VILLE] nvarchar(20)\n);\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-requete-insert-into-pour-inserer-des-donnees-avec-des-variables\"><\/span>3. Requ\u00eate INSERT INTO pour ins\u00e9rer des donn\u00e9es avec des variables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En effet, dans un bloc de code T-SQL, suivre ces deux \u00e9tapes simples.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>D\u00e9clarer une variable pour chaque colonne. Chacun des types de donn\u00e9es d\u00e9clar\u00e9 dans les variables correspond aux types de donn\u00e9es des colonnes.<\/li>\n\n\n\n<li>Ensuite, <a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/t-sql\/statements\/insert-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noopener noreferrer\">ins\u00e9rer<\/a> les donn\u00e9es avec <a href=\"https:\/\/expert-only.com\/ssms\/generer-requete-insert-into-ssms\/\">une requ\u00eate INSERT INTO<\/a> qui utilise les deux variables d\u00e9clar\u00e9es au d\u00e9but du code.<\/li>\n<\/ul>\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=\"\">-- D\u00e9claration des variables\nDECLARE @NOM NVARCHAR(20);\nDECLARE @VILLE NVARCHAR(20);\n\n-- Premi\u00e8re insertion\nSET @NOM = 'MAMMADOU';\nSET @VILLE = 'Lyon';\nINSERT INTO dbo.CLIENTS ( NOM, VILLE ) VALUES ( @NOM, @VILLE );\n\n-- Seconde insertion\nSET @NOM = 'CHRISTOPHE';\nSET @VILLE = 'Paris';\nINSERT INTO dbo.CLIENTS ( NOM, VILLE ) VALUES ( @NOM, @VILLE );\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-avantages-des-variables-dans-le-developpement-t-sql\"><\/span>4. Avantages des variables dans le d\u00e9veloppement T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L&rsquo;utilisation des variables T-SQL est utile pour r\u00e9utiliser plusieurs fois la valeur de la variable. C&rsquo;est \u00e0 dire \u00e9viter de copier-coller les m\u00eames valeurs dans un script et donc factoriser un maximum les objets. Rendre le code T-SQL dynamique est une bonne pratique, fortement recommand\u00e9e, c&rsquo;est notamment le but principal des <a href=\"https:\/\/expert-only.com\/t-sql\/creer-fonction-sql-server-avec-un-script\/\">fonctions<\/a> et des <a href=\"https:\/\/expert-only.com\/t-sql\/creer-une-procedure-stockee-sql-server\/\">proc\u00e9dures stock\u00e9es SQL Server<\/a>.<\/p>\n\n\n\n<p>Cet article explique donc comment construire et ex\u00e9cuter un script  SQL Server dynamique avec une commande INSERT INTO et des variables. Et ainsi ins\u00e9rer des donn\u00e9es dans une table via des variables instanci\u00e9es en d\u00e9but de script, ou qui \u00e9voluent pendant le d\u00e9roulement du script. Enfin, pour aller plus loin, voici un tutoriel pour <a href=\"https:\/\/expert-only.com\/t-sql\/mettre-a-jour-meme-colonne-autre-ligne-sql-server\/\">mettre \u00e0 jour la m\u00eame colonne d&rsquo;une autre ligne <\/a>dans une table SQL Server.<\/p>\n\n\n\n<figure class=\"wp-block-embed 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=\"nrUVamMDEm\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/\">Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server<\/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\u00a0Mettre \u00e0 jour la m\u00eame colonne sur une autre ligne avec SQL Server\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/maj-meme-colonne-sql-server-autre-ligne\/embed\/#?secret=uvtRgyGQcX#?secret=nrUVamMDEm\" data-secret=\"nrUVamMDEm\" 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>Une requ\u00eate SQL Server Insert Into avec des variables permet d&rsquo;ins\u00e9rer des donn\u00e9es de mani\u00e8re dynamique. Comment construire une requ\u00eate SQL Server INSERT INTO avec des variables pour rendre le code dynamique ? Ce tutoriel est similaire au premier <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/\" title=\"SQL Server INSERT INTO avec des variables\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10269,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-1232","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>SQL Server INSERT INTO avec des variables - T-SQL<\/title>\n<meta name=\"description\" content=\"Exemple de requ\u00eate SQL Server INSERT INTO avec des variables, pour ins\u00e9rer une ou plusieurs lignes dans une table avec du contenu dynamique.\" \/>\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\/sql-server-insert-into-avec-des-variables\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server INSERT INTO avec des variables\" \/>\n<meta property=\"og:description\" content=\"Exemple de requ\u00eate SQL Server INSERT INTO avec des variables, pour ins\u00e9rer une ou plusieurs lignes dans une table avec du contenu dynamique.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/\" \/>\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=\"2022-06-08T05:12:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-30T10:45:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_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\/sql-server-insert-into-avec-des-variables\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"SQL Server INSERT INTO avec des variables\",\"datePublished\":\"2022-06-08T05:12:00+00:00\",\"dateModified\":\"2022-11-30T10:45:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/\"},\"wordCount\":443,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/\",\"name\":\"SQL Server INSERT INTO avec des variables - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg\",\"datePublished\":\"2022-06-08T05:12:00+00:00\",\"dateModified\":\"2022-11-30T10:45:26+00:00\",\"description\":\"Exemple de requ\u00eate SQL Server INSERT INTO avec des variables, pour ins\u00e9rer une ou plusieurs lignes dans une table avec du contenu dynamique.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server INSERT INTO avec des variables\"}]},{\"@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":"SQL Server INSERT INTO avec des variables - T-SQL","description":"Exemple de requ\u00eate SQL Server INSERT INTO avec des variables, pour ins\u00e9rer une ou plusieurs lignes dans une table avec du contenu dynamique.","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\/sql-server-insert-into-avec-des-variables\/","og_locale":"fr_FR","og_type":"article","og_title":"SQL Server INSERT INTO avec des variables","og_description":"Exemple de requ\u00eate SQL Server INSERT INTO avec des variables, pour ins\u00e9rer une ou plusieurs lignes dans une table avec du contenu dynamique.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-06-08T05:12:00+00:00","article_modified_time":"2022-11-30T10:45:26+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_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\/sql-server-insert-into-avec-des-variables\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"SQL Server INSERT INTO avec des variables","datePublished":"2022-06-08T05:12:00+00:00","dateModified":"2022-11-30T10:45:26+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/"},"wordCount":443,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/","name":"SQL Server INSERT INTO avec des variables - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg","datePublished":"2022-06-08T05:12:00+00:00","dateModified":"2022-11-30T10:45:26+00:00","description":"Exemple de requ\u00eate SQL Server INSERT INTO avec des variables, pour ins\u00e9rer une ou plusieurs lignes dans une table avec du contenu dynamique.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/matrix-69E193580C5_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/sql-server-insert-into-avec-des-variables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"SQL Server INSERT INTO avec des variables"}]},{"@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\/1232","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=1232"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1232\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10269"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}