{"id":1111,"date":"2024-03-12T07:35:37","date_gmt":"2024-03-12T06:35:37","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1111"},"modified":"2024-03-12T11:35:51","modified_gmt":"2024-03-12T10:35:51","slug":"decouper-texte-apres-un-caractere-en-t-sql","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/","title":{"rendered":"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\"><em>Exemple de requ\u00eate \u00e9crite en T-SQL pour d\u00e9couper un texte apr\u00e8s un caract\u00e8re particulier.<\/em><\/h4>\n\n\n\n<p>Il est courant de d\u00e9couper du texte en T-SQL, souvent le d\u00e9coupage  doit se faire apr\u00e8s un caract\u00e8re donn\u00e9, appel\u00e9 s\u00e9parateur ou d\u00e9limiteur dans les grands champs textes. Comme par exemple un nom de fichier fichier.txt pour s\u00e9parer le nom du fichier de son extension. En effet, il est \u00e9vident que d\u00e9couper une cha\u00eene juste avant le caract\u00e8re, ici un point, doit se faire de mani\u00e8re dynamique, c&rsquo;est \u00e0 dire quelle que soit la position du caract\u00e8re.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-decouper-une-chaine-apres-un-caractere-avec-3-fonctions-t-sql-standard\">1. D\u00e9couper une cha\u00eene apr\u00e8s un caract\u00e8re avec 3 fonctions T-SQL standard<\/h2>\n\n\n\n<p>Tout d&rsquo;abord, pour d\u00e9couper une cha\u00eene de texte avec MS SQL juste apr\u00e8s un certain caract\u00e8re, utiliser les fonctions textes suivantes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/docs.microsoft.com\/fr-fr\/sql\/t-sql\/functions\/substring-transact-sql?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">SUBSTRING<\/a>()<\/strong> pour d\u00e9couper un texte en indiquant le d\u00e9but et la longueur \u00e0 d\u00e9couper.<\/li>\n\n\n\n<li><strong>CHARINDEX()<\/strong> retourne la position d&rsquo;un texte \u00e0 rechercher. La fonction utilise le texte \u00e0 rechercher, le texte dans lequel rechercher et la position de d\u00e9part de la recherche.<\/li>\n\n\n\n<li><strong>LEN()<\/strong> est une fonction qui retourne la longueur d&rsquo;un texte donn\u00e9.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">2. Requ\u00eate T-SQL pour couper le texte en utilisant 3 variables<\/h2>\n\n\n\n<p>D&rsquo;ailleurs, cet exemple n&rsquo;est pas r\u00e9cursif. Cependant, pour le rendre r\u00e9cursif, il suffit d&rsquo;int\u00e9grer la logique dans une boucle. Ajuster ensuite la variable qui contient le caract\u00e8re dans la cha\u00eene principale. Voici donc cette fois un <strong><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-un-texte-avec-separateur-en-colonne-avec-sql-server\/\">exemple de code T-SQL r\u00e9cursif  pour d\u00e9couper une cha\u00eene de texte avec d\u00e9limiteurs<\/a><\/strong> (comme des points, des demi-colonnes ou des virgules) \u00e0 l&rsquo;aide d&rsquo;un script T-SQL.<\/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=\"\">-- D\u00e9claration des variables utilis\u00e9es comme chaine de d\u00e9part, chaine de r\u00e9sultat et le caract\u00e8re utilis\u00e9\ndeclare @ChaineDepart nvarchar(100)\ndeclare @Resultat nvarchar(100)\ndeclare @Caractere nvarchar(10)\n\n-- D\u00e9finition de la cha\u00eene de caract\u00e8re\nset @ChaineDepart = 'DEBUT_DE_CHAINE.FIN_DE_CHAINE'\n\n-- D\u00e9finition du caract\u00e8re ou de la cha\u00eene de caract\u00e8re \u00e0 chercher pour couper la cha\u00eene en deux\nset @Caractere = '.'\nset @Resultat = substring(@ChaineDepart,CHARINDEX(@Caractere, @ChaineDepart)+1,len(@ChaineDepart))\n\nselect @ChaineDepart as 'Chaine de D\u00e9part'\nselect @Resultat as 'Chaine de R\u00e9sultat'\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"827\" height=\"453\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL_Server-couper-chaine-apres-charactere.png\" alt=\"Requ\u00eate T-SQL  pour D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re depuis SSMS\" class=\"wp-image-1113\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL_Server-couper-chaine-apres-charactere.png 827w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL_Server-couper-chaine-apres-charactere-300x164.png 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/SQL_Server-couper-chaine-apres-charactere-768x421.png 768w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><figcaption class=\"wp-element-caption\"><em>Requ\u00eate T-SQL  pour D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re depuis SSMS<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Dans la capture d&rsquo;\u00e9cran ci-dessus avec la requ\u00eate, la derni\u00e8re partie du texte est isol\u00e9e par la fonction substring et affich\u00e9e comme r\u00e9sultat.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-decouper-une-chaine-sql-sans-la-fonction-split-string\">D\u00e9couper une cha\u00eene SQL sans la fonction SPLIT_STRING<\/h3>\n\n\n\n<p>Pour conclure sur cette requ\u00eate \u00e9crite en T-SQL qui permet de d\u00e9couper un texte apr\u00e8s un caract\u00e8re donn\u00e9, il est pr\u00e9f\u00e9rable de migrer vers les versions les plus r\u00e9centes de SQL Server pour b\u00e9n\u00e9ficier de la  function int\u00e9gr\u00e9e : SPLIT_STRING.<\/p>\n\n\n\n<p>Voici un autre tutoriel SQL sur la gestion de texte, apprenez \u00e0 <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/textes-sql-server-plus-de-8000-caracteres\/\"><strong>g\u00e9rer des cha\u00eenes de plus de 8000 caract\u00e8res avec des variables T-SQL<\/strong><\/a> et sp\u00e9cifiquement \u00e0 l&rsquo;int\u00e9rieur des proc\u00e9dures stock\u00e9es.<\/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=\"eIN9rxS9pl\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-un-texte-avec-separateur-en-colonne-avec-sql-server\/\">D\u00e9couper un Texte avec S\u00e9parateur en Colonne 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\u00a0D\u00e9couper un Texte avec S\u00e9parateur en Colonne avec SQL Server\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-un-texte-avec-separateur-en-colonne-avec-sql-server\/embed\/#?secret=fbMz21AEGF#?secret=eIN9rxS9pl\" data-secret=\"eIN9rxS9pl\" 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 de requ\u00eate \u00e9crite en T-SQL pour d\u00e9couper un texte apr\u00e8s un caract\u00e8re particulier. Il est courant de d\u00e9couper du texte en T-SQL, souvent le d\u00e9coupage doit se faire apr\u00e8s un caract\u00e8re donn\u00e9, appel\u00e9 s\u00e9parateur ou d\u00e9limiteur dans les <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/\" title=\"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10607,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-1111","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>D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL<\/title>\n<meta name=\"description\" content=\"Pour d\u00e9couper un texte apr\u00e8s un caract\u00e8re en T-SQL, utiliser cet exemple de code qui utilise les fonctions textes SQL Server int\u00e9gr\u00e9es.\" \/>\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\/decouper-texte-apres-un-caractere-en-t-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL\" \/>\n<meta property=\"og:description\" content=\"Pour d\u00e9couper un texte apr\u00e8s un caract\u00e8re en T-SQL, utiliser cet exemple de code qui utilise les fonctions textes SQL Server int\u00e9gr\u00e9es.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/\" \/>\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=\"2024-03-12T06:35:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-12T10:35:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_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=\"2 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\/decouper-texte-apres-un-caractere-en-t-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL\",\"datePublished\":\"2024-03-12T06:35:37+00:00\",\"dateModified\":\"2024-03-12T10:35:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/\"},\"wordCount\":448,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/\",\"name\":\"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg\",\"datePublished\":\"2024-03-12T06:35:37+00:00\",\"dateModified\":\"2024-03-12T10:35:51+00:00\",\"description\":\"Pour d\u00e9couper un texte apr\u00e8s un caract\u00e8re en T-SQL, utiliser cet exemple de code qui utilise les fonctions textes SQL Server int\u00e9gr\u00e9es.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL\"}]},{\"@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":"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL","description":"Pour d\u00e9couper un texte apr\u00e8s un caract\u00e8re en T-SQL, utiliser cet exemple de code qui utilise les fonctions textes SQL Server int\u00e9gr\u00e9es.","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\/decouper-texte-apres-un-caractere-en-t-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL","og_description":"Pour d\u00e9couper un texte apr\u00e8s un caract\u00e8re en T-SQL, utiliser cet exemple de code qui utilise les fonctions textes SQL Server int\u00e9gr\u00e9es.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-12T06:35:37+00:00","article_modified_time":"2024-03-12T10:35:51+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL","datePublished":"2024-03-12T06:35:37+00:00","dateModified":"2024-03-12T10:35:51+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/"},"wordCount":448,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/","name":"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg","datePublished":"2024-03-12T06:35:37+00:00","dateModified":"2024-03-12T10:35:51+00:00","description":"Pour d\u00e9couper un texte apr\u00e8s un caract\u00e8re en T-SQL, utiliser cet exemple de code qui utilise les fonctions textes SQL Server int\u00e9gr\u00e9es.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/desk-notes-pen-A4C6B252209_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/decouper-texte-apres-un-caractere-en-t-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"D\u00e9couper un Texte apr\u00e8s un Caract\u00e8re en T-SQL"}]},{"@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\/1111","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=1111"}],"version-history":[{"count":2,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1111\/revisions"}],"predecessor-version":[{"id":30626,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1111\/revisions\/30626"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10607"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}