{"id":1009,"date":"2019-10-20T00:00:34","date_gmt":"2019-10-19T15:00:34","guid":{"rendered":"http:\/\/ji-develop.com\/blog\/?p=1009"},"modified":"2022-05-05T09:48:27","modified_gmt":"2022-05-05T00:48:27","slug":"null%e3%81%8c%e3%82%ab%e3%82%a6%e3%83%b3%e3%83%88%e3%81%95%e3%82%8c%e3%81%aa%e3%81%84","status":"publish","type":"post","link":"https:\/\/ji-develop.com\/blog\/null%e3%81%8c%e3%82%ab%e3%82%a6%e3%83%b3%e3%83%88%e3%81%95%e3%82%8c%e3%81%aa%e3%81%84","title":{"rendered":"NULL\u304c\u30ab\u30a6\u30f3\u30c8\u3055\u308c\u306a\u3044"},"content":{"rendered":"<p>\u3053\u308c\u3001\u77e5\u3089\u306a\u304f\u3066\u76f2\u70b9\u3060\u3063\u305f\u306e\u3067\u3059\u304c\u3001<\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr bgcolor=\"#cccccc\">\n<td style=\"width: 33%;\">ID<\/td>\n<td style=\"width: 33%;\">EmployeeCode<\/td>\n<td style=\"width: 34%;\">EmployeeName<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33%;\">1<\/td>\n<td style=\"width: 33%;\">0010<\/td>\n<td style=\"width: 34%;\">\u6c96\u7530\u7dcf\u53f8<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33%;\">2<\/td>\n<td style=\"width: 33%;\">0020<\/td>\n<td style=\"width: 34%;\">\u6c38\u5009\u65b0\u516b<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33%;\">3<\/td>\n<td style=\"width: 33%;\">null<\/td>\n<td style=\"width: 34%;\">\u658e\u85e4\u4e00<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33%;\">4<\/td>\n<td style=\"width: 33%;\">0040<\/td>\n<td style=\"width: 34%;\">\u677e\u539f\u5fe0\u53f8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u4f8b\u3048\u3070\u3001\u3053\u3093\u306a\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u3063\u305f\u3068\u3057\u3066\u3001<\/p>\n<p>EmployeeCode\u304c&#8217;0040&#8217;\u4ee5\u5916\u306e\u30ec\u30b3\u30fc\u30c9\u6570\u3092\u30ab\u30a6\u30f3\u30c8\u3057\u305f\u3044\u3068\u3057\u305f\u5834\u5408\u3001<\/p>\n<pre>SELECT COUNT(*) FROM Employee WHERE EmployeeCode != '0040'<\/pre>\n<p>\u3053\u3093\u306a\u98a8\u306b\u3057\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u3053\u308c\u3060\u3068null\u306e\u30ec\u30b3\u30fc\u30c9\u306f\u30ab\u30a6\u30f3\u30c8\u3055\u308c\u305a\u306b\u3001\u7d50\u679c\u304c2\u3068\u306a\u3063\u3066\u3057\u307e\u3044\u307e\u3059\u3002<\/p>\n<p>\u7d50\u679c\uff1a2<\/p>\n<p>&nbsp;<\/p>\n<h2>\u5bfe\u51e6\u65b9\u6cd5<\/h2>\n<p>null\u3082\u542b\u3081\u3066\u30ab\u30a6\u30f3\u30c8\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306bnull\u5024\u3092\u5225\u306e\u5024\u306b\u5909\u63db\u3057\u3066\u8a8d\u8b58\u3055\u305b\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre>SELECT COUNT(*) FROM Employee WHERE ISNULL(EmployeeCode, '') != ''<\/pre>\n<p>\u7d50\u679c\uff1a3<\/p>\n<p>&nbsp;<\/p>\n<p>\u305f\u3060\u3001\u3053\u306e\u4f8b\u306e\u5834\u5408\u3001\u30b3\u30fc\u30c9\u306bnull\u304c\u5165\u308b\u3088\u3046\u306a\u8a2d\u8a08\u81ea\u4f53\u3042\u307e\u308a\u826f\u304f\u306a\u3044\u3068\u3082\u8a00\u3048\u307e\u3059\u304c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u308c\u3001\u77e5\u3089\u306a\u304f\u3066\u76f2\u70b9\u3060\u3063\u305f\u306e\u3067\u3059\u304c\u3001 ID EmployeeCode EmployeeName 1 0010 \u6c96\u7530\u7dcf\u53f8 2 0020 \u6c38\u5009\u65b0\u516b 3 null \u658e\u85e4\u4e00 4 0040 \u677e\u539f\u5fe0\u53f8 \u4f8b\u3048\u3070\u3001\u3053\u3093\u306a\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u3063\u305f&#8230;<\/p>\n","protected":false},"author":1,"featured_media":426,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[13],"tags":[],"class_list":{"0":"post-1009","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sql-server","8":"article cf"},"_links":{"self":[{"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/posts\/1009","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/comments?post=1009"}],"version-history":[{"count":10,"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/posts\/1009\/revisions"}],"predecessor-version":[{"id":1020,"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/posts\/1009\/revisions\/1020"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/media\/426"}],"wp:attachment":[{"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/media?parent=1009"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/categories?post=1009"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ji-develop.com\/blog\/wp-json\/wp\/v2\/tags?post=1009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}