{"id":3471,"date":"2022-04-22T23:06:34","date_gmt":"2022-04-23T07:06:34","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=3471"},"modified":"2026-07-11T22:56:12","modified_gmt":"2026-07-12T06:56:12","slug":"sql-formatter-web-service","status":"publish","type":"post","link":"https:\/\/www.gudusoft.com\/ko\/sql-%ed%8f%ac%eb%a7%a4%ed%84%b0-%ec%9b%b9-%ec%84%9c%eb%b9%84%ec%8a%a4\/","title":{"rendered":"SQL \ud3ec\ub9e4\ud130 \uc6f9 \uc11c\ube44\uc2a4"},"content":{"rendered":"<p><\/p>\n\n\n<h3 class=\"wp-block-heading\">\uc5c5\ub370\uc774\ud2b8\ub41c \uc815\ubcf4(2022)<\/h3>\n\n\n\n<p>\uc774 \uae00\uc740 2006\ub144\uc5d0 \uc4f0\uc5ec\uc9c4 \uae00\uc785\ub2c8\ub2e4. <a href=\"https:\/\/www.codeguru.com\/csharp\/sql-formatter-web-service\/\" class=\"rank-math-link\">\ucf54\ub4dc\uad6c\ub8e8<\/a> , \uc774 \ubb38\uc11c\uc5d0 \uc0ac\uc6a9\ub41c \uae30\uc220\uc740 \uc624\ub798\ub418\uc5c8\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Java \ub610\ub294 Dotnet \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc88b\uc740 SQL \ud3ec\ub9e4\ud130\ub97c \ucc3e\uace0 \uc788\ub2e4\uba74 <a href=\"https:\/\/sqlparser.com\/features\/sql-formatter.php\" class=\"rank-math-link\">\uc774 \ud398\uc774\uc9c0\ub97c \ud655\uc778\ud558\uc138\uc694<\/a> \ub300\uc2e0. \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud6cc\ub96d\ud55c SQL \ucffc\ub9ac \ud3ec\ub9f7\ud130\ub97c \ucc3e\uace0 \uc788\ub2e4\uba74 \ub2e4\uc74c\uc744 \ud655\uc778\ud558\uc138\uc694. <a href=\"https:\/\/www.dpriver.com\/pp\/sqlformat.htm\" class=\"rank-math-link\">\uc989\uac01\uc801\uc778 SQL \ud3ec\ub9e4\ud130.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc18c\uac1c<\/h3>\n\n\n\n<p>SQL \ucf54\ub4dc\ub294 \ud3ec\ub9f7\ud305\ub418\uc5b4 \uc788\uc73c\uba74 \ud6e8\uc52c \ub354 \uc27d\uace0 \ube60\ub974\uac8c \uc77d\uace0 \uc774\ud574\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\ud788 \uae38\uace0 \ubcf5\uc7a1\ud55c SQL \ubb38\uc744 \ub2e4\ub8e8\uac70\ub098 \ub2e4\ub978 \uc0ac\ub78c\uc758 \ucf54\ub4dc\ub97c \uc77d\uc5b4\uc57c \ud560 \ub54c \ub354\uc6b1 \uadf8\ub807\uc2b5\ub2c8\ub2e4. \uc81c\ub300\ub85c \ub41c SQL \ud3ec\ub9f7\ud130\ub97c \uc791\uc131\ud558\ub294 \uac83\uc740 \uc26c\uc6b4 \uc77c\uc774 \uc544\ub2d9\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 C#\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc628\ub77c\uc778 SQL \ud3ec\ub9f7\ud130\ub97c \ub9cc\ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc740 \ud3ec\ub9f7\ud305\ub418\uc9c0 \uc54a\uc740 SQL\uc744 \uc11c\ubc84\ub85c \uc804\uc1a1\ud558\uace0, \uc11c\ubc84\ub294 \ud3ec\ub9f7\ud305\ub41c SQL\uc744 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc73c\ub85c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ucf54\ub4dc \uc0ac\uc6a9<\/h3>\n\n\n\n<p>\uc6f9 \uc11c\ube44\uc2a4&nbsp;<a href=\"https:\/\/www.gudusoft.com\/ko\/\">www.gudusoft.com<\/a>&nbsp;SQL \ucf54\ub4dc\ub97c \ubc1b\uc544\uc11c \ud615\uc2dd\ud654\ub41c SQL\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\uc11c WSDL\uc744 \uc0b4\ud3b4\ubcf4\uc138\uc694. \uc911\uc694\ud55c \ubd80\ubd84\uc740 \uc544\ub798\uc5d0 \ub098\uc640 \uc788\uc73c\uba70, beautifySql \uba54\uc11c\ub4dc\ub97c \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SQL\uc744 \uc544\ub984\ub2f5\uac8c \ud558\ub2e4 <\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">1\ub2e8\uacc4: \ud504\ub85d\uc2dc \ud074\ub798\uc2a4 \ube4c\ub4dc<\/h4>\n\n\n\n<p>\ub2e4\uc74c\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4\u2026<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>C:&gt;wsdl.exe https:\/\/www.gudusoft.com\/SQLFormatterWebService.wsdl<\/code><\/pre>\n\n\n\n<p>\u2026 SQLFormatterWebService\ub77c\ub294 \ud074\ub798\uc2a4\ub97c \ud3ec\ud568\ud558\ub294 C# \ud30c\uc77c\uc778 SQLFormatterWebService.cs\uac00 \uc0dd\uc131\ub429\ub2c8\ub2e4. \uc774 \ud074\ub798\uc2a4\uc758 \uba54\uc11c\ub4dc\uac00 WSDL \ud30c\uc77c\uc5d0 \uc790\uc138\ud788 \uc124\uba85\ub41c \uba54\uc11c\ub4dc\uc640 \uc5b4\ub5bb\uac8c \uc77c\uce58\ud558\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uc138\uc694. \ud2b9\ud788 \ub2e4\uc74c \uba54\uc11c\ub4dc\ub294 \ub354\uc6b1 \uadf8\ub807\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>public string beautifySql(string dbvendor, string sql) dbvendor: \ud604\uc7ac MSSQL, Oracle, MySQL, Access\ub97c \uc9c0\uc6d0\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 SQL \ubc29\uc5b8\uc785\ub2c8\ub2e4. sql: SQL \ucf54\ub4dc\ub97c \ud3ec\ub9f7\ud574\uc57c \ud569\ub2c8\ub2e4.<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">2\ub2e8\uacc4: \ud504\ub85d\uc2dc \ud074\ub798\uc2a4 \ucef4\ud30c\uc77c<\/h4>\n\n\n\n<p>\ub2e4\uc74c\uc73c\ub85c, \uc790\ub3d9 \uc0dd\uc131\ub41c \ud30c\uc77c\uc744 \ucef4\ud30c\uc77c\ud574\uc57c \ud569\ub2c8\ub2e4. \uc774 \ud30c\uc77c\uc5d0\ub294 \uc9c4\uc785\uc810\uc774 \uc5c6\uc73c\ubbc0\ub85c \ub77c\uc774\ube0c\ub7ec\ub9ac\ub85c \ube4c\ub4dc\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>C:&gt;csc \/t:\ub77c\uc774\ube0c\ub7ec\ub9ac c:SQLFormatterWebService.cs<\/code><\/pre>\n\n\n\n<p>\uc774\ub85c \uc778\ud574 SQLFormatterWebService.dll\uc774\ub77c\ub294 \uc0c8 \ud30c\uc77c\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">3\ub2e8\uacc4: ASP.NET \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub9cc\ub4e4\uae30<\/h4>\n\n\n\n<p>\uc774 \uc560\ud50c\ub9ac\ucf00\uc774\uc158(sqlformatter.aspx)\uc740 SQL Formatter \uc6f9 \uc11c\ube44\uc2a4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;%@Assembly Name=&quot;SQLFormatterWebService&quot; %&gt;\r\n\r\n&lt;html&gt;\r\n   &lt;head&gt;\r\n      &lt;title&gt;SQL Formatter \uc6f9 \uc11c\ube44\uc2a4 \ub370\ubaa8 &lt;\/title&gt;\r\n   &lt;\/head&gt;\r\n\r\n   &lt;body&gt;\r\n    &lt;form runat=&quot;server&quot; action=&quot;&quot;&gt;\r\n          &lt;asp:textbox id=&quot;inputsql&quot; text=&quot;select f1,f2 from t1&quot;\r\n                       textmode=&quot;MultiLine&quot; rows=&quot;10&quot; columns=&quot;60&quot;\r\n                       wrap=&quot;False&quot; runat=&quot;server&quot;\/&gt;\r\n   &lt;br&gt;&lt;asp:button text=&quot; Format Code &quot; onclick=&quot;onFormat&quot;\r\n                          runat=&quot;server&quot; \/&gt;\r\n          &lt;br&gt;&lt;asp:textbox id=&quot;outputsql&quot; textmode=&quot;MultiLine&quot;\r\n                           rows=&quot;10&quot; columns=&quot;60&quot; wrap=&quot;False&quot;\r\n                           runat=&quot;server&quot;\/&gt;\r\n\r\n   &lt;input type=&quot;hidden&quot; name=&quot;trp-form-language&quot; value=&quot;ko&quot;\/&gt;&lt;\/form&gt;\r\n   &lt;\/body&gt;\r\n&lt;\/html&gt;\r\n\r\n&lt;script language=&quot;c#&quot; runat=&quot;server&quot;&gt;\r\n   void onFormat (Object sender, EventArgs e)\r\n{\r\n      SQLFormatterWebService sqlformatter =\r\n         new SQLFormatterWebService();\r\n      outputsql.Text =\r\n         sqlformatter.beautifySql(&quot;mssql&quot;,inputsql.Text);\r\n}\r\n&lt;\/script&gt;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">4\ub2e8\uacc4: IIS \uc11c\ubc84\uc5d0\uc11c \uc774 ASP.NET \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc124\uc815<\/h4>\n\n\n\n<ul><li>4.1 \uc608\ub97c \ub4e4\uc5b4 sqlformatter.aspx\ub97c wwwroot \uc544\ub798\uc5d0 \ub123\uc2b5\ub2c8\ub2e4.<\/li><li>4.2 SQLFormatterWebService.dll\uc744 wwwroot \uc544\ub798\uc758 bin \ub514\ub809\ud1a0\ub9ac\uc5d0 \ub123\uc2b5\ub2c8\ub2e4.<\/li><li>4.3 \ube0c\ub77c\uc6b0\uc800\ub97c \uc5f4\uace0 http:\/\/localhost\/sqlformatter.aspx\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/li><\/ul>\n\n\n\n<p>\uc990\uaca8\ubcf4\uc138\uc694!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uad00\uc2ec \uc9c0\uc810<\/h3>\n\n\n\n<p>\uc774 SQL \ud3ec\ub9e4\ud130 \uc6f9 \uc11c\ube44\uc2a4\ub294 \ud2b9\ud788 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub828 \uc6f9\uc0ac\uc774\ud2b8 \ud3ec\ub7fc\uc5d0\uc11c \ub110\ub9ac \uc0ac\uc6a9\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\ub4e4\uc774 \ud1a0\ub860\uc744 \uc704\ud574 \ub9ce\uc740 SQL \ucf54\ub4dc\ub97c \uc81c\ucd9c\ud558\ub294 \uacbd\uc6b0\uac00 \ub9ce\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \uc774 SQL \ucf54\ub4dc\ub97c \ud3ec\ub7fc\uc5d0 \uac8c\uc2dc\ud558\uae30 \uc804\uc5d0 \ud3ec\ub9f7\ud305\ud560 \uc218 \uc788\ub2e4\uba74 \uc88b\uc744 \uac83 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 SQL \ud3ec\ub9e4\ud130\uc5d0 \uad00\uc2ec\uc774 \uc788\ub294 \uacbd\uc6b0 \ub2e4\uc74c \uc0ac\uc774\ud2b8\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul><li>SQL \ud3ec\ub9e4\ud130 \uc6f9 \uc11c\ube44\uc2a4<\/li><li><a href=\"http:\/\/www.wangz.net\/gsqlparser\/sqlpp\/sqlformat.htm\">\ubb34\ub8cc \uc628\ub77c\uc778 SQL \ud3ec\ub9e4\ud130<\/a><\/li><li><a href=\"http:\/\/www.sqlparser.com\/\">SQL \ud3ec\ub9e4\ud130\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 SQL \ud30c\uc11c \uc5d4\uc9c4<\/a><\/li><\/ul>\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Updated Info (2022) This is an article written back in 2006 that was published on codeguru , and the technology used in this article may out of date. If you are looking for a good SQL formatter that can be used in your Java or Dotnet program, please check this page instead. If you are looking for a free while fantastic SQL query formatter, please check the Instant SQL formatter. Introduction SQL code is much easier and faster to read and understand when it is formatted, especially when it is a long and complicated SQL statement you are dealing with,\u2026<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"_links":{"self":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3471"}],"collection":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/comments?post=3471"}],"version-history":[{"count":5,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3471\/revisions"}],"predecessor-version":[{"id":6620,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/posts\/3471\/revisions\/6620"}],"wp:attachment":[{"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/media?parent=3471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/categories?post=3471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gudusoft.com\/ko\/wp-json\/wp\/v2\/tags?post=3471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}