FIX: ¿¬°áµÈ ¼­¹ö Äõ¸® It Å° ÁýÇÕ Ä¿¼­¸¦ ÅëÇØ ¼öÇàµÇ´Â Is °æ¿ì NULL ¹ÝȯÇÒ ¼ö ÀÖ´Ù

±â¼ú ÀÚ·á: 826860 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
±â°è ¹ø¿ªµÈ ¹®¼­±â°è ¹ø¿ª °íÁö »çÇ× º¸±â
# BUG: 470007 (SQL Server 8.0)
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

ÀÌ ÆäÀÌÁö¿¡¼­

Çö»ó

¿¬°áµÈ ¼­¹ö Äõ¸®¸¦ ÇØ´ç °á°ú ÁýÇÕÀÌ ´ÙÀ½ Á¶°Ç¿¡ ¸ðµÎ ÇØ´çÇÒ °æ¿ì ¿­¿¡ ´ëÇØ NULL ¹ÝȯÇÒ ¼ö ÀÖ½À´Ï´Ù.
  • Äõ¸®ÀÇ Å° ÁýÇÕ Ä¿¼­´Â ÅëÇØ ¼öÇàµË´Ï´Ù.
  • OUTER JOIN 2 ¶Ç´Â ´õ ¿ø°Ý Å×À̺íÀº ±â¹ÝÀ¸·Î ¼öÇàµË´Ï´Ù.
  • °¢ ¿ø°Ý Å×ÀÌºí¿¡ ´ëÇØ 4-ºÎºÐ À̸§ÀÌ »ç¿ëµË´Ï´Ù.
  • OUTER JOIN °ü·ÃµÈ ¸ðµç ¿ø°Ý Å×À̺íÀÌ °íÀ¯ À妽º°¡ ÀÖ½À´Ï´Ù.
  • OUTER JOIN Àý ³»ºÎ Å×ÀÌºí¿¡¼­ ÇàÀÌ ¹ÝȯµÇÁö ¾Ê½À´Ï´Ù.
¿¹¸¦ µé¾î, ´ÙÀ½°ú °°Àº µ¥ÀÌÅÍ°¡ ÀÖ´Ù°í °¡Á¤ÇØ º¾½Ã´Ù. 
TableA
col1 col2
---- ----
   1    1

TableB
col1 col2
---- ----
   2    2
Å° ÁýÇÕ Ä¿¼­¸¦ ÅëÇØ ´ÙÀ½ Äõ¸®¸¦ ½ÇÇàÇϸé ÀÌ ¹®Á¦°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù: 
SELECT * 
FROM rmtsvr.ownr.dbname.tableA A LEFT OUTER JOIN rmtsvr.ownr.dbname.tableB B
on A.col1=B.col1 and A.col2=B.col2
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á ¹æ¹ý

¼­ºñ½º ÆÑ Á¤º¸

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é Microsoft SQL Server 2000ÀÇ ÃֽŠ¼­ºñ½º ÆÑÀ» ±¸ÇϽʽÿÀ. ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
290211
(http://support.microsoft.com/kb/290211/ )
ÃֽŠSQL Server 2000 ¼­ºñ½º ÆÑÀ» ±¸ÇÏ´Â ¹æ¹ý

ÇÖÇȽº Á¤º¸

ÀÌ ÇÖÇȽºÀÇ ¿µ¾î ¹öÀüÀº ´ÙÀ½ Ç¥¿¡ ³ª¿­µÈ ÆÄÀÏ Æ¯¼º(¶Ç´Â ±× ÀÌÈÄÀÇ ÆÄÀÏ Æ¯¼º)ÀÌ ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ ÆÄÀÏÀÇ ½Ã°£°ú ³¯Â¥´Â UTC (ÇùÁ¤ ¼¼°è½Ã) ·Î ³ª¿­µË´Ï´Ù. ÆÄÀÏ Á¤º¸¿¡¼­´Â ÇöÁö ½Ã°£À¸·Î º¯È¯µË´Ï´Ù. UTC¿Í ·ÎÄà ½Ã°£ÀÇ Â÷À̸¦ ¾Ë·Á¸é Á¦¾îÆÇÀÇ ³¯Â¥ ¹× ½Ã°£ µµ±¸¿¡¼­ Ç¥ÁØ ½Ã°£´ë ÅÇÀ» »ç¿ëÇϽʽÿÀ.
   Date         Time    Version           Size     File name
   --------------------------------------------------------------------
   31-May-2003  18:45   2000.80.818.0     78,400   Console.exe
   25-Jun-2003  01:01   2000.80.818.0     33,340   Dbmslpcn.dll
   25-Apr-2003  02:12                    786,432   Distmdl.ldf
   25-Apr-2003  02:12                  2,359,296   Distmdl.mdf
   30-Jan-2003  01:55                        180   Drop_repl_hotfix.sql
   23-Jun-2003  22:40   2000.80.837.0  1,557,052   Dtsui.dll
   23-Jun-2003  22:40   2000.80.837.0    639,552   Dtswiz.dll
   24-Apr-2003  02:51                    747,927   Instdist.sql
   03-May-2003  01:56                      1,581   Inst_repl_hotfix.sql
   08-Feb-2003  06:40   2000.80.765.0     90,692   Msgprox.dll
   01-Apr-2003  02:07                      1,873   Odsole.sql
   05-Apr-2003  01:46   2000.80.800.0     62,024   Odsole70.dll
   07-May-2003  20:41   2000.80.819.0     25,144   Opends60.dll
   07-May-2003  18:47                    132,096   Opends60.pdb
   02-Apr-2003  21:48   2000.80.796.0     57,904   Osql.exe
   02-Apr-2003  23:15   2000.80.797.0    279,104   Pfutil80.dll
   04-Aug-2003  18:17                    550,780   Procsyst.sql
   22-May-2003  22:57                     19,195   Qfe469571.sql
   11-Jul-2003  17:04                  1,084,147   Replmerg.sql
   04-Apr-2003  21:53   2000.80.798.0    221,768   Replprov.dll
   08-Feb-2003  06:40   2000.80.765.0    307,784   Replrec.dll
   11-Jul-2003  16:56                  1,085,925   Replsys.sql
   29-Jul-2003  20:13   2000.80.819.0    492,096   Semobj.dll
   31-May-2003  18:27   2000.80.818.0    172,032   Semobj.rll
   05-Aug-2003  21:06                    127,884   Sp3_serv_uni.sql
   01-Jun-2003  01:01   2000.80.818.0  4,215,360   Sqldmo.dll
   07-Apr-2003  17:44                     25,172   Sqldumper.exe
   19-Mar-2003  18:20   2000.80.789.0     28,672   Sqlevn70.rll
   02-Jul-2003  00:18   2000.80.834.0    180,736   Sqlmap70.dll
   08-Feb-2003  06:40   2000.80.765.0     57,920   Sqlrepss.dll
   07-Aug-2003  19:11   2000.80.850.0  7,598,164   Sqlservr.exe
   07-Aug-2003  19:11                 12,755,968   Sqlservr.pdb
   25-Jul-2003  21:44   2000.80.845.0    590,396   Sqlsort.dll
   08-Feb-2003  06:40   2000.80.765.0     45,644   Sqlvdi.dll
   25-Jun-2003  01:01   2000.80.818.0     33,340   Ssmslpcn.dll
   01-Jun-2003  01:01   2000.80.818.0     82,492   Ssnetlib.dll
   01-Jun-2003  01:01   2000.80.818.0     25,148   Ssnmpn70.dll
   01-Jun-2003  01:01   2000.80.818.0    158,240   Svrnetcn.dll
   31-May-2003  18:59   2000.80.818.0     76,416   Svrnetcn.exe
   30-Apr-2003  23:52   2000.80.816.0     45,132   Ums.dll
   30-Apr-2003  23:52                    132,096   Ums.pdb
   02-Jul-2003  00:19   2000.80.834.0     98,816   Xpweb70.dll
   23-Jun-2003  22:40   2000.80.837.0  1,557,052   Dtsui.dll
   23-Jun-2003  22:40   2000.80.837.0    639,552   Dtswiz.dll
   02-Apr-2003  21:48   2000.80.796.0     57,904   Osql.exe
   02-Apr-2003  23:15   2000.80.797.0    279,104   Pfutil80.dll
   29-Jul-2003  20:13   2000.80.819.0    492,096   Semobj.dll
   31-May-2003  18:27   2000.80.818.0    172,032   Semobj.rll
   01-Jun-2003  01:01   2000.80.818.0  4,215,360   Sqldmo.dll
   07-Apr-2003  17:44                     25,172   Sqldumper.exe
   01-Jun-2003  01:01   2000.80.818.0    158,240   Svrnetcn.dll
   31-May-2003  18:59   2000.80.818.0     76,416   Svrnetcn.exe
Âü°í ÆÄÀÏ Á¾¼Ó °ü°è·Î ÀÎÇØ °¡Àå ÃÖ±ÙÀÇ ÇÖÇȽº³ª ÀÌ·¯ÇÑ ÆÄÀÏÀÌ Æ÷ÇÔµÈ ±â´ÉÀ» Ãß°¡ ÆÄÀÏÀÌ µé¾î ÀÖ½À´Ï´Ù.


Âü°í ·ÎÄà ¼­¹ö°¡ ¿ø°Ý ¼­¹ö¿¡ ÀÌ ÇÖÇȽº¸¦ Àû¿ëÇØ¾ß ÇÕ´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á °úÁ¤

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é ´ÙÀ½ ¹æ¹ý Áß Çϳª¸¦ »ç¿ëÇϽʽÿÀ.
  • Á¤Àû Ä¿¼­¸¦ ´ë½Å Å° ÁýÇÕ Ä¿¼­¸¦ »ç¿ëÇϽʽÿÀ.
  • Åë°ú Äõ¸®¸¦ ´ë½Å 4-ºÎÇ° À̸§ Äõ¸®¸¦ »ç¿ëÇϽʽÿÀ. ÀÌ·¸°Ô ÇÏ·Á¸é ´ÙÀ½ Transact-SQL ÇÔ¼ö Áß Çϳª¸¦ »ç¿ëÇϽʽÿÀ.
    • OPENQUERY
    • OPENROWSET
  • ÀÓÀÇ Äõ¸®¸¦ ´ë½Å Ä¿¼­¸¦ »ç¿ëÇϽʽÿÀ.
  • °¡´ÉÇÑ °æ¿ì °íÀ¯ À妽º¸¦ ¿ø°Ý Å×À̺íÀÇ °íÀ¯ÇÏÁö ¾ÊÀº À妽º º¯°æÇϽʽÿÀ. ÀÌ Ä¿¼­ À¯ÇüÀ» À§ÇØ Á¤Àû º¯°æµË´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇöÀç »óÅÂ

Microsoft´Â "º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù." Àý¿¡ ³ª¿­µÈ Microsoft Á¦Ç°¿¡¼­ ÀÌ ¹®Á¦¸¦ È®ÀÎÇß½À´Ï´Ù.ÀÌ ¹®Á¦´Â Microsoft SQL Server 2000 ¼­ºñ½º ÆÑ 4¿¡¼­ óÀ½ ¼öÁ¤µÇ¾ú½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

Ãß°¡ Á¤º¸

ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
824684
(http://support.microsoft.com/kb/824684/ )
Microsoft ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ®¸¦ ¼³¸íÇÏ´Â µ¥ »ç¿ëµÇ´Â Ç¥ÁØ ¿ë¾î¿¡ ´ëÇÑ ¼³¸í
À§·Î °¡±â | Çǵå¹é º¸³»±â

¼Ó¼º

±â¼ú ÀÚ·á: 826860 - ¸¶Áö¸· °ËÅä: 2007³â 11¿ù 2ÀÏ ±Ý¿äÀÏ - ¼öÁ¤: 8.3
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 2000 Desktop Engine (Windows)
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit
Å°¿öµå:?
kbmt kbhotfixserver kbqfe kbqfe kbsqlserv2000presp4fix kbfix kbbug KB826860 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù.
ÀÌ ¹®¼­ÀÇ ¿µ¹® ¹öÀü º¸±â.
À§·Î °¡±â | Çǵå¹é º¸³»±â

Çǵå¹é º¸³»±â

 
À§·Î °¡±âÀ§·Î °¡±â