{"id":859,"date":"2022-11-10T06:44:00","date_gmt":"2022-11-10T05:44:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=859"},"modified":"2022-12-01T08:44:24","modified_gmt":"2022-12-01T07:44:24","slug":"stocker-une-colonne-sql-server-en-variable","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/","title":{"rendered":"Stocker une colonne SQL Server dans une variable avec s\u00e9parateurs"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Requ\u00eate pour stocker le contenu d&rsquo;une colonne SQL Server dans une variable, en ligne et avec des s\u00e9parateurs.<\/em><\/strong><\/h4>\n\n\n\n<p>Tutoriel SQL pour lire et stocker le r\u00e9sultat depuis une colonne SQL Server dans une variable, et avec des s\u00e9parateurs. Dans certains cas, il est utile de r\u00e9cup\u00e9rer toutes les valeurs d&rsquo;une colonne dans une variable T-SQL et d&rsquo;ajouter un s\u00e9parateur.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-stocker-le-contenu-d-une-colonne-sql-server-dans-une-variable\">Stocker le contenu d&rsquo;une colonne SQL Server dans une variable<\/h2>\n\n\n\n<p>Pour pr\u00e9parer un tableau avec des caract\u00e9ristiques sp\u00e9cifiques par exemple. Par exemple, comment transformer l&rsquo;affiche standard d&rsquo;une colonne SQL Server, comme ceci :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Colonne<\/strong><\/li>\n\n\n\n<li><em>R\u00e9sultat-1<\/em><\/li>\n\n\n\n<li><em>R\u00e9sultat-2<\/em><\/li>\n\n\n\n<li><em>R\u00e9sultat-3<\/em><\/li>\n\n\n\n<li><em>R\u00e9sultat-4<\/em><\/li>\n<\/ul>\n\n\n\n<p>Et afficher cela, soit le r\u00e9sultat de toutes les lignes s\u00e9lectionn\u00e9es dans une variable avec un s\u00e9parateur virgule ou point-virgule par exemple :<\/p>\n\n\n\n<p><strong>Variable <\/strong>: R\u00e9sultat-1, R\u00e9sultat-2, R\u00e9sultat-3, R\u00e9sultat-4<\/p>\n\n\n\n<p>Pour suivre le cheminement, cr\u00e9er la table utilis\u00e9e dans l&rsquo;exemple, y ins\u00e9rer des lignes et construire la requ\u00eate adapt\u00e9e aux besoins sp\u00e9cifiques. Pour l&rsquo;exemple complet, suivre les \u00e9tapes suivantes.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Cr\u00e9er la table des clients et ins\u00e9rer quelques lignes<\/h2>\n\n\n\n<p>Commencer par cr\u00e9er la table des clients comme exemple et s\u00e9lectionner la colonne du pays.<\/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 the customers table\nCREATE TABLE [dbo].[Customers](\n   [CustomerID] [int] NOT NULL,\n   [FirstName] [nvarchar](20) NULL,\n   [LastName] [nvarchar](20) NULL,\n   [City] [nvarchar](20) NULL,\n   [Country] [nvarchar](50) NULL,\n   CONSTRAINT [CustomersPrimaryKeyCustomerID] \n      PRIMARY KEY CLUSTERED ([CustomerID] ASC)\n);\nGO\n-- Insert 4 different lines\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 1, 'Ali','Ahmed','Cairo','Egypt');\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 2, 'Johnny','John','Toronto','Canada');\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 3, 'John','Doe','Mexico City','Mexico');\nINSERT INTO dbo.Customers (CustomerID, FirstName, LastName, City, Country) \nVALUES ( 4, 'Shu','Abbas','Paris','France');\n\nSELECT [Country] \nFROM [dbo].[Customers];\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"700\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssms-create-customers-table-and-select-country-column.jpg\" alt=\"Cr\u00e9er la table des clients pour ins\u00e9rer et afficher la colonne du pays\" class=\"wp-image-11721\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssms-create-customers-table-and-select-country-column.jpg 800w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssms-create-customers-table-and-select-country-column-300x263.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssms-create-customers-table-and-select-country-column-768x672.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption class=\"wp-element-caption\">Cr\u00e9er la table des clients pour ins\u00e9rer et afficher la colonne du pays<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">2. Requ\u00eate pour stocker une colonne en ligne avec s\u00e9parateurs<\/h2>\n\n\n\n<p>La requ\u00eate suivante permet de stocker chaque ligne de la colonne dans une variable et d&rsquo;y ajouter un <a href=\"https:\/\/fr.wikipedia.org\/wiki\/S\u00e9parateur_(informatique)\">s\u00e9parateur<\/a>, ici c&rsquo;est le point-virgule. Le r\u00e9sultat est donc sur une seule ligne. Le script utilise la fonction SQL Server <a href=\"https:\/\/linuxhint.com\/sql-server-coalesce\/\" target=\"_blank\" rel=\"noreferrer noopener\">COALESCE()<\/a>.<\/p>\n\n\n\n<p>La variable peut contenir 1000 caract\u00e8res, en fonction du besoin il faut adapter le type de la variable texte. Notamment pour <a href=\"https:\/\/expert-only.com\/t-sql\/gerer-champs-textes-sql-server-plus-8000-caracteres\/\">g\u00e9rer des chaines de plus de 8000 caract\u00e8res avec une variable T-SQL<\/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=\"\">-- Classical selection\nSELECT [Country] \nFROM   [dbo].[Customers];\n\n-- Transform column in one line\nDECLARE @result_in_line nvarchar(1000);\n\nSELECT \t@result_in_line = COALESCE(@result_in_line+';','') + [Country]\nFROM \t[dbo].[Customers];\n\nSELECT \t@result_in_line;\n<\/pre>\n\n\n\n<p>Voici le r\u00e9sultat du script ex\u00e9cut\u00e9 depuis SSMS: <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"520\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssms-t-sql-coalesce-query-turn-column-in-one-line.jpg\" alt=\"Comment stocker une colonne SQL dans une variable avec s\u00e9parateurs ?\" class=\"wp-image-11726\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssms-t-sql-coalesce-query-turn-column-in-one-line.jpg 800w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssms-t-sql-coalesce-query-turn-column-in-one-line-300x195.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssms-t-sql-coalesce-query-turn-column-in-one-line-768x499.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption class=\"wp-element-caption\"><strong>Comment stocker une colonne SQL dans une variable avec s\u00e9parateurs ?<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Voici comment stocker une colonne SQL Server dans une variable, en ligne avec des s\u00e9parateurs de type point-virgule, plut\u00f4t qu&rsquo;en colonne. En effet, cet exemple de script \u00e9crit en langage T-SQL est particuli\u00e8rement utile pour afficher des valeurs distinctes d&rsquo;une colonne, tri\u00e9e par ordre croissant.<\/p>\n\n\n\n<p>Enfin, pour apprendre de nouveaux scripts T-SQL, voici une <a href=\"https:\/\/expert-only.com\/transact-sql\/conversion-implicite-du-type-de-donnees-xml-en-nvarchar\/\">requ\u00eate SQL pour convertir une variable SQL Server XML en texte<\/a>.<\/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\">\nhttps:\/\/expert-only.com\/t-sql\/conversion-implicite-du-type-de-donnees-xml\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Requ\u00eate pour stocker le contenu d&rsquo;une colonne SQL Server dans une variable, en ligne et avec des s\u00e9parateurs. Tutoriel SQL pour lire et stocker le r\u00e9sultat depuis une colonne SQL Server dans une variable, et avec des s\u00e9parateurs. Dans <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/\" title=\"Stocker une colonne SQL Server dans une variable avec s\u00e9parateurs\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-859","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>Stocker une colonne SQL Server dans une variable - T-SQL<\/title>\n<meta name=\"description\" content=\"Exemple de script T-SQL pour stocker une colonne SQL Server dans une variable en ligne avec des s\u00e9parateurs de texte.\" \/>\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\/stocker-une-colonne-sql-server-en-variable\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Stocker une colonne SQL Server dans une variable avec s\u00e9parateurs\" \/>\n<meta property=\"og:description\" content=\"Exemple de script T-SQL pour stocker une colonne SQL Server dans une variable en ligne avec des s\u00e9parateurs de texte.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/\" \/>\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-11-10T05:44:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-01T07:44:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-93432E0FFA4_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\/stocker-une-colonne-sql-server-en-variable\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Stocker une colonne SQL Server dans une variable avec s\u00e9parateurs\",\"datePublished\":\"2022-11-10T05:44:00+00:00\",\"dateModified\":\"2022-12-01T07:44:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/\"},\"wordCount\":429,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-93432E0FFA4_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/\",\"name\":\"Stocker une colonne SQL Server dans une variable - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-93432E0FFA4_1920x1080.jpg\",\"datePublished\":\"2022-11-10T05:44:00+00:00\",\"dateModified\":\"2022-12-01T07:44:24+00:00\",\"description\":\"Exemple de script T-SQL pour stocker une colonne SQL Server dans une variable en ligne avec des s\u00e9parateurs de texte.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-93432E0FFA4_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-93432E0FFA4_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Stocker une colonne SQL Server dans une variable avec s\u00e9parateurs\"}]},{\"@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":"Stocker une colonne SQL Server dans une variable - T-SQL","description":"Exemple de script T-SQL pour stocker une colonne SQL Server dans une variable en ligne avec des s\u00e9parateurs de texte.","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\/stocker-une-colonne-sql-server-en-variable\/","og_locale":"fr_FR","og_type":"article","og_title":"Stocker une colonne SQL Server dans une variable avec s\u00e9parateurs","og_description":"Exemple de script T-SQL pour stocker une colonne SQL Server dans une variable en ligne avec des s\u00e9parateurs de texte.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-11-10T05:44:00+00:00","article_modified_time":"2022-12-01T07:44:24+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-93432E0FFA4_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\/stocker-une-colonne-sql-server-en-variable\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Stocker une colonne SQL Server dans une variable avec s\u00e9parateurs","datePublished":"2022-11-10T05:44:00+00:00","dateModified":"2022-12-01T07:44:24+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/"},"wordCount":429,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-93432E0FFA4_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/","name":"Stocker une colonne SQL Server dans une variable - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-93432E0FFA4_1920x1080.jpg","datePublished":"2022-11-10T05:44:00+00:00","dateModified":"2022-12-01T07:44:24+00:00","description":"Exemple de script T-SQL pour stocker une colonne SQL Server dans une variable en ligne avec des s\u00e9parateurs de texte.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-93432E0FFA4_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/idea-93432E0FFA4_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/stocker-une-colonne-sql-server-en-variable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Stocker une colonne SQL Server dans une variable avec s\u00e9parateurs"}]},{"@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\/859","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=859"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/859\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10702"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}