{"version":"1.0","image_url":null,"author_name":"aspx","categories":["MSSQL"],"url":"https://aspx.hatenadiary.org/entry/20060530/1148974273","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Faspx.hatenadiary.org%2Fentry%2F20060530%2F1148974273\" title=\"NULL \u5024\u306f\u96c6\u8a08\u307e\u305f\u306f\u305d\u306e\u4ed6\u306e SET \u6f14\u7b97\u3067\u524a\u9664\u3055\u308c\u307e\u3057\u305f\u3002\u306e\u5bfe\u51e6 - aspx\u306e\u65e5\u8a182009\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","title":"NULL \u5024\u306f\u96c6\u8a08\u307e\u305f\u306f\u305d\u306e\u4ed6\u306e SET \u6f14\u7b97\u3067\u524a\u9664\u3055\u308c\u307e\u3057\u305f\u3002\u306e\u5bfe\u51e6","width":"100%","blog_url":"https://aspx.hatenadiary.org/","blog_title":"aspx\u306e\u65e5\u8a182009","height":"190","provider_name":"Hatena Blog","published":"2006-05-30 16:31:13","type":"rich","description":"\u96c6\u8a08\u5bfe\u8c61\u5217\u306bnull\u3092\u542b\u3080\u884c\u304c\u3042\u308b\u306e\u3067\u3001MSSQL\u3055\u3093\u304c\u53d6\u308a\u9664\u3044\u3066\u96c6\u8a08\u3057\u3066\u304f\u308c\u307e\u3057\u305f\u3002 ...\u3068\u3044\u3046\u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u3088\u3046\u3067\u3059\u306d\u3002 NULL \u5024\u306f\u96c6\u8a08\u307e\u305f\u306f\u305d\u306e\u4ed6\u306e SET \u6f14\u7b97\u3067\u524a\u9664\u3055\u308c\u307e\u3057\u305f\u3002 \u306e\u691c\u7d22\u7d50\u679c \u7d04 185 \u4ef6 --SQL Server 2000 CREATE TABLE #FOO (BAR INT NULL) INSERT INTO #FOO (BAR) VALUES (20) INSERT INTO #FOO (BAR) VALUES (NULL) INSERT INTO #FOO (BAR) VALUES (50) PRINT '\u3053\u306e\u6b21\u306eSELECT\u3067\u8b66\u544a\u3055\u308c\u307e\u3059\uff1a' SELEC\u2026","author_url":"https://blog.hatena.ne.jp/aspx/"}