{"id":315,"date":"2014-06-25T20:46:56","date_gmt":"2014-06-25T11:46:56","guid":{"rendered":"http:\/\/gomocool.net\/gomokulog\/?p=315"},"modified":"2014-06-25T20:46:56","modified_gmt":"2014-06-25T11:46:56","slug":"asp-net%e3%83%87%e3%83%bc%e3%82%bf%e3%82%bb%e3%83%83%e3%83%88%e3%81%a7%e4%b8%80%e6%99%82%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%81%ae%e3%82%b9%e3%83%88%e3%82%a2%e3%83%89%e3%82%92%e5%bc%b7%e5%bc%95","status":"publish","type":"post","link":"https:\/\/gomokulog.gomocool.net\/?p=315","title":{"rendered":"[ASP.NET]\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3067\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306e\u30b9\u30c8\u30a2\u30c9\u3092\u5f37\u5f15\u306b\u4f7f\u3046"},"content":{"rendered":"<p><del>\u307f\u3093\u306a\u5927\u597d\u304d\u306a<\/del>\u578b\u4ed8\u304d\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3002<\/p>\n<p>\u30ec\u30ac\u30b7\u30fc\u306a\u74b0\u5883\u3067\u306f\u3001\u907f\u3051\u3066\u901a\u308c\u306a\u3044\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3002<\/p>\n<p>\u3055\u3066\u3001\u305d\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u3001\u9811\u5f35\u3063\u3066\u4f5c\u3063\u305f\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u30c6\u30fc\u30d6\u30eb\u30a2\u30c0\u30d7\u30bf\u30fc\u7d4c\u7531\u3067\u767b\u9332\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u3001\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\u3002<\/p>\n<p>\u539f\u56e0\u306f\u3001\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u3063\u305f\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304b\u3089\u306f\u30c7\u30fc\u30bf\u5217\u3092\u89e3\u6790\u3067\u304d\u306a\u3044\u304b\u3089\u307f\u305f\u3044\u3002<br \/>\n\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u308f\u306a\u3044\u30b9\u30c8\u30a2\u30c9\u3063\u3066\u30fb\u30fb\u30fb\u30fb\u601d\u3063\u3066\u305f\u3089\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u3060\u307e\u3059\u65b9\u6cd5\u3067\u5f37\u5f15\u306b\u4f7f\u3048\u308b\u307f\u305f\u3044\u3002<\/p>\n<p>\u307e\u305a\u3001\u3053\u3046\u3044\u3046\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304c\u3042\u3063\u305f\u3068\u3059\u308b\u3002<\/p>\n<pre class=\"lang:tsql decode:true\">ALTER Procedure [dbo].[DummyUseTemp] \r\nAS\r\n\r\nSELECT 1 AS A, 2 AS B, 3 AS C, 4 AS D, 5 AS E ,'dummy' AS Comment INTO #list;\r\nSELECT * FROM #list;\r\n\r\nGO<\/pre>\n<p>\u3053\u306e\u307e\u307e\u3060\u3068#list\u3068\u3044\u3046\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308b\u306e\u3067\u4f7f\u3048\u306a\u3044\u3002<\/p>\n<p>\u3053\u308c\u3092\u3001\u3068\u308a\u3042\u3048\u305a\u3001\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u4f7f\u308f\u306a\u3044\u5f62\u3067\u6700\u7d42\u7d50\u679c\u306b\u5408\u308f\u305b\u3066\u30c0\u30df\u30fc\u51fa\u529b\u3059\u308b\u3088\u3046\u306b\u66f8\u304d\u76f4\u3059\u3002<\/p>\n<pre class=\"lang:default decode:true \">ALTER Procedure [dbo].[DummyUseTemp] \r\nAS\r\n\r\nSELECT 1 AS A, 2 AS B, 3 AS C, 4 AS D, 5 AS E ,'dummy' AS Comment;\r\n\r\n--SELECT 1 AS A, 2 AS B, 3 AS C, 4 AS D, 5 AS E ,'dummy' AS Comment INTO #list;\r\n--SELECT * FROM #list;\r\n\r\nGO<\/pre>\n<p>\u3053\u308c\u3067\u3001\u3082\u3046\u4e00\u5ea6\u30c6\u30fc\u30d6\u30eb\u30a2\u30c0\u30d7\u30bf\u30fc\u304b\u3089\u767b\u9332\u3055\u305b\u308b\u3068\u3001\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u4f7f\u3063\u3066\u306a\u3044\u306e\u3067\u81ea\u52d5\u3067\u30c7\u30fc\u30bf\u5217\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<br \/>\n<a href=\"http:\/\/gomocool.net\/gomokulog\/wp-content\/uploads\/2014\/06\/ds4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-316\" src=\"http:\/\/gomocool.net\/gomokulog\/wp-content\/uploads\/2014\/06\/ds4.png\" alt=\"ds4\" width=\"668\" height=\"566\" \/><\/a><\/p>\n<p>\u3053\u306e\u307e\u307e\u4f5c\u3063\u3061\u3083\u3063\u305f\u5f8c\u306b\u3001\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3060\u3051\u30b3\u30e1\u30f3\u30c8\u3092\u5916\u3057\u3066\u3001\u5143\u306b\u623b\u3057\u307e\u3059\u3002<\/p>\n<p>\u3053\u308c\u3067\u52d5\u304d\u307e\u3059\u3002<\/p>\n<p>\u305f\u3060\u3001\u666e\u901a\u306b&#8217;dummy&#8217;\u3068\u304b\u5165\u308c\u308b\u3068\u3001MaxLength\u30d7\u30ed\u30d1\u30c6\u30a3\u304cdummy\u306e5\u6587\u5b57\u306b\u306a\u3063\u3066\u305f\u308a\u3059\u308b\u306e\u3067\u3001\u5909\u66f4\u3059\u308b\u305f\u3073\u306b\u3001\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u6bce\u56de\u5909\u3048\u306a\u304d\u3083\u306a\u3089\u3093\u306e\u3067\u3001SELECT\u3059\u308b\u969b\u306bCAST\u3068\u304b\u99c6\u4f7f\u3059\u308b\u3068\u3088\u3044\u304b\u3082\u3002<\/p>\n<pre class=\"lang:tsql decode:true\">SELECT 0 AS A, 0 AS B, 0 AS C, 0 AS D, 0 AS E, CAST('dummy' AS varchar(10)) AS Comment;<\/pre>\n<p>\u3057\u304b\u3057\u3001VS2008\u3067\u8d77\u304d\u305f\u554f\u984c\u3060\u304b\u3089\u3001VS2013\u3067\u3088\u304d\u306b\u8a08\u3089\u3063\u3066\u304f\u308c\u3066\u308b\u304b\u3082\u3068\u601d\u3063\u3066\u3001VS2013\u3067\u8a66\u3057\u3066\u307f\u305f\u3051\u3069\u5909\u308f\u3063\u3066\u306a\u304b\u3063\u305f\u30fb\u30fb\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u307f\u3093\u306a\u5927\u597d\u304d\u306a\u578b\u4ed8\u304d\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3002 \u30ec\u30ac\u30b7\u30fc\u306a\u74b0\u5883\u3067\u306f\u3001\u907f\u3051\u3066\u901a\u308c\u306a\u3044\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3002 \u3055\u3066\u3001\u305d\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u3001\u9811\u5f35\u3063\u3066\u4f5c\u3063\u305f\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u30c6\u30fc\u30d6\u30eb\u30a2\u30c0\u30d7\u30bf\u30fc\u7d4c\u7531\u3067\u767b\u9332\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u3001\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\u3002 \u539f\u56e0\u306f\u3001\u4e00&hellip;  <a href=\"https:\/\/gomokulog.gomocool.net\/?p=315\" class=\"more-link\">more <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[45,44],"class_list":["post-315","post","type-post","status-publish","format-standard","hentry","category-dot-net","tag-45","tag-44"],"_links":{"self":[{"href":"https:\/\/gomokulog.gomocool.net\/index.php?rest_route=\/wp\/v2\/posts\/315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gomokulog.gomocool.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gomokulog.gomocool.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gomokulog.gomocool.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gomokulog.gomocool.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=315"}],"version-history":[{"count":1,"href":"https:\/\/gomokulog.gomocool.net\/index.php?rest_route=\/wp\/v2\/posts\/315\/revisions"}],"predecessor-version":[{"id":317,"href":"https:\/\/gomokulog.gomocool.net\/index.php?rest_route=\/wp\/v2\/posts\/315\/revisions\/317"}],"wp:attachment":[{"href":"https:\/\/gomokulog.gomocool.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gomokulog.gomocool.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gomokulog.gomocool.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}