{"id":13945,"date":"2021-05-13T06:00:00","date_gmt":"2021-05-12T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=13945"},"modified":"2021-02-24T10:11:51","modified_gmt":"2021-02-24T01:11:51","slug":"qgis-%e3%81%8b%e3%82%89-sql-server-%e3%81%b8%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92%e3%82%a2%e3%83%83%e3%83%97%e3%83%ad%e3%83%bc%e3%83%89%e3%81%99%e3%82%8b%e9%9a%9b%e3%81%ae%e5%8b%98%e6%89%80","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=13945","title":{"rendered":"QGIS \u304b\u3089 SQL Server \u3078\u30c7\u30fc\u30bf\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u969b\u306e\u52d8\u6240"},"content":{"rendered":"\n<p>\u3000QGIS \u304b\u3089 SQL Server 2008 R2 \u306b\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u969b\u306b\u306f Shape2SQL \u3068\u3044\u3046\u30c4\u30fc\u30eb\u3092\u4f7f\u3063\u305f\uff0e\u4fbf\u5229\u306a\u30c4\u30fc\u30eb\u3067\u306f\u3042\u308b\u304c\uff0c\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u306e\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u306e\u65e5\u672c\u8a9e\u304c\u6587\u5b57\u5316\u3051\u3059\u308b\u3068\u3044\u3046\u554f\u984c\u3092\u62b1\u3048\u3066\u304a\u308a\uff0c\u4f55\u3068\u304b\u306a\u3089\u306a\u3044\u304b\u3068\u8a66\u884c\u932f\u8aa4\u3057\u305f\u7d50\u679c\u3092\u5099\u5fd8\u9332\u3068\u3057\u3066\u6295\u7a3f\u3059\u308b\uff0e<\/p>\n<p><!--more--><\/p>\n<h2>\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u306f\u6587\u5b57\u5316\u3051\u3059\u308b<\/h2>\n<p>\u3000\u6700\u521d\uff0c\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u3092 Shift_JIS \u304b UTF8 \u304b\u3044\u305a\u308c\u304b\u3067\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308c\u3070\u89e3\u6c7a\u3059\u308b\u306e\u3067\u306f\u306a\u3044\u304b\u3068\u601d\u3063\u3066\u8a66\u3057\u305f\u306e\u3060\u304c\uff0c\u89e3\u6c7a\u3057\u306a\u304b\u3063\u305f\uff0e\u305d\u306e\u305f\u3081\uff0c\u5730\u7269\u3068\u305d\u308c\u4ee5\u5916\u306e\u5c5e\u6027\u30c7\u30fc\u30bf\u3092\u5206\u3051\u3066\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u65b9\u91dd\u306b\u5909\u66f4\u3057\u305f\uff0e<\/p>\n<h3>\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u306b\u306f ID \u304c\u5fc5\u8981<\/h3>\n<p>\u3000\u6b8b\u5ff5\u306a\u304c\u3089\uff0c\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u306b\u306f\u4e3b\u30ad\u30fc\u3068\u306a\u308b\u5c5e\u6027\u306f\u5b58\u5728\u3057\u306a\u3044\u305f\u3081\uff0c\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u8ffd\u52a0\u3057\u3066\u300c\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5c5e\u6027\u306e\u8ffd\u52a0\u300d\u304c\u5fc5\u8981\u306b\u306a\u308b\uff0e<\/p>\n<h3>\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5c5e\u6027\u306e\u8ffd\u52a0<\/h3>\n<p>\u3000\u300c\u30d7\u30ed\u30bb\u30b7\u30f3\u30b0\u30c4\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u300d\u304b\u3089\u300c\u30d9\u30af\u30bf\u30c6\u30fc\u30d6\u30eb\u300d\u300c\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5c5e\u6027\u306e\u8ffd\u52a0\u300d\u3078\u3068\u9032\u3080\uff0e<\/p>\n<figure id=\"attachment_13946\" aria-describedby=\"caption-attachment-13946\" style=\"width: 253px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/42.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13946\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/42.png\" alt=\"\u300c\u30d9\u30af\u30bf\u30c6\u30fc\u30d6\u30eb\u300d\u300c\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5c5e\u6027\u306e\u8ffd\u52a0\u300d\" width=\"253\" height=\"449\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/42.png 253w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/42-169x300.png 169w\" sizes=\"auto, (max-width: 253px) 100vw, 253px\" \/><\/a><figcaption id=\"caption-attachment-13946\" class=\"wp-caption-text\">\u300c\u30d9\u30af\u30bf\u30c6\u30fc\u30d6\u30eb\u300d\u300c\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5c5e\u6027\u306e\u8ffd\u52a0\u300d<\/figcaption><\/figure>\n<p>\u3000\u300c\u5c5e\u6027\u540d\u300d\u3068\u300c\u958b\u59cb\u5024\u300d\u3092\u6307\u5b9a\u3059\u308b\uff0e\u3053\u3053\u3067\u306f\u5c5e\u6027\u540d\u3092 ID \u3068\u3057\uff0c\u958b\u59cb\u5024\u3092 0 \u304b\u3089 1 \u306b\u5909\u66f4\u3057\u3066\u3044\u308b\uff0e\u300c\u30b0\u30eb\u30fc\u30d7\u5316\u306e\u305f\u3081\u306e\u5c5e\u6027\u300d\u306f\u3088\u304f\u5206\u304b\u3089\u306a\u3044\uff0e\u300c\u51fa\u529b\u30ec\u30a4\u30e4\u300d\u306f\u300c\u4e00\u6642\u30ec\u30a4\u30e4\u3092\u4f5c\u6210\u300d\u306e\u307e\u307e\u3067\u826f\u3044\u3060\u308d\u3046\uff0e<\/p>\n<p>\u3000\u300c\u5b9f\u884c\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_13947\" aria-describedby=\"caption-attachment-13947\" style=\"width: 663px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/43.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13947\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/43.png\" alt=\"\u300c\u5c5e\u6027\u540d\u300d\u3068\u300c\u958b\u59cb\u5024\u300d\u3092\u6307\u5b9a\" width=\"663\" height=\"547\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/43.png 663w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/43-300x248.png 300w\" sizes=\"auto, (max-width: 663px) 100vw, 663px\" \/><\/a><figcaption id=\"caption-attachment-13947\" class=\"wp-caption-text\">\u300c\u5c5e\u6027\u540d\u300d\u3068\u300c\u958b\u59cb\u5024\u300d\u3092\u6307\u5b9a<\/figcaption><\/figure>\n<p>\u3000\u300c\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5c5e\u6027\u306e\u8ffd\u52a0\u300d\u306e\u30ed\u30b0\u304c\u51fa\u529b\u3055\u308c\u308b\uff0e\u300c\u9589\u3058\u308b\u300d\u3067\u30c0\u30a4\u30a2\u30ed\u30b0\u3092\u629c\u3051\u308b\uff0e<\/p>\n<figure id=\"attachment_13948\" aria-describedby=\"caption-attachment-13948\" style=\"width: 663px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/44.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13948\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/44.png\" alt=\"\u300c\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5c5e\u6027\u306e\u8ffd\u52a0\u300d\u30ed\u30b0\" width=\"663\" height=\"547\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/44.png 663w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/44-300x248.png 300w\" sizes=\"auto, (max-width: 663px) 100vw, 663px\" \/><\/a><figcaption id=\"caption-attachment-13948\" class=\"wp-caption-text\">\u300c\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u5c5e\u6027\u306e\u8ffd\u52a0\u300d\u30ed\u30b0<\/figcaption><\/figure>\n<p>\u3000\u3053\u306e\u5f8c\uff0c\u8ffd\u52a0\u3055\u308c\u305f ID \u30d5\u30a3\u30fc\u30eb\u30c9\u306f\u300c\u5c5e\u6027\u306e\u30ea\u30d5\u30a1\u30af\u30bf\u30ea\u30f3\u30b0\u300d\u3067\u5148\u982d\u306b\u79fb\u52d5\u3057\u3066\u304a\u304f\uff0e<\/p>\n<h2>Shape2SQL \u3067\u7a7a\u9593\u30c7\u30fc\u30bf\u3092 SQL Server \u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9<\/h2>\n<p>\u3000Database Configuration \u306e Server name \u3092\u5165\u529b\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_13951\" aria-describedby=\"caption-attachment-13951\" style=\"width: 344px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/02-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13951\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/02-3.png\" alt=\"Database Configuration\u306eServer name\" width=\"344\" height=\"401\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/02-3.png 344w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/02-3-257x300.png 257w\" sizes=\"auto, (max-width: 344px) 100vw, 344px\" \/><\/a><figcaption id=\"caption-attachment-13951\" class=\"wp-caption-text\">Database Configuration\u306eServer name<\/figcaption><\/figure>\n<p>\u3000Database Configuration \u306e Server name \u3092\u5165\u529b\u3057\u305f\u3068\u3053\u308d\u3067\u3042\u308b\uff0eServer name \u306f SQL Server Management Studio \u306b\u304a\u3044\u3066\uff0c\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u306e\u30b5\u30fc\u30d0\u30fc\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3067\u78ba\u8a8d\u3067\u304d\u308b\uff0e<\/p>\n<figure id=\"attachment_13952\" aria-describedby=\"caption-attachment-13952\" style=\"width: 344px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/03-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13952\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/03-3.png\" alt=\"Database Configuration\u306eServer name\" width=\"344\" height=\"401\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/03-3.png 344w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/03-3-257x300.png 257w\" sizes=\"auto, (max-width: 344px) 100vw, 344px\" \/><\/a><figcaption id=\"caption-attachment-13952\" class=\"wp-caption-text\">Database Configuration\u306eServer name<\/figcaption><\/figure>\n<p>\u3000Database Configuration \u306e Select or enter a database name \u304b\u3089\u76ee\u7684\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u9078\u629e\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_13953\" aria-describedby=\"caption-attachment-13953\" style=\"width: 344px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/04-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13953\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/04-3.png\" alt=\"Database Configuration \u306e Select or enter a database name\" width=\"344\" height=\"401\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/04-3.png 344w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/04-3-257x300.png 257w\" sizes=\"auto, (max-width: 344px) 100vw, 344px\" \/><\/a><figcaption id=\"caption-attachment-13953\" class=\"wp-caption-text\">Database Configuration \u306e Select or enter a database name<\/figcaption><\/figure>\n<p>\u3000Database properties \u3067\u30b5\u30fc\u30d0\u30fc\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6307\u5b9a\u3057\u305f\u3068\u3053\u308d\u3067\u3042\u308b\uff0e<\/p>\n<figure id=\"attachment_13954\" aria-describedby=\"caption-attachment-13954\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/06-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13954\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/06-3.png\" alt=\"Database properties \u3067\u30b5\u30fc\u30d0\u30fc\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6307\u5b9a\u3057\u305f\u3068\u3053\u308d\" width=\"439\" height=\"466\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/06-3.png 439w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/06-3-283x300.png 283w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><figcaption id=\"caption-attachment-13954\" class=\"wp-caption-text\">Database properties \u3067\u30b5\u30fc\u30d0\u30fc\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6307\u5b9a\u3057\u305f\u3068\u3053\u308d<\/figcaption><\/figure>\n<p>\u3000\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u304b\u3089\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_13955\" aria-describedby=\"caption-attachment-13955\" style=\"width: 653px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/07-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13955\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/07-3.png\" alt=\"\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u304b\u3089\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a\" width=\"653\" height=\"419\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/07-3.png 653w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/07-3-300x192.png 300w\" sizes=\"auto, (max-width: 653px) 100vw, 653px\" \/><\/a><figcaption id=\"caption-attachment-13955\" class=\"wp-caption-text\">\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u304b\u3089\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u6307\u5b9a<\/figcaption><\/figure>\n<p>\u3000Shapefile \u306b\u30d5\u30eb\u30d1\u30b9\u4ed8\u304d\u306e\u30b7\u30a7\u30fc\u30d7\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u6307\u5b9a\u3055\u308c\u305f\u3068\u3053\u308d\u3067\u3042\u308b\uff0eID Column \u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f ID \u3068\u306a\u3063\u3066\u3044\u308b\u304c\uff0c\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u3067\u3059\u3067\u306b\u4f7f\u7528\u3057\u3066\u3044\u308b\u540d\u524d\u3067\u3042\u308a\u7af6\u5408\u3059\u308b\uff0e\u305d\u306e\u305f\u3081 AnotherID \u3068\u5225\u540d\u3092\u4ed8\u3051\u3066\u3044\u308b\uff0e<\/p>\n<p>\u3000Upload to Database \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_13950\" aria-describedby=\"caption-attachment-13950\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/45.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13950\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/45.png\" alt=\"Shape2SQL\" width=\"439\" height=\"489\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/45.png 439w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/45-269x300.png 269w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><figcaption id=\"caption-attachment-13950\" class=\"wp-caption-text\">Shape2SQL<\/figcaption><\/figure>\n<p>\u3000\u6642\u6298\u73fe\u308c\u308b\u30a8\u30e9\u30fc\u306f OK \u3067\u7121\u8996\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_13956\" aria-describedby=\"caption-attachment-13956\" style=\"width: 409px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/11-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13956\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/11-4.png\" alt=\"\u30a8\u30e9\u30fc\u306fOK\u3067\u7121\u8996\" width=\"409\" height=\"349\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/11-4.png 409w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/11-4-300x256.png 300w\" sizes=\"auto, (max-width: 409px) 100vw, 409px\" \/><\/a><figcaption id=\"caption-attachment-13956\" class=\"wp-caption-text\">\u30a8\u30e9\u30fc\u306fOK\u3067\u7121\u8996<\/figcaption><\/figure>\n<h2>\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u306f csv \u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/h2>\n<p>\u3000\u8272\u3005\u8a66\u884c\u932f\u8aa4\u3057\u305f\u7d50\u679c\uff0c\u65e5\u672c\u8a9e\u90e8\u5206\u306f csv \u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u306e\u304c\u30d9\u30bf\u30fc\u3060\u308d\u3046\u3068\u3044\u3046\u7d50\u8ad6\u306b\u81f3\u3063\u305f\uff0e<\/p>\n<h3>\u30ec\u30a4\u30e4\u306e\u300c\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u300d\u300c\u5730\u7269\u306e\u4fdd\u5b58&#8230;\u300d<\/h3>\n<p>\u3000\u30ec\u30a4\u30e4\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u300d\u300c\u5730\u7269\u306e\u4fdd\u5b58&#8230;\u300d\u3078\u3068\u9032\u3080\uff0e<\/p>\n<figure id=\"attachment_13957\" aria-describedby=\"caption-attachment-13957\" style=\"width: 499px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/22-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13957\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/22-1.png\" alt=\"\u30ec\u30a4\u30e4\u306e\u300c\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u300d\u300c\u5730\u7269\u306e\u4fdd\u5b58...\u300d\" width=\"499\" height=\"484\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/22-1.png 499w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/22-1-300x291.png 300w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/a><figcaption id=\"caption-attachment-13957\" class=\"wp-caption-text\">\u30ec\u30a4\u30e4\u306e\u300c\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u300d\u300c\u5730\u7269\u306e\u4fdd\u5b58&#8230;\u300d<\/figcaption><\/figure>\n<h3>\u300c\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u540d\u524d\u3092\u4ed8\u3051\u3066\u4fdd\u5b58&#8230;\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u306e\u6ce8\u610f\u70b9<\/h3>\n<p>\u3000\u307e\u305a\uff0c\u300c\u5f62\u5f0f\u300d\u306f\u300c\u30ab\u30f3\u30de\u3067\u533a\u5207\u3089\u308c\u305f\u5024(CSV)\u300d\u3092\u9078\u3076\uff0e\u300c\u30d5\u30a1\u30a4\u30eb\u540d\u300d\u306f\u30d5\u30eb\u30d1\u30b9\u4ed8\u304d\u3067\u306a\u3044\u3068\u30a8\u30e9\u30fc\u3068\u306a\u308b\u305f\u3081\uff0c\u53f3\u5074\u306e\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u9077\u79fb\u3057\u305f\u30c0\u30a4\u30a2\u30ed\u30b0\u3067\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u6307\u5b9a\u3059\u308b\uff0e<\/p>\n<p>\u3000\u3055\u3066\uff0c\u4e0b\u56f3\u306e\u3088\u3046\u306b\u8d64\u3067\u5370\u3057\u305f\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u6ce8\u610f\u3059\u3079\u304d\u70b9\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u300c\u6587\u5b57\u30b3\u30fc\u30c9\u300d\u3092 Shift_JIS \u306b\u3059\u308b\uff0e<\/p>\n<p>\u3000\u300c\u30b8\u30aa\u30e1\u30c8\u30ea\u30bf\u30a4\u30d7\u300d\u3092\u300c\u30b8\u30aa\u30e1\u30c8\u30ea\u306a\u3057\u300d\u306b\u3059\u308b\uff0e<\/p>\n<p>\u3000\u300c\u30ec\u30a4\u30e4\u30aa\u30d7\u30b7\u30e7\u30f3\u300d\u306e STRING_QUOTING \u3092 IF_NEEDED \u306b\u5909\u66f4\u3059\u308b\uff0e\u3053\u3053\u3092\u5909\u66f4\u3057\u306a\u3044\u3068 SQL Server \u5074\u306e\u30a6\u30a3\u30b6\u30fc\u30c9\u3067\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u5024\u306b\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\u304c\u4ed8\u52a0\u3055\u308c\u3066\u3057\u307e\u3046\uff0e<\/p>\n<figure id=\"attachment_13958\" aria-describedby=\"caption-attachment-13958\" style=\"width: 593px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/41.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13958\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/41.png\" alt=\"\u300c\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u540d\u524d\u3092\u4ed8\u3051\u3066\u4fdd\u5b58...\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u306e\u6ce8\u610f\u70b9\" width=\"593\" height=\"684\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/41.png 593w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/41-260x300.png 260w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/a><figcaption id=\"caption-attachment-13958\" class=\"wp-caption-text\">\u300c\u30d9\u30af\u30bf\u30ec\u30a4\u30e4\u3092\u540d\u524d\u3092\u4ed8\u3051\u3066\u4fdd\u5b58&#8230;\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u306e\u6ce8\u610f\u70b9<\/figcaption><\/figure>\n<h2>SQL Server \u306e\u30a6\u30a3\u30b6\u30fc\u30c9<\/h2>\n<p>\u3000\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30bf\u30b9\u30af\u300d\u300c\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8&#8230;\u300d\u3068\u9032\u3080\uff0e<\/p>\n<figure id=\"attachment_13961\" aria-describedby=\"caption-attachment-13961\" style=\"width: 658px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/24-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13961\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/24-1.png\" alt=\"\u300c\u30bf\u30b9\u30af\u300d\u300c\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8...\u300d\" width=\"658\" height=\"485\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/24-1.png 658w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/24-1-300x221.png 300w\" sizes=\"auto, (max-width: 658px) 100vw, 658px\" \/><\/a><figcaption id=\"caption-attachment-13961\" class=\"wp-caption-text\">\u300c\u30bf\u30b9\u30af\u300d\u300c\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8&#8230;\u300d<\/figcaption><\/figure>\n<h3>\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e<\/h3>\n<p>\u3000\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u306f\u300cFlat File Source\u300d\u3092\u9078\u3076\uff0e<\/p>\n<figure id=\"attachment_13962\" aria-describedby=\"caption-attachment-13962\" style=\"width: 634px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/25-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13962\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/25-2.png\" alt=\"\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u306f\u300cFlat File Source\u300d\" width=\"634\" height=\"556\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/25-2.png 634w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/25-2-300x263.png 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/a><figcaption id=\"caption-attachment-13962\" class=\"wp-caption-text\">\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u306f\u300cFlat File Source\u300d<\/figcaption><\/figure>\n<p>\u3000\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3067csv\u30d5\u30a1\u30a4\u30eb\u3092\u9078\u629e\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_13963\" aria-describedby=\"caption-attachment-13963\" style=\"width: 700px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/26-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13963\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/26-1.png\" alt=\"\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3067csv\u30d5\u30a1\u30a4\u30eb\u3092\u9078\u629e\" width=\"700\" height=\"320\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/26-1.png 700w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/26-1-300x137.png 300w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><figcaption id=\"caption-attachment-13963\" class=\"wp-caption-text\">\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3067csv\u30d5\u30a1\u30a4\u30eb\u3092\u9078\u629e<\/figcaption><\/figure>\n<p>\u3000\u6841\u3042\u3075\u308c\u3092\u9632\u3050\u305f\u3081\uff0c\u300c\u8a73\u7d30\u8a2d\u5b9a\u300d\u3067\u6cb3\u5ddd\u540d (W05_004) \u304a\u3088\u3073 path \u306e OutputColumnWidth\u3092\u5e83\u3052\u3066\u304a\u304f\uff0e<\/p>\n<figure id=\"attachment_13964\" aria-describedby=\"caption-attachment-13964\" style=\"width: 634px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/27-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13964\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/27-2.png\" alt=\"\u300c\u8a73\u7d30\u8a2d\u5b9a\u300d\u3067OutputColumnWidth\u3092\u5e83\u3052\u3066\u304a\u304f\" width=\"634\" height=\"556\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/27-2.png 634w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/27-2-300x263.png 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/a><figcaption id=\"caption-attachment-13964\" class=\"wp-caption-text\">\u300c\u8a73\u7d30\u8a2d\u5b9a\u300d\u3067OutputColumnWidth\u3092\u5e83\u3052\u3066\u304a\u304f<\/figcaption><\/figure>\n<h3>\u5909\u63db\u5148\u306e\u9078\u629e<\/h3>\n<p>\u3000\u300c\u5909\u63db\u5148\u306e\u9078\u629e\u300d\u306fSQL Server Native Client 11.0 \u3092\u9078\u3076\uff0e<\/p>\n<figure id=\"attachment_13965\" aria-describedby=\"caption-attachment-13965\" style=\"width: 634px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/29-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13965\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/29-2.png\" alt=\"\u300c\u5909\u63db\u5148\u306e\u9078\u629e\u300d\u306fSQL Server Native Client 11.0\" width=\"634\" height=\"556\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/29-2.png 634w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/29-2-300x263.png 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/a><figcaption id=\"caption-attachment-13965\" class=\"wp-caption-text\">\u300c\u5909\u63db\u5148\u306e\u9078\u629e\u300d\u306fSQL Server Native Client 11.0<\/figcaption><\/figure>\n<h3>\u30b3\u30d4\u30fc\u5143\u306e\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u30d3\u30e5\u30fc\u3092\u9078\u629e<\/h3>\n<p>\u3000\u300c\u30b3\u30d4\u30fc\u5143\u306e\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u30d3\u30e5\u30fc\u3092\u9078\u629e\u300d\u3067\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u5909\u66f4\u3067\u304d\u308b\uff0e\u4e0b\u56f3\u3067\u306f AllStreamShift_JIS \u3068\u306a\u3063\u3066\u3044\u308b\u304c\uff0c\u8a66\u884c\u932f\u8aa4\u306e\u9014\u4e2d\u30ad\u30e3\u30d7\u30c1\u30e3\u306a\u306e\u3067\u5b9f\u969b\u306b\u306f StreamProperties \u3068\u3057\u3066\u3044\u308b\uff0e<\/p>\n<p>\u3000\u300c\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u7de8\u96c6&#8230;\u300d\u3078\u3068\u9032\u3080\uff0e<\/p>\n<figure id=\"attachment_13966\" aria-describedby=\"caption-attachment-13966\" style=\"width: 634px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/31-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13966\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/31-1.png\" alt=\"\u300c\u30b3\u30d4\u30fc\u5143\u306e\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u30d3\u30e5\u30fc\u3092\u9078\u629e\u300d\" width=\"634\" height=\"556\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/31-1.png 634w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/31-1-300x263.png 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/a><figcaption id=\"caption-attachment-13966\" class=\"wp-caption-text\">\u300c\u30b3\u30d4\u30fc\u5143\u306e\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u30d3\u30e5\u30fc\u3092\u9078\u629e\u300d<\/figcaption><\/figure>\n<h3>\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u7de8\u96c6<\/h3>\n<p>\u3000\u300c\u5217\u30de\u30c3\u30d4\u30f3\u30b0\u300d\u3067\u30c7\u30fc\u30bf\u578b\u3068\u30c7\u30fc\u30bf\u9577\u3092\u6307\u5b9a\u3059\u308b\uff0e\u4e0b\u56f3\u306e\u3088\u3046\u306b\u306a\u308b\u306e\u304c\u7406\u60f3\u7684\u3060\u304c\uff0c\u5f80\u3005\u306b\u3057\u3066\u6841\u3042\u3075\u308c\u3067\u30a8\u30e9\u30fc\u3068\u306a\u308b\u3053\u3068\u304c\u983b\u767a\u3059\u308b\u305f\u3081\uff0c nvarchar (255) \u3068\u59a5\u5354\u3059\u308b\u3053\u3068\u304c\u591a\u3044\uff0e<\/p>\n<figure id=\"attachment_13967\" aria-describedby=\"caption-attachment-13967\" style=\"width: 595px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/32.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13967\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/32.png\" alt=\"\u300c\u5217\u30de\u30c3\u30d4\u30f3\u30b0\u300d\u3067\u30c7\u30fc\u30bf\u578b\u3068\u30c7\u30fc\u30bf\u9577\u3092\u6307\u5b9a\" width=\"595\" height=\"577\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/32.png 595w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/32-300x291.png 300w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><\/a><figcaption id=\"caption-attachment-13967\" class=\"wp-caption-text\">\u300c\u5217\u30de\u30c3\u30d4\u30f3\u30b0\u300d\u3067\u30c7\u30fc\u30bf\u578b\u3068\u30c7\u30fc\u30bf\u9577\u3092\u6307\u5b9a<\/figcaption><\/figure>\n<p>\u3000\u5e7e\u5ea6\u304b\u306e\u8a66\u884c\u932f\u8aa4\u3092\u7d4c\u3066\uff0c\u300c\u64cd\u4f5c\u306f\u6b63\u5e38\u306b\u5b9f\u884c\u3055\u308c\u307e\u3057\u305f\u300d\u3068\u64cd\u4f5c\u304c\u5b8c\u4e86\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_13968\" aria-describedby=\"caption-attachment-13968\" style=\"width: 634px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/34-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13968\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/34-1.png\" alt=\"\u300c\u64cd\u4f5c\u306f\u6b63\u5e38\u306b\u5b9f\u884c\u3055\u308c\u307e\u3057\u305f\u300d\" width=\"634\" height=\"556\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/34-1.png 634w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2021\/02\/34-1-300x263.png 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/a><figcaption id=\"caption-attachment-13968\" class=\"wp-caption-text\">\u300c\u64cd\u4f5c\u306f\u6b63\u5e38\u306b\u5b9f\u884c\u3055\u308c\u307e\u3057\u305f\u300d<\/figcaption><\/figure>\n<h2>\u6cb3\u5ddd\u30b3\u30fc\u30c9\u3068\u6c34\u57df\u7cfb\u30b3\u30fc\u30c9\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b<\/h2>\n<p>\u3000<a href=\"https:\/\/nlftp.mlit.go.jp\/ksj\/gml\/codelist\/RiverCodeCd.html\" target=\"_blank\" rel=\"noopener\">\u6cb3\u5ddd\u30b3\u30fc\u30c9<\/a>\u3068<a href=\"https:\/\/nlftp.mlit.go.jp\/ksj\/gml\/codelist\/WaterSystemCodeCd.html\" target=\"_blank\" rel=\"noopener\">\u6c34\u57df\u7cfb\u30b3\u30fc\u30c9<\/a>\u306f\u305d\u308c\u305e\u308c<a href=\"https:\/\/nlftp.mlit.go.jp\/ksj\/gml\/datalist\/KsjTmplt-W05.html\" target=\"_blank\" rel=\"noopener\">\u56fd\u571f\u6570\u5024\u60c5\u5831<\/a>\u306b\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u308b\uff0ePower Query \u3067\u8aad\u307f\u8fbc\u3082\u3046\u3068\u3057\u305f\u306e\u3060\u304c\uff0c\u306a\u305c\u304b\u3046\u307e\u304f\u884c\u304b\u306a\u3044\u305f\u3081\uff0c\u3084\u3080\u306a\u304f\u30b3\u30d4\u30da\u3067\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b\u8cbc\u308a\u4ed8\u3051\uff0ccsv \u30d5\u30a1\u30a4\u30eb\u306b\u4fdd\u5b58\u3059\u308b\uff0e\u305d\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u5148\u7a0b\u3068\u540c\u69d8\uff0cSQL Server \u306e\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u3063\u3066\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\uff0e<\/p>\n<p>\u3000\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3066\u3067\u304d\u305f\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u305d\u308c\u305e\u308c RiverName, WaterSystem \u3068\u3059\u308b\uff0e<\/p>\n<h2>\u7d50\u679c<\/h2>\n<p>\u3000\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u767a\u884c\u3059\u308b\uff0e<\/p>\n<pre class=\"lang:tsql decode:true \">SELECT [AnotherID]\n      ,[ID]\n      ,[W05_001]\n      ,[W05_002]\n      ,[W05_003]\n      ,[W05_004]\n      ,[W05_005]\n      ,[W05_006]\n      ,[W05_007]\n      ,[W05_008]\n      ,[W05_009]\n      ,[W05_010]\n      ,[layer]\n      ,[path]\n      ,[geom]\n  FROM [RiverGIS].[dbo].[AllStream]\n\n  SELECT [ID]\n      ,[W05_001]\n      ,[W05_002]\n      ,[W05_003]\n      ,[W05_004]\n      ,[W05_005]\n      ,[W05_006]\n      ,[W05_007]\n      ,[W05_008]\n      ,[W05_009]\n      ,[W05_010]\n      ,[layer]\n      ,[path]\n  FROM [RiverGIS].[dbo].[StreamProperties]\n\n  SELECT [RiverCode]\n      ,[River]\n  FROM [RiverGIS].[dbo].[RiverName]\n\n  SELECT [WaterSystemCode]\n      ,[WaterSystem]\n  FROM [RiverGIS].[dbo].[WaterSystem]<\/pre>\n<p>\u3000\u7d50\u679c\u306f\u4e0b\u8a18\u306e\u3068\u304a\u308a\u3067\u3042\u308b\uff0e\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u306e\u5730\u7269\u306e\u5ea7\u6a19\u306f 26 \u4ef6\u5207\u308a\u6368\u3066\u3089\u308c\u305f\u3053\u3068\u304c\u5206\u304b\u308b\uff0e<\/p>\n<pre class=\"lang:tsql decode:true\">(286421 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(286437 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(35449 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5476 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<p>\u3000WaterSystem \u304a\u3088\u3073 RiverName \u306f\u30de\u30b9\u30bf\u30fc\u3068\u3057\u3066\u6271\u3046\u3079\u304d\u3067\u3042\u308b\u304c\uff0c\u7167\u5408\u3057\u3066\u307f\u308b\u3068\u30de\u30b9\u30bf\u30fc\u306b\u5b58\u5728\u3057\u306a\u3044\u6cb3\u5ddd\u30b3\u30fc\u30c9\u3084\u6c34\u57df\u7cfb\u30b3\u30fc\u30c9\u304c\u5b58\u5728\u3059\u308b\u3088\u3046\u3060\uff0e<\/p>\n<h3>\u672a\u5b9a\u7fa9\u306e\u6c34\u57df\u7cfb\u30b3\u30fc\u30c9<\/h3>\n<p>\u3000\u672a\u5b9a\u7fa9\u306e\u6c34\u57df\u7cfb\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3057\u305f\uff0e\u7d50\u679c\u306f 47 \u4ef6\u3042\u308b\u304c\uff0c\u5f71\u97ff\u306e\u53ca\u3076\u6cb3\u5ddd\u306f\u591a\u3044\uff0e\u3053\u308c\u3092\u53ef\u8996\u5316\u3057\u305f\u3089\u3069\u3046\u306a\u308b\u304b\uff0c\u898b\u3066\u307f\u305f\u3044\u6c17\u3082\u3059\u308b\uff0e<\/p>\n<pre class=\"lang:tsql decode:true\">WITH CTE(Undefiend)\nAS\n(\nSELECT W05_001 \nFROM dbo.StreamProperties\nEXCEPT \nSELECT WaterSystemCode \nFROM dbo.WaterSystem \n)\nSELECT\tCTE.Undefiend\n\t,\tCOUNT(P.W05_002)\tAS CNT\nFROM\tCTE\nINNER\tJOIN dbo.StreamProperties\tAS P\nON\tCTE.Undefiend = P.W05_001\nGROUP\tBY CTE.Undefiend\nORDER\tBY CTE.Undefiend<\/pre>\n<pre class=\"lang:tsql decode:true \">(47 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<pre class=\"lang:tsql decode:true \">Undefiend\tCNT\n010000\t354\n010206\t3\n020000\t1826\n030000\t1497\n040000\t380\n050000\t526\n060000\t209\n070000\t1198\n080000\t11\n100000\t1\n120000\t227\n130000\t67\n140000\t50\n150000\t1975\n160000\t909\n170000\t1118\n180000\t520\n190000\t2\n220000\t266\n230000\t490\n240000\t226\n250000\t3\n260000\t110\n270000\t40\n280000\t208\n290000\t8\n300000\t47\n310000\t60\n320000\t243\n330000\t180\n340000\t347\n350000\t207\n360000\t39\n370000\t129\n380000\t122\n390000\t142\n400000\t941\n400069\t6\n410000\t356\n410103\t1\n420000\t1473\n430000\t1124\n440000\t823\n441030\t2\n450000\t1340\n460000\t1809\n470000\t948<\/pre>\n<h3>\u672a\u5b9a\u7fa9\u306e\u6cb3\u5ddd\u30b3\u30fc\u30c9<\/h3>\n<p>\u3000\u6c34\u57df\u7cfb\u30b3\u30fc\u30c9\u3068\u9055\u3063\u3066\u6570\u304c\u6841\u9055\u3044\u306b\u591a\u3044\u305f\u3081\uff0c\u7d50\u679c\u306f\u7701\u7565\u3059\u308b\uff0e\u30b3\u30fc\u30c9\u306f\u3042\u308b\u304c\u540d\u524d\u306e\u5b58\u5728\u3057\u306a\u3044\u6cb3\u5ddd\u304c\u5b58\u5728\u3059\u308b\uff0e<\/p>\n<pre class=\"lang:tsql decode:true \">WITH CTE(Undefiend)\nAS\n(\nSELECT\tW05_002\tAS 'Undefined'\nFROM\tdbo.StreamProperties\nEXCEPT\nSELECT\tRiverCode\nFROM\tdbo.RiverName\n)\nSELECT\tCTE.Undefiend\n\t,\tCOUNT(P.W05_002)\tAS CNT\nFROM\tCTE\nINNER\tJOIN dbo.StreamProperties\tAS P\nON\tCTE.Undefiend = P.W05_002\nGROUP\tBY CTE.Undefiend\nORDER\tBY CTE.Undefiend<\/pre>\n<pre class=\"lang:tsql decode:true\">(1667 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>\u3000\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u3092 QGIS \u304b\u3089 SQL Server \u3078\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3057\u305f\uff0e<\/p>\n<p>\u3000\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u306b\u3064\u3044\u3066\u306f\u65e5\u672c\u8a9e\u304c\u6587\u5b57\u5316\u3051\u3059\u308b\u305f\u3081\u5225\u9014 csv \u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u30a6\u30a3\u30b6\u30fc\u30c9\u306b\u3088\u308a\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\uff0e<\/p>\n<p>\u3000\u30de\u30b9\u30bf\u30fc\u3068\u3057\u3066\u306e\u6cb3\u5ddd\u30b3\u30fc\u30c9\u304a\u3088\u3073\u6c34\u57df\u7cfb\u30b3\u30fc\u30c9\u306b\u306f\u4e0d\u5099\u304c\u3042\u308b\uff0e\u307e\u305f\uff0c\u6cb3\u5ddd\u30c7\u30fc\u30bf\u305d\u306e\u3082\u306e\u306b\u3082\u4e0d\u5099\u304c\u3042\u308b\uff0e<\/p>\n<p>\u3000\u6cb3\u5ddd\u7aef\u70b9\u3067\u3042\u308b W05_007 \u304b\u3089 W05_010 \u307e\u3067\u306e4\u3064\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u3069\u3046\u6271\u3046\u3079\u304d\u304b\uff0c\u5206\u304b\u3089\u306a\u3044\uff0e\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u306f\u518d\u5e30\u306e\u5d50\u306b\u306a\u308b\u53ef\u80fd\u6027\u304c\u3042\u308b\uff0e\u65b0\u3057\u3044\u30a2\u30d7\u30ed\u30fc\u30c1\u6cd5\u304c\u5fc5\u8981\u304b\u3082\u3057\u308c\u306a\u3044\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000QGIS \u304b\u3089 SQL Server 2008 R2 \u306b\u7a7a\u9593\u30c7\u30fc\u30bf\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u969b\u306b\u306f Shape2SQL \u3068\u3044\u3046\u30c4\u30fc\u30eb\u3092\u4f7f\u3063\u305f\uff0e\u4fbf\u5229\u306a\u30c4\u30fc\u30eb\u3067\u306f\u3042\u308b\u304c\uff0c\u56fd\u571f\u6570\u5024\u60c5\u5831\u306e\u6cb3\u5ddd\u30c7\u30fc\u30bf\u306e\u5c5e\u6027\u30c6\u30fc\u30d6\u30eb\u306e\u65e5\u672c\u8a9e\u304c\u6587\u5b57\u5316\u3051\u3059\u308b &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=13945\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;QGIS \u304b\u3089 SQL Server \u3078\u30c7\u30fc\u30bf\u3092\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u969b\u306e\u52d8\u6240&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[2657,9624,7672,7674,2878,4673,1030,2775,9614,9620,5411,5914,9623,4674,3725,4067,9177,4672,9112,9110,7669,9504,2740,9115,2750,4165,9619,7694,9505,4658,1801,7553,2871,6739,9119,9616,2783,9611,9621,4295,9613,9114,9617,2874,5002,4423,2875,4399,32,2499,3600,5154,664,4736,9571,9547,9498,5362,5204,9434,9501,9612,4483,9199,4282,9615,9137,9175,9497,5370,9549,9189,9139,9499,8538,3634,3532,9622,9209,9165,9155,7181,9609,2789,9610],"class_list":["post-13945","post","type-post","status-publish","format-standard","hentry","category-technology","tag-csv","tag-cte","tag-database-configuration","tag-database-properties","tag-flat-file-source","tag-from","tag-group-by","tag-id","tag-id-column","tag-if_needed","tag-inner","tag-join","tag-nvarchar255","tag-order-by","tag-outputcolumnwidth","tag-power-query","tag-qgis","tag-select","tag-select-or-enter-a-database-name","tag-server-name","tag-shape2sql","tag-shift_jis","tag-sql-server","tag-sql-server-2008-r2","tag-sql-server-management-studio","tag-sql-server-native-client-11-0","tag-string_quoting","tag-upload-to-database","tag-utf8","tag-with","tag-1801","tag-7553","tag-2871","tag-6739","tag-9119","tag-csv-2","tag-2783","tag-9611","tag-9621","tag-4295","tag-9613","tag-9114","tag-9617","tag-2874","tag-5002","tag-4423","tag-2875","tag-4399","tag-32","tag-2499","tag-3600","tag-5154","tag-664","tag-4736","tag-9571","tag-9547","tag-9498","tag-5362","tag-5204","tag-9434","tag-9501","tag-9612","tag-4483","tag-9199","tag-4282","tag-9615","tag-9137","tag-9175","tag-9497","tag-5370","tag-9549","tag-9189","tag-9139","tag-9499","tag-8538","tag-3634","tag-3532","tag-9622","tag-9209","tag-9165","tag-9155","tag-7181","tag-9609","tag-2789","tag-9610"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/13945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13945"}],"version-history":[{"count":39,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/13945\/revisions"}],"predecessor-version":[{"id":14336,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/13945\/revisions\/14336"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}