{"id":26163,"date":"2023-05-23T08:54:00","date_gmt":"2023-05-23T06:54:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=26163"},"modified":"2023-07-17T14:49:31","modified_gmt":"2023-07-17T12:49:31","slug":"index-full-text-sur-colonne-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/","title":{"rendered":"Cr\u00e9er un index Full-Text sur une colonne SQL Server avec un script"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\"><strong><em>Tutoriel pour cr\u00e9er des index de recherche en texte int\u00e9gral, full-text index, sur une colonne SQL Server avec des scripts.<\/em><\/strong><\/h4>\n\n\n\n<p>L&rsquo;exploitation de la puissance de la recherche via les index full-text sur une colonne SQL Server peut consid\u00e9rablement am\u00e9liorer l&rsquo;efficacit\u00e9 et la rapidit\u00e9 de vos requ\u00eates dans les projets de development SQL Server. Pour exploiter cette fonctionnalit\u00e9, cr\u00e9er d&rsquo;abord un index full-text sur la colonne souhait\u00e9e. Ce tutoriel vous guidera pas \u00e0 pas dans le processus de configuration d&rsquo;un index plein texte sur une colonne SQL Server, en commen\u00e7ant par la cr\u00e9ation de la table et en terminant par la cr\u00e9ation de l&rsquo;index lui-m\u00eame.<\/p>\n\n\n\n<p>Pour utiliser la recherche plein texte sur une colonne, vous devez cr\u00e9er un index plein texte sur cette colonne. Les index plein texte sont diff\u00e9rents des <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/\">index standard SQL Server<\/a>. Voici comment proc\u00e9der dans SQL Server :<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-creer-la-table-a-indexer\">1. Cr\u00e9er la table \u00e0 indexer<\/h2>\n\n\n\n<p>Consid\u00e9rons tout d&rsquo;abord la table SQL Server suivante qui sert d&rsquo;exemple pour cet index, \u00e0 cr\u00e9er avec SSMS.<\/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 TABLE dbo.Clients (\n   IDClient INT UNIQUE NOT NULL,\n   NomClient VARCHAR(255),\n   Pays VARCHAR(255)\n);\n<\/pre>\n\n\n\n<p>Ins\u00e9rer ensuite une douzaine de lignes avec ces 3 colonnes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Num\u00e9ro de client<\/li>\n\n\n\n<li>Nom de client<\/li>\n\n\n\n<li>Pays<\/li>\n<\/ul>\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=\"\">INSERT INTO dbo.Clients (IDClient, NomClient, Pays)\nVALUES\n   (1, 'John Smith', 'USA'),\n   (2, 'Jane Doe', 'Canada'),\n   (3, 'Bob Johnson', 'USA'),\n   (4, 'Alice Williams', 'UK'),\n   (5, 'Charlie Brown', 'USA'),\n   (6, 'Sophie Turner', 'UK'),\n   (7, 'James Wilson', 'Canada'),\n   (8, 'Linda Taylor', 'USA'),\n   (9, 'Michael Davis', 'UK'),\n   (10, 'Emily Miller', 'Canada'),\n   (11, 'William Garcia', 'USA'),\n   (12, 'Elizabeth Martinez', 'UK');\n<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. Cr\u00e9er un index unique sur la table des clients<\/h2>\n\n\n\n<p>Apr\u00e8s avoir cr\u00e9\u00e9 la table d&rsquo;exemple, la deuxi\u00e8me \u00e9tape est de s&rsquo;assurer que la base de donn\u00e9es dispose d&rsquo;un index unique. C&rsquo;est une condition pr\u00e9alable \u00e0 la cr\u00e9ation d&rsquo;un index de type full-text. Pour la table des Clients, la colonne IDClient est unique et non nulle, il est donc possible de l&rsquo;utiliser :<\/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 UNIQUE INDEX ui_IDClient\nON dbo.Clients(IDClient);\n<\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. Cr\u00e9er le catalogue full-text SQL Server<\/h2>\n\n\n\n<p>Une fois l&rsquo;index unique cr\u00e9\u00e9, cr\u00e9er maintenant le catalogue de rechercher de texte int\u00e9gral. Un catalogue de type full-text est un conteneur logique.<\/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 FULLTEXT CATALOG ft_Catalog AS DEFAULT;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">4. Ajouter l&rsquo;index Full-Text \u00e0 la colonne MS SQL<\/h2>\n\n\n\n<p>Enfin, effectuer maintenant la derni\u00e8re \u00e9tape, c&rsquo;est-\u00e0-dire cr\u00e9er l&rsquo;index Full-Text sur la colonne NomClient dans la table des clients:<\/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 FULLTEXT INDEX ON dbo.Clients\n(\n    NomClient LANGUAGE French\n)\nKEY INDEX ui_IDClient\n   ON ft_Catalog \nWITH CHANGE_TRACKING AUTO;\n<\/pre>\n\n\n\n<p>Dans cette requ\u00eate T-SQL pour cr\u00e9er l&rsquo;index, voici les les \u00e9tapes et les mots-cl\u00e9s expliqu\u00e9s:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>LANGUAGE French<\/strong> sp\u00e9cifie que la colonne NomClient est en langue <strong><em>fran\u00e7aise<\/em><\/strong>. SQL Server utilise cette information pour la coupure de mots et l&rsquo;abr\u00e9viation, par exemple.<\/li>\n\n\n\n<li><strong>KEY INDEX ui_IDClient<\/strong> sp\u00e9cifie l&rsquo;index unique \u00e0 utiliser par l&rsquo;index Full-Text.<\/li>\n\n\n\n<li><strong>ON ft_Catalog<\/strong> sp\u00e9cifie le nom du catalogue plein texte cr\u00e9\u00e9 \u00e0 l&rsquo;\u00e9tape pr\u00e9c\u00e9dente.<\/li>\n\n\n\n<li><strong>WITH CHANGE_TRACKING AUTO<\/strong> sp\u00e9cifie que les modifications: mises \u00e0 jour, suppressions ou insertions, apport\u00e9es aux donn\u00e9es de la table sont propag\u00e9es vers l&rsquo;index.<\/li>\n<\/ul>\n\n\n\n<p>Veuillez noter que ces commandes doivent \u00eatre ex\u00e9cut\u00e9es par un utilisateur disposant des autorisations n\u00e9cessaires pour cr\u00e9er des catalogues et des index Full-Text, g\u00e9n\u00e9ralement un administrateur de base de donn\u00e9es. En outre, la recherche plein texte doit \u00eatre install\u00e9e et activ\u00e9e pour la base de donn\u00e9es dans laquelle ces commandes sont ex\u00e9cut\u00e9es. Si le geste n&rsquo;est pas install\u00e9 et actif, le message d&rsquo;erreur suivant s&rsquo;affiche dans SSMS :<\/p>\n\n\n\n<p>En Fran\u00e7ais:<\/p>\n\n\n\n<p><strong><em>La recherche de texte int\u00e9gral n&rsquo;est pas install\u00e9e ou il est impossible de charger le composant de recherche de texte int\u00e9gral.<\/em><\/strong><\/p>\n\n\n\n<p>Et en Anglais:<\/p>\n\n\n\n<p><strong><em>Full-Text Search is not installed, or a full-text component cannot be loaded.<\/em><\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Conclusion sur la cr\u00e9ation d&rsquo;index Full-Text avec des scripts T-SQL<\/h3>\n\n\n\n<p>Pour conclure sur ces \u00e9tapes n\u00e9cessaires pour cr\u00e9er un index plein texte sur une colonne SQL Server, ce processus implique quelques \u00e9tapes cl\u00e9s. Comment la cr\u00e9ation de la table et de l&rsquo;index unique. Ensuite, l&rsquo;ajout d&rsquo;un catalogue et enfin, la cr\u00e9ation de l&rsquo;index Full-Text lui-m\u00eame.<\/p>\n\n\n\n<p>Garder \u00e0 l&rsquo;esprit que l&rsquo;ex\u00e9cution de ces t\u00e2ches n\u00e9cessite des autorisations d&rsquo;administrateur sur la base de donn\u00e9es cible. Maintenant que vous disposez des scripts, il est simple d&rsquo;am\u00e9liorer consid\u00e9rablement les performances des requ\u00eates, en particulier pour les op\u00e9rations de recherche intensives utilisant du texte. Assurez-vous toujours que la recherche plein texte est install\u00e9e et activ\u00e9e pour la base de donn\u00e9es afin d&rsquo;utiliser ces fonctionnalit\u00e9s.<\/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=\"wY1Uesehyt\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/\">Cr\u00e9er un index SQL Server avec un script<\/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\u00a0Cr\u00e9er un index SQL Server avec un script\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/embed\/#?secret=UAwpcvJCxS#?secret=wY1Uesehyt\" data-secret=\"wY1Uesehyt\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Tutoriel pour cr\u00e9er des index de recherche en texte int\u00e9gral, full-text index, sur une colonne SQL Server avec des scripts. L&rsquo;exploitation de la puissance de la recherche via les index full-text sur une colonne SQL Server peut consid\u00e9rablement am\u00e9liorer <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/\" title=\"Cr\u00e9er un index Full-Text sur une colonne SQL Server avec un script\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10812,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-26163","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>Cr\u00e9er un index Full-Text sur une colonne SQL Server<\/title>\n<meta name=\"description\" content=\"Cr\u00e9ez un index Full-Text sur une colonne SQL Server avec des scripts T-SQL avec ce tutoriel \u00e9tape par \u00e9tape qui utilise un catalogue.\" \/>\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\/index-full-text-sur-colonne-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cr\u00e9er un index Full-Text sur une colonne SQL Server avec un script\" \/>\n<meta property=\"og:description\" content=\"Cr\u00e9ez un index Full-Text sur une colonne SQL Server avec des scripts T-SQL avec ce tutoriel \u00e9tape par \u00e9tape qui utilise un catalogue.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-23T06:54:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-17T12:49:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_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\/index-full-text-sur-colonne-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Cr\u00e9er un index Full-Text sur une colonne SQL Server avec un script\",\"datePublished\":\"2023-05-23T06:54:00+00:00\",\"dateModified\":\"2023-07-17T12:49:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/\"},\"wordCount\":738,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/\",\"name\":\"Cr\u00e9er un index Full-Text sur une colonne SQL Server\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg\",\"datePublished\":\"2023-05-23T06:54:00+00:00\",\"dateModified\":\"2023-07-17T12:49:31+00:00\",\"description\":\"Cr\u00e9ez un index Full-Text sur une colonne SQL Server avec des scripts T-SQL avec ce tutoriel \u00e9tape par \u00e9tape qui utilise un catalogue.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cr\u00e9er un index Full-Text sur une colonne SQL Server avec un script\"}]},{\"@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":"Cr\u00e9er un index Full-Text sur une colonne SQL Server","description":"Cr\u00e9ez un index Full-Text sur une colonne SQL Server avec des scripts T-SQL avec ce tutoriel \u00e9tape par \u00e9tape qui utilise un catalogue.","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\/index-full-text-sur-colonne-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Cr\u00e9er un index Full-Text sur une colonne SQL Server avec un script","og_description":"Cr\u00e9ez un index Full-Text sur une colonne SQL Server avec des scripts T-SQL avec ce tutoriel \u00e9tape par \u00e9tape qui utilise un catalogue.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-05-23T06:54:00+00:00","article_modified_time":"2023-07-17T12:49:31+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_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\/index-full-text-sur-colonne-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Cr\u00e9er un index Full-Text sur une colonne SQL Server avec un script","datePublished":"2023-05-23T06:54:00+00:00","dateModified":"2023-07-17T12:49:31+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/"},"wordCount":738,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/","name":"Cr\u00e9er un index Full-Text sur une colonne SQL Server","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg","datePublished":"2023-05-23T06:54:00+00:00","dateModified":"2023-07-17T12:49:31+00:00","description":"Cr\u00e9ez un index Full-Text sur une colonne SQL Server avec des scripts T-SQL avec ce tutoriel \u00e9tape par \u00e9tape qui utilise un catalogue.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/pencils-CDFB9498B85_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/index-full-text-sur-colonne-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Cr\u00e9er un index Full-Text sur une colonne SQL Server avec un script"}]},{"@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\/26163","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=26163"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/26163\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10812"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=26163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=26163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=26163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}