{"id":189,"date":"2015-12-29T08:06:55","date_gmt":"2015-12-29T14:06:55","guid":{"rendered":"http:\/\/www.sqlnuggets.com\/?p=189"},"modified":"2015-12-29T08:06:55","modified_gmt":"2015-12-29T14:06:55","slug":"online-sql-formatting-service","status":"publish","type":"post","link":"https:\/\/sqlnuggets.com\/online-sql-formatting-service\/","title":{"rendered":"Online SQL Formatting Service"},"content":{"rendered":"<p>I stumbled upon this last week and thought I would share it. \u00a0<a href=\"http:\/\/sqlformat.org\/\" target=\"_blank\">SQLFormat<\/a> is a <strong>free online formatter for SQL statements<\/strong>. \u00a0It&#8217;s pretty straight forward and easy to use. \u00a0You just\u00a0enter your SQL statements into a text area, or upload an entire file, and it will\u00a0parse and format your SQL statements. \u00a0This is definitely a useful tool when having to try to sort through a big ole nasty query.<\/p>\n<p>Another cool feature is that in addition to the web interface, SQLFormat also provides an <a href=\"http:\/\/sqlformat.org\/api\/\" target=\"_blank\">API<\/a>. Or, if you want, you can even download the <a href=\"http:\/\/sqlformat.org\/source\/\" target=\"_blank\">Python module<\/a> that powers this service to use it in your own applications!<\/p>\n<p>Even though I already have a formatting tool installed in SSMS, I&#8217;m adding\u00a0<a href=\"http:\/\/sqlformat.org\/\" target=\"_blank\">SQLFormat<\/a>\u00a0to my list of cool tools and definitely see myself using it some.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I stumbled upon this last week and thought I would share it. \u00a0SQLFormat is a free online formatter for SQL statements. \u00a0It&#8217;s pretty straight forward and easy to use. \u00a0You &#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[7],"tags":[16],"class_list":["post-189","post","type-post","status-publish","format-standard","hentry","category-tools","tag-quickies"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Online SQL Formatting Service - SQL Nuggets<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Online SQL Formatting Service - SQL Nuggets\" \/>\n<meta property=\"og:description\" content=\"I stumbled upon this last week and thought I would share it. \u00a0SQLFormat is a free online formatter for SQL statements. \u00a0It&#8217;s pretty straight forward and easy to use. \u00a0You ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Nuggets\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-29T14:06:55+00:00\" \/>\n<meta name=\"author\" content=\"Eric Cobb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cfgears\" \/>\n<meta name=\"twitter:site\" content=\"@sqlnugg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Eric Cobb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/online-sql-formatting-service\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/online-sql-formatting-service\\\/\"},\"author\":{\"name\":\"Eric Cobb\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\"},\"headline\":\"Online SQL Formatting Service\",\"datePublished\":\"2015-12-29T14:06:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/online-sql-formatting-service\\\/\"},\"wordCount\":141,\"commentCount\":2,\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"keywords\":[\"Quickies\"],\"articleSection\":[\"Tools\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlnuggets.com\\\/online-sql-formatting-service\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/online-sql-formatting-service\\\/\",\"url\":\"https:\\\/\\\/www.sqlnuggets.com\\\/online-sql-formatting-service\\\/\",\"name\":\"Online SQL Formatting Service - SQL Nuggets\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\"},\"datePublished\":\"2015-12-29T14:06:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/online-sql-formatting-service\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlnuggets.com\\\/online-sql-formatting-service\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlnuggets.com\\\/online-sql-formatting-service\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Online SQL Formatting Service\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#website\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"name\":\"SQL Nuggets\",\"description\":\"Nuggets Of SQL Server Knowledge\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/www.sqlnuggets.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#organization\",\"name\":\"SQL Nuggets\",\"url\":\"http:\\\/\\\/www.sqlnuggets.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlnuggets.com\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/website-logo.jpg\",\"width\":320,\"height\":54,\"caption\":\"SQL Nuggets\"},\"image\":{\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/sqlnugg\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ericcobb\\\/\"]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.sqlnuggets.com\\\/#\\\/schema\\\/person\\\/210536254addbc1b9d2d95dc1448b38a\",\"name\":\"Eric Cobb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg\",\"caption\":\"Eric Cobb\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/cfgears\"],\"url\":\"https:\\\/\\\/sqlnuggets.com\\\/author\\\/eric-cobb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Online SQL Formatting Service - SQL Nuggets","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:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/","og_locale":"en_US","og_type":"article","og_title":"Online SQL Formatting Service - SQL Nuggets","og_description":"I stumbled upon this last week and thought I would share it. \u00a0SQLFormat is a free online formatter for SQL statements. \u00a0It&#8217;s pretty straight forward and easy to use. \u00a0You ...","og_url":"https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/","og_site_name":"SQL Nuggets","article_published_time":"2015-12-29T14:06:55+00:00","author":"Eric Cobb","twitter_card":"summary_large_image","twitter_creator":"@cfgears","twitter_site":"@sqlnugg","twitter_misc":{"Written by":"Eric Cobb","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/#article","isPartOf":{"@id":"https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/"},"author":{"name":"Eric Cobb","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a"},"headline":"Online SQL Formatting Service","datePublished":"2015-12-29T14:06:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/"},"wordCount":141,"commentCount":2,"publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"keywords":["Quickies"],"articleSection":["Tools"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/","url":"https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/","name":"Online SQL Formatting Service - SQL Nuggets","isPartOf":{"@id":"http:\/\/www.sqlnuggets.com\/#website"},"datePublished":"2015-12-29T14:06:55+00:00","breadcrumb":{"@id":"https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlnuggets.com\/online-sql-formatting-service\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.sqlnuggets.com\/"},{"@type":"ListItem","position":2,"name":"Online SQL Formatting Service"}]},{"@type":"WebSite","@id":"http:\/\/www.sqlnuggets.com\/#website","url":"http:\/\/www.sqlnuggets.com\/","name":"SQL Nuggets","description":"Nuggets Of SQL Server Knowledge","publisher":{"@id":"http:\/\/www.sqlnuggets.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.sqlnuggets.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/www.sqlnuggets.com\/#organization","name":"SQL Nuggets","url":"http:\/\/www.sqlnuggets.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/","url":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","contentUrl":"https:\/\/sqlnuggets.com\/wp-content\/uploads\/2023\/11\/website-logo.jpg","width":320,"height":54,"caption":"SQL Nuggets"},"image":{"@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/sqlnugg","https:\/\/www.linkedin.com\/in\/ericcobb\/"]},{"@type":"Person","@id":"http:\/\/www.sqlnuggets.com\/#\/schema\/person\/210536254addbc1b9d2d95dc1448b38a","name":"Eric Cobb","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","url":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3ca1fc0c7054a668e048f09d412cd4ebf89833c4630fbbfccca78a0678a6bdc2?s=96&d=mm&r=pg","caption":"Eric Cobb"},"sameAs":["https:\/\/x.com\/cfgears"],"url":"https:\/\/sqlnuggets.com\/author\/eric-cobb\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pdyDvE-33","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1107,"url":"https:\/\/sqlnuggets.com\/sql-server-metrics-pack-update-september-2019\/","url_meta":{"origin":189,"position":0},"title":"SQL Server Metrics Pack Update &#8211; September 2019","author":"Eric Cobb","date":"September 20, 2019","format":false,"excerpt":"This morning I updated the Index Metrics piece of SQL Server Metrics Pack. This update mainly introduced some new functionality, with a few minor bug fixes. The two big enhancements are the capability to generate and store CREATE INDEX scripts and support for Columnstore indexes. Creating index scripts seems pretty\u2026","rel":"","context":"In &quot;Indexes&quot;","block_context":{"text":"Indexes","link":"https:\/\/sqlnuggets.com\/category\/indexes\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2017\/07\/binary-797263_1280-e1502824772680.jpg?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":112,"url":"https:\/\/sqlnuggets.com\/useful-tools-sp_whoisactive\/","url_meta":{"origin":189,"position":1},"title":"Useful Tools: sp_whoisactive","author":"Eric Cobb","date":"July 15, 2015","format":false,"excerpt":"One incredibly useful SQL Server tool that I often forget about is Adam Machanic's\u00a0sp_whoisactive\u00a0procedure. \u00a0The reason I say I forget about it is that it is not something that I use every day, it's one of those tools that sits quietly in the background waiting until you need it. \u00a0But\u2026","rel":"","context":"In &quot;Tools&quot;","block_context":{"text":"Tools","link":"https:\/\/sqlnuggets.com\/category\/tools\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":322,"url":"https:\/\/sqlnuggets.com\/getting-alerts-from-sql-sentry-when-you-dont-have-email\/","url_meta":{"origin":189,"position":2},"title":"Getting Alerts From SQL Sentry When You Don&#8217;t Have Email","author":"Eric Cobb","date":"February 7, 2017","format":false,"excerpt":"I use SentryOne's SQL Sentry for my SQL Server monitoring, and it does an excellent job. \u00a0However I recently had a situation where I was unable to get email alerts from SQL Sentry. \u00a0This was by no fault of SQL Sentry, our email sever was down so I couldn't get\u2026","rel":"","context":"In &quot;Monitoring&quot;","block_context":{"text":"Monitoring","link":"https:\/\/sqlnuggets.com\/category\/monitoring\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":270,"url":"https:\/\/sqlnuggets.com\/survey-results-from-my-adobe-coldfusion-summit-2016-session\/","url_meta":{"origin":189,"position":3},"title":"Survey Results From My Adobe ColdFusion Summit 2016 Session","author":"Eric Cobb","date":"October 26, 2016","format":false,"excerpt":"One of the really cool things that Adobe did at this year's ColdFusion Summit was to have a mobile app for the conference that allowed attendees to rate sessions and offer feedback. \u00a0This is a really great feature, as it allows people to give their opinions and thoughts on sessions\u2026","rel":"","context":"In &quot;Conferences&quot;","block_context":{"text":"Conferences","link":"https:\/\/sqlnuggets.com\/category\/conferences\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":86,"url":"https:\/\/sqlnuggets.com\/standalone-sql-server-management-studio\/","url_meta":{"origin":189,"position":4},"title":"Standalone SQL Server Management Studio","author":"Eric Cobb","date":"July 6, 2015","format":false,"excerpt":"Microsoft has released a new standalone version of\u00a0SQL Server Management Studio (SSMS). \u00a0As with previous versions of SSMS, you still get it bundled with your SQL Server install, but\u00a0with this new release we now also have the option of downloading SSMS separately via its own lightweight installer. One of the\u2026","rel":"","context":"In &quot;Tools&quot;","block_context":{"text":"Tools","link":"https:\/\/sqlnuggets.com\/category\/tools\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/sqlnuggets.com\/wp-content\/uploads\/2015\/07\/Microsoft-SQL-Server-e1436208354414.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":93,"url":"https:\/\/sqlnuggets.com\/sql-server-maintenance-scripts\/","url_meta":{"origin":189,"position":5},"title":"SQL Server Maintenance Scripts","author":"Eric Cobb","date":"July 9, 2015","format":false,"excerpt":"When it comes to everyday routine maintenance of your SQL Server databases, you can't beat Ola Hallengren's\u00a0SQL Server Maintenance Solution. \u00a0Focusing on\u00a0SQL Server Backups,\u00a0SQL Server Integrity Checks, and SQL Server Index and Statistics Maintenance, it\u00a0has pretty much become the go-to\u00a0maintenance solution for many SQL Server database administrators. \u00a0We have it\u2026","rel":"","context":"In &quot;Tools&quot;","block_context":{"text":"Tools","link":"https:\/\/sqlnuggets.com\/category\/tools\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/189","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/comments?post=189"}],"version-history":[{"count":0,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/posts\/189\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/media?parent=189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/categories?post=189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlnuggets.com\/wp-json\/wp\/v2\/tags?post=189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}