{"id":3471,"date":"2022-04-22T23:06:34","date_gmt":"2022-04-23T07:06:34","guid":{"rendered":"https:\/\/www.gudusoft.com\/?p=3471"},"modified":"2022-04-22T23:13:36","modified_gmt":"2022-04-23T07:13:36","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":"

\uc5c5\ub370\uc774\ud2b8\ub41c \uc815\ubcf4(2022)<\/h3>\n

\uc774 \uae00\uc740 2006\ub144\uc5d0 \uc4f0\uc5ec\uc9c4 \uae00\uc785\ub2c8\ub2e4. \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 \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. \uc989\uac01\uc801\uc778 SQL \ud3ec\ub9e4\ud130.<\/a><\/p>\n

\uc18c\uac1c<\/h3>\n

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

\ucf54\ub4dc \uc0ac\uc6a9<\/h3>\n

\uc6f9 \uc11c\ube44\uc2a4 www.gudusoft.com<\/a> 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

  SQL\uc744 \uc544\ub984\ub2f5\uac8c \ud558\ub2e4 <\/code><\/pre>\n
1\ub2e8\uacc4: \ud504\ub85d\uc2dc \ud074\ub798\uc2a4 \ube4c\ub4dc<\/h4>\n
\ub2e4\uc74c\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4\u2026<\/p>\n
C:>wsdl.exe http:\/\/www.gudusoft.com\/SQLFormatterWebService.wsdl<\/code><\/pre>\n
\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
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
2\ub2e8\uacc4: \ud504\ub85d\uc2dc \ud074\ub798\uc2a4 \ucef4\ud30c\uc77c<\/h4>\n
\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
C:>csc \/t:\ub77c\uc774\ube0c\ub7ec\ub9ac c:SQLFormatterWebService.cs<\/code><\/pre>\n
\uc774\ub85c \uc778\ud574 SQLFormatterWebService.dll\uc774\ub77c\ub294 \uc0c8 \ud30c\uc77c\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/p>\n
3\ub2e8\uacc4: ASP.NET \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub9cc\ub4e4\uae30<\/h4>\n
\uc774 \uc560\ud50c\ub9ac\ucf00\uc774\uc158(sqlformatter.aspx)\uc740 SQL Formatter \uc6f9 \uc11c\ube44\uc2a4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n
<%@Assembly Name="SQLFormatterWebService" %>\r\n\r\n<html>\r\n   <head>\r\n      <title>SQL Formatter \uc6f9 \uc11c\ube44\uc2a4 \ub370\ubaa8 <\/title>\r\n   <\/head>\r\n\r\n   <body>\r\n    <form runat="server" action="">\r\n          <asp:textbox id="inputsql" text="select f1,f2 from t1"\r\n                       textmode="MultiLine" rows="10" columns="60"\r\n                       wrap="False" runat="server"\/>\r\n   <br><asp:button text=" Format Code " onclick="onFormat"\r\n                          runat="server" \/>\r\n          <br><asp:textbox id="outputsql" textmode="MultiLine"\r\n                           rows="10" columns="60" wrap="False"\r\n                           runat="server"\/>\r\n\r\n   <input type="hidden" name="trp-form-language" value="ko"\/><\/form>\r\n   <\/body>\r\n<\/html>\r\n\r\n<script language="c#" runat="server">\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("mssql",inputsql.Text);\r\n}\r\n<\/script><\/code><\/pre>\n
4\ub2e8\uacc4: IIS \uc11c\ubc84\uc5d0\uc11c \uc774 ASP.NET \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc124\uc815<\/h4>\n