{"id":1071,"date":"2022-11-09T07:36:00","date_gmt":"2022-11-09T06:36:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1071"},"modified":"2022-11-30T11:36:44","modified_gmt":"2022-11-30T10:36:44","slug":"mettre-en-forme-une-requete-sql","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/","title":{"rendered":"Mettre en forme une requ\u00eate SQL automatiquement et gratuitement"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Comment mettre en forme une requ\u00eate SQL automatiquement ?<\/em><\/strong><\/h4>\n\n\n\n<p>Mettre en forme une requ\u00eate SQL automatiquement est parfois long et fastidieux, surtout sur des projets existants et non d\u00e9velopp\u00e9s dans les r\u00e8gles de l&rsquo;art. Il existe un site web utile qui permet de mettre en forme des requ\u00eates SQL. En effet, il est destin\u00e9 aux ing\u00e9nieurs en <a href=\"https:\/\/expert-only.com\/t-sql\/\">d\u00e9veloppement SQL<\/a>, aux DBA, et en g\u00e9n\u00e9ral \u00e0 tous les d\u00e9veloppeurs SQL. Il prend en compte diff\u00e9rents langages SQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-comment-mettre-en-forme-une-requete-sql-server-automatiquement\">Comment mettre en forme une requ\u00eate SQL Server automatiquement ?<\/h2>\n\n\n\n<p>Par ailleurs, il permet de mettre en forme le code SQL de nombreux \u00e9diteurs de syst\u00e8mes de gestion de bases de donn\u00e9es (SGBD). En effet, le site ne g\u00e8re non seulement SQL Server, mais d&rsquo;autres \u00e9diteurs. Dont voici la liste actuelle :&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/t-sql\/\">Microsoft Transact-SQL<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.microsoft.com\/fr-ch\/microsoft-365\/access\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Microsoft ACCESS<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.mysql.com\/fr\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">MySQL<\/a><\/li>\n\n\n\n<li>Oracle PL\/SQL<\/li>\n\n\n\n<li>DB2<\/li>\n\n\n\n<li>Le language <a href=\"https:\/\/expert-only.com\/concepts\/definition-mdx-multidimensional-expressions\/\">MDX<\/a><\/li>\n\n\n\n<li>Et aussi le SQL G\u00e9n\u00e9rique.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-center\"><strong><mark style=\"background-color:#fcb900\" class=\"has-inline-color\">De plus, attention, votre code peut contenir des informations sensibles ou des secrets de propri\u00e9t\u00e9 intellectuelle.<\/mark><\/strong><\/p>\n\n\n\n<p>A n&rsquo;utiliser qu&rsquo;en connaissance de cause ou avec des requ\u00eates n&rsquo;ayant pas n\u00e9cessiter une ing\u00e9nierie tr\u00e8s co\u00fbteuse. En effet, le site permet certes de gagner beaucoup de temps avec le formatage automatique mais <em>pourrait enregistrer toutes les requ\u00eates envoy\u00e9es<\/em>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Utiliser le site DPRiver pour formatter des requ\u00eates SQL<\/h2>\n\n\n\n<p>Utiliser le site dpriver et son outil <a href=\"https:\/\/www.dpriver.com\/pp\/sqlformat.htm\" target=\"_blank\" rel=\"noreferrer noopener\">Instant SQL Formatter<\/a> pour mettre en forme du code SQL gratuitement. Une option int\u00e9ressante est qu&rsquo;il propose de formatter avec de nombreux formats en sortie, comme le HTML pour mettre le code en surbrillance. Mais aussi plusieurs langages de programmation comme PHP, C#, Java, Delphi, VB entre autres et m\u00eame une sortie au format XML.<\/p>\n\n\n\n<p>Pour les langages de programmation hors SQL, ce sont des variables instanci\u00e9es avec le code de la requ\u00eate. Par exemple ce code SQL Server pour ins\u00e9rer et s\u00e9lectionner des clients, \u00e9crit en 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=\"\">-- ins\u00e9rer des donn\u00e9es pour les exemples de manipulation\ninsert into dbo.clients ( nom, ville )\nvalues ( n'mammadou', 'lyon');\ninsert into dbo.clients ( nom, ville )\nvalues ( n'sergei', 'lyon');\ninsert into dbo.clients ( nom, ville )\nvalues ( n'christophe', 'paris');\n\n-- v\u00e9rifier des lignes ins\u00e9r\u00e9es\nselect [noclient],[nom],[ville] from dbo.clients;\n<\/pre>\n\n\n\n<p>Deviendra en sortie du site de formatage automatique cette requ\u00eate, avec quelques options activ\u00e9es comme les majuscules pour les noms de table, de colonnes et de mots clefs.<\/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=\"\">-- Ins\u00e9rer des donn\u00e9es pour les exemples de manipulation\nINSERT INTO dbo.CLIENTS\n            (NOM,VILLE)\n     VALUES ( N'MAMMADOU','Lyon');\n\nINSERT INTO dbo.CLIENTS\n            (NOM,VILLE)\n     VALUES ( N'SERGEI','Lyon');\n\nINSERT INTO dbo.CLIENTS\n            (NOM,VILLE)\n     VALUES ( N'CHRISTOPHE','Paris');\n\n-- V\u00e9rifier des lignes ins\u00e9r\u00e9es\nSELECT [NOCLIENT],[NOM],[VILLE]\n  FROM dbo.CLIENTS; <\/pre>\n\n\n\n<p>Si les conditions ne sont pas satisfaisantes en termes de s\u00e9curit\u00e9, alors mettre en forme le code \u00e0 la main et avec le <a href=\"https:\/\/notepad-plus-plus.org\/downloads\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">logiciel open source Notepad++<\/a> par exemple est une tr\u00e8s bonne alternative.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Un Add-In payant pour SSMS<\/h2>\n\n\n\n<p><a href=\"https:\/\/www.dpriver.com\/products\/sqlpp\/ssms_index.php?ref=isf\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">SQL Pretty Printer<\/a> est un Add-In pour SQL Server Management Studio. La licence coute 50$ et permet d&rsquo;int\u00e9grer le formatage automatique directement dans le menu de SSMS. Il est donc possible de standardiser son code SQL en un seul clic.<\/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=\"4mueAQ9721\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-temporaire-sql-server\/\">Cr\u00e9er une table temporaire 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\u00a0Cr\u00e9er une table temporaire avec SQL Server\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-table-temporaire-sql-server\/embed\/#?secret=P4e7aiM6hx#?secret=4mueAQ9721\" data-secret=\"4mueAQ9721\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Tutoriels T-SQL<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/t-sql\/creer-table-sql-server\/\">Cr\u00e9er une table SQL Server<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/t-sql\/creer-fonction-sql-server-avec-un-script\/\">Cr\u00e9er une fonction SQL Server avec un script<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/t-sql\/creer-une-procedure-stockee-sql-server\/\">Script pour cr\u00e9er une proc\u00e9dure stock\u00e9e SQL Server<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment mettre en forme une requ\u00eate SQL automatiquement ? Mettre en forme une requ\u00eate SQL automatiquement est parfois long et fastidieux, surtout sur des projets existants et non d\u00e9velopp\u00e9s dans les r\u00e8gles de l&rsquo;art. Il existe un site web <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/\" title=\"Mettre en forme une requ\u00eate SQL automatiquement et gratuitement\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10687,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-1071","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>Mettre en forme une requ\u00eate SQL automatiquement - T-SQL<\/title>\n<meta name=\"description\" content=\"Pour mettre en forme une requ\u00eate SQL Server de mani\u00e8re automatique, utiliser ce service en ligne. Le code SQL retourn\u00e9 est mis en forme.\" \/>\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\/mettre-en-forme-une-requete-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mettre en forme une requ\u00eate SQL automatiquement et gratuitement\" \/>\n<meta property=\"og:description\" content=\"Pour mettre en forme une requ\u00eate SQL Server de mani\u00e8re automatique, utiliser ce service en ligne. Le code SQL retourn\u00e9 est mis en forme.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-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=\"2022-11-09T06:36:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-30T10:36:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/hour-glass-sands-of-time-4F71097A077_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\/mettre-en-forme-une-requete-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Mettre en forme une requ\u00eate SQL automatiquement et gratuitement\",\"datePublished\":\"2022-11-09T06:36:00+00:00\",\"dateModified\":\"2022-11-30T10:36:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/\"},\"wordCount\":494,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/hour-glass-sands-of-time-4F71097A077_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/\",\"name\":\"Mettre en forme une requ\u00eate SQL automatiquement - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/hour-glass-sands-of-time-4F71097A077_1920x1080.jpg\",\"datePublished\":\"2022-11-09T06:36:00+00:00\",\"dateModified\":\"2022-11-30T10:36:44+00:00\",\"description\":\"Pour mettre en forme une requ\u00eate SQL Server de mani\u00e8re automatique, utiliser ce service en ligne. Le code SQL retourn\u00e9 est mis en forme.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/hour-glass-sands-of-time-4F71097A077_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/hour-glass-sands-of-time-4F71097A077_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mettre en forme une requ\u00eate SQL automatiquement et gratuitement\"}]},{\"@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":"Mettre en forme une requ\u00eate SQL automatiquement - T-SQL","description":"Pour mettre en forme une requ\u00eate SQL Server de mani\u00e8re automatique, utiliser ce service en ligne. Le code SQL retourn\u00e9 est mis en forme.","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\/mettre-en-forme-une-requete-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"Mettre en forme une requ\u00eate SQL automatiquement et gratuitement","og_description":"Pour mettre en forme une requ\u00eate SQL Server de mani\u00e8re automatique, utiliser ce service en ligne. Le code SQL retourn\u00e9 est mis en forme.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-11-09T06:36:00+00:00","article_modified_time":"2022-11-30T10:36:44+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/hour-glass-sands-of-time-4F71097A077_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\/mettre-en-forme-une-requete-sql\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Mettre en forme une requ\u00eate SQL automatiquement et gratuitement","datePublished":"2022-11-09T06:36:00+00:00","dateModified":"2022-11-30T10:36:44+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/"},"wordCount":494,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/hour-glass-sands-of-time-4F71097A077_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/","name":"Mettre en forme une requ\u00eate SQL automatiquement - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/hour-glass-sands-of-time-4F71097A077_1920x1080.jpg","datePublished":"2022-11-09T06:36:00+00:00","dateModified":"2022-11-30T10:36:44+00:00","description":"Pour mettre en forme une requ\u00eate SQL Server de mani\u00e8re automatique, utiliser ce service en ligne. Le code SQL retourn\u00e9 est mis en forme.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/hour-glass-sands-of-time-4F71097A077_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/hour-glass-sands-of-time-4F71097A077_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/mettre-en-forme-une-requete-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Mettre en forme une requ\u00eate SQL automatiquement et gratuitement"}]},{"@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\/1071","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=1071"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1071\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10687"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}