{"id":11617,"date":"2016-02-15T12:01:01","date_gmt":"2016-02-15T03:01:01","guid":{"rendered":"http:\/\/a-tak.com\/blog\/?page_id=11617"},"modified":"2019-11-22T12:32:55","modified_gmt":"2019-11-22T03:32:55","slug":"sql-server","status":"publish","type":"page","link":"https:\/\/a-tak.com\/blog\/tips\/sql-server\/","title":{"rendered":"SQL Server"},"content":{"rendered":"<div id=\"advads-3109185022\" class=\"advads-before-content-placement advads-entity-placement\" style=\"margin-left: auto;margin-right: auto;text-align: center;\"><div class=\"advads-adlabel\">\u5e83\u544a<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-7585646298782746\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:300px;height:250px;\" \ndata-ad-client=\"ca-pub-7585646298782746\" \ndata-ad-slot=\"6112122906\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div><p>FrontPage<\/p>\n<ul>\n<li>SQLServer Tips\u4e00\u89a7 [#edb2c2b2]<\/li>\n<\/ul>\n<ol>\n<li>ls<\/li>\n<\/ol>\n<ul>\n<li>\u65e7Tips(\u6574\u7406\u3057\u3066\u3044\u306a\u3044\u306e\u3067\u30d5\u30e9\u30c3\u30c8\u306a\u72b6\u614b\u3067\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059) [#s9ef7244]<\/li>\n<li>\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u7d4c\u7531\u3067MSDE\u306b\u63a5\u7d9a\u3067\u304d\u306a\u3044 [#pcd5ca8d]<\/li>\n<\/ul>\n<p>\u3044\u304f\u3064\u304b\u539f\u56e0\u304c\u3042\u308b\u3068\u601d\u3046\u304c\u3001 \u307e\u305a\u306f\u30b5\u30fc\u30d0\u30fc\u3078TELNET\u30671433\u756a\u306b\u63a5\u7d9a\u3057\u3066\u307f\u308b\u3002 \u63a5\u7d9a\u3067\u304d\u306a\u304b\u3063\u305f\u3089\u3001\u901a\u4fe1\u81ea\u4f53\u5931\u6557\u3057\u3066\u3044\u308b\u3002<\/p>\n<p>\u4eca\u56de\u306fMSDE\u5074\u3067TCP\/IP\u306e\u63a5\u7d9a\u3092\u53d7\u3051\u4ed8\u3051\u3066\u3044\u306a\u3044\u8a2d\u5b9a\u306b\u306a\u3063\u3066\u3044\u305f\u3002 \u8a2d\u5b9a\u306f\u4ee5\u4e0b\u306e\u30c4\u30fc\u30eb\u3067\u884c\u3046(\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5834\u6240\u306b\u3088\u308a\u30d1\u30b9\u306f\u5909\u308f\u308b)<\/p>\n<p><code>C\\Program\u00a0Files\\Microsoft\u00a0SQL\u00a0Server\\80\\Tools\\Binn\\SVRNETCN.exe&quot;<\/code><\/p>\n<p>\u3053\u306e\u30c4\u30fc\u30eb\u3092\u8d77\u52d5\u3057\u3066TCP\/IP\u3092\u6709\u52b9\u306b\u3057\u3066\u3084\u308b\u3053\u3068\u3067\u63a5\u7d9a\u53ef\u80fd\u306b\u306a\u3063\u305f\u3002<\/p>\n<ul>\n<li>Transact-SQL [#r8cdaea3]\n<ul>\n<li>\u30c6\u30fc\u30d6\u30eb\u540d\u306e\u4e00\u89a7\u8868\u793a [#q286eeb7]<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>select name from sysobjects where xtype = &#8216;U&#8217;<\/p>\n<ul>\n<li>\n<ul>\n<li>\u30c6\u30fc\u30d6\u30eb\u306e\u5b9a\u7fa9\u8868\u793a [#a0f35f24]<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>exec sp_help [\u30c6\u30fc\u30d6\u30eb\u540d]<\/p>\n<ul>\n<li>\n<ul>\n<li>SUM\u7b49\u306e\u96c6\u8a08\u95a2\u6570\u3092\u4f7f\u3046\u3068\u304d\u306e\u6ce8\u610f\u70b9(\u3084\u3084\u672a\u78ba\u8a8d\u306e\u60c5\u5831) [#cc05f528]<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u53e4\u304f\u3066\u7533\u3057\u8a33\u306a\u3044\u304cDAO2.7\u306e\u8a71\u3002 SUM()\u306a\u3069\u3092\u4f7f\u3063\u3066\u96c6\u8a08\u5024\u3092\u53d6\u3063\u305f\u5834\u5408\u306b\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u5024\u3092\u5217\u540d\u3067\u6307\u5b9a\u3057\u3066\u30ec\u30b3\u30fc\u30c9\u30bb\u30c3\u30c8\u304b\u3089\u53d6\u5f97\u3059\u308b\u5834\u5408\u3001 AS\u3092\u6307\u5b9a\u3057\u3066\u5225\u540d\u3092\u660e\u793a\u7684\u306b\u6307\u5b9a\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u3002<\/p>\n<p><code>SELECT\u00a0SUM(Kingaku)\u00a0AS\u00a0Kingaku\u00a0FROM\u00a0URIAGE\u00a0GROUP\u00a0BY\u00a0CustomerID<\/code><\/p>\n<p>\u4ee5\u4e0b\u306e\u3088\u3046\u306bAS\u3067\u5225\u540d\u3092\u6307\u5b9a\u3057\u306a\u3044\u5834\u5408\u306f\u30af\u30a8\u30ea\u30a2\u30ca\u30e9\u30a4\u30b6\u3067\u52d5\u304b\u3059\u3068(\u5217\u540d\u306a\u3057)\u3068\u3044\u3046\u72b6\u614b\u306b\u306a\u308b\u3002<\/p>\n<p><code>SELECT\u00a0SUM(Kingaku)\u00a0FROM\u00a0URIAGE\u00a0GROUP\u00a0BY\u00a0CustomerID<\/code><\/p>\n<p>\u56f0\u3063\u305f\u3053\u3068\u306bDAO\u3067\u306f(ADO\u3068\u304b\u306f\u8a66\u3057\u3066\u306a\u3044)\u3053\u306e\u72b6\u614b\u3067\u300cKingaku\u300d\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u53d6\u5f97\u3057\u3088\u3046\u3068\u3057\u3066\u3082 \u7279\u306b\u30a8\u30e9\u30fc\u306b\u306a\u3089\u305a\u306b0\u304c\u8fd4\u3063\u3066\u304f\u308b\u3002<\/p>\n<ul>\n<li>\n<ul>\n<li>\u30b3\u30e1\u30f3\u30c8\u65b9\u6cd5 [#q286eeb7]<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u4e00\u884c\u30b3\u30e1\u30f3\u30c8\u306f\u300c-\u300d\u3092\uff12\u56de\u9023\u7d9a\u3067\u5165\u529b\u3059\u308b\u3068\u306a\u308a\u307e\u3059<\/p>\n<p><code>--\u00a0SELECT\u00a0SUM(Kingaku)\u00a0FROM\u00a0URIAGE\u00a0GROUP\u00a0BY\u00a0CustomerID<\/code><\/p>\n<p>\u8907\u6570\u884c\u30b3\u30e1\u30f3\u30c8\u306f\u300c\/* \u30fb\u30fb\u30fb *\/\u300d\u3067\u3059\u306d<\/p>\n<p><code>\/*<\/code><br \/>\n<code>\u3000SELECT\u00a0SUM(Kingaku)\u00a0FROM\u00a0URIAGE\u00a0GROUP\u00a0BY\u00a0CustomerID<\/code><br \/>\n<code>\u3000SELECT\u00a0MAX(Kingaku)\u00a0FROM\u00a0URIAGE\u00a0GROUP\u00a0BY\u00a0CustomerID<\/code><br \/>\n<code>*\/<\/code><\/p>\n<p>\u5fdc\u7528\u3068\u3057\u3066<\/p>\n<p><code>\u00a0\u00a0SELECT\u00a0<\/code><br \/>\n<code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SUM(Kingaku)\u00a0\u00a0--\u00a0\u7dcf\u91d1\u984d\u3067\u3059\uff01\uff01<\/code><br \/>\n<code>\u00a0\u00a0FROM\u00a0<\/code><br \/>\n<code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0URIAGE\u00a0GROUP\u00a0BY\u00a0CustomerID<\/code><\/p>\n<ul>\n<li>VB\u3068\u306e\u95a2\u9023 [#pa9c357f]\n<ul>\n<li>SQL\u6587\u306e\u66f8\u304d\u65b9\u306e\u30b3\u30c4 [#fd43f6f0]<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u305d\u3082\u305d\u3082\u3053\u308c\u304c\u3088\u3044\u306e\u304b\u306f\u5225\u3068\u3057\u3066\u3001\u3060\u3089\u30fc\u3068SQL\u3092PG\u306b\u57cb\u3081\u8fbc\u3093\u3067\u3057\u307e\u3046\u5834\u5408\u306f\u3001\u308f\u304b\u308a\u3084\u3059\u304f\u306a\u308b\u3002<\/p>\n<p>\u3000sql = &quot;INSERT INTO &quot; &amp; pstrTableName &amp; &quot; (&quot; \u3000sql = sql &amp; &quot;[CustomerName]&quot; \u3000sqlv = sqlv &amp; CStr(.strCustomerName) &amp; &quot; &quot; \u3000 \u3000GetSQL = sql &amp; &quot;) VALUES (&quot; &amp; sqlv &amp; &quot;);&quot;<\/p>\n<p>\u307f\u305f\u3044\u306a\u611f\u3058\u3067\u5217\u3068VALUE\u3092\u4e26\u3079\u3066\u66f8\u3044\u3066\u5f8c\u3067\u304c\u3063\u3061\u3083\u3093\u3053\u3059\u308b\u3002<\/p>\n<ul>\n<li>Enterprise Manager [#n098f108]\n<ul>\n<li>\u30c6\u30fc\u30d6\u30eb\u306e\u7de8\u96c6\u753b\u9762\u3067NULL\u3092\u30d5\u30a3\u30fc\u30eb\u30c9\u306b\u5165\u308c\u308b [#ucd4f47c]<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>ctrl + 0\u3092\u62bc\u3059\u3068\u3001NULL\u5024\u304c\u5165\u308b<\/p><div id=\"advads-1489305661\" class=\"advads-content-placement-after-3rd-paragraph advads-entity-placement\" style=\"margin-left: auto;margin-right: auto;text-align: center;\"><div class=\"advads-adlabel\">\u5e83\u544a<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-7585646298782746\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:300px;height:250px;\" \ndata-ad-client=\"ca-pub-7585646298782746\" \ndata-ad-slot=\"6112122906\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>FrontPage SQLServer Tips\u4e00\u89a7 [#edb2c2b2] ls \u65e7Tips(\u6574\u7406\u3057\u3066\u3044\u306a\u3044\u306e\u3067\u30d5\u30e9\u30c3\u30c8\u306a\u72b6\u614b\u3067\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059) [#s9ef7244] \u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u7d4c\u7531\u3067MSDE\u306b\u63a5\u7d9a\u3067\u304d\u306a\u3044 [# [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":11574,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"sidebar-page.php","meta":{"_crdt_document":"","footnotes":""},"class_list":["post-11617","page","type-page","status-publish","hentry"],"aioseo_notices":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/pages\/11617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/comments?post=11617"}],"version-history":[{"count":0,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/pages\/11617\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/pages\/11574"}],"wp:attachment":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/media?parent=11617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}