FIX: ??????? ????????? ???????? ?????? ???????? SQL Server 2000 ?? ?? ???? ??? ??? ???? ????? ??? ??? ?????? ???? ?? ??? ?????? ?????? ?????? ??? ????? ?? ???????? ???? NaN

???? ???????: 900335 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
???? Microsoft SQL Server 2000 ????????? ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2000 ?????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ???????
  • ????????? ??????? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ??????? ??????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ??????? ??? ????? ???? ??????? ??????
  • ??????? ??????? ?? ???? ????????? ???????
???? ??? ?????? | ????? ???????

???????

??? ??? ????? Microsoft SQL Server 2000 ???? ????????? ???????? ?????? ???????? SQL Server 2000 ?????? ?? ????? ????? ?????? ??.

??? ??? ???? ????? ??? ??? ?????? ???? ?? ??? ?????? ?????? ??? ????? ?? ???????? ????? ??? ???? (NaN) not ??? ?? ?? ???? ????? ????????? ???????? ????? ?????? SQL Server 2000. ?? ??? ??????? ????? ????? ???????? ???? ????????.
???? ??? ?????? | ????? ???????

????

?????? ??? ????? ?? ???? ????????? a? SQL Server 2000 Post-Service Pack ?????? ????? ???? ??????? ??????? ?? "????? ??????? ?? Microsoft:
810185
(http://support.microsoft.com/kb/810185/ )
????? ??????? ?????? SQL Server 2000 ?? SQL Server 2000 ?????? ????? ?????? Service Pack 3 ? a?
?????? ????? ??? ??????? ?????? SQL Server 2000 ?????? ????? ?????? Service Pack 3 ? SQL Server 2000 ?????? ????? ?????? Service Pack 4.

?????? ???? ??????? ?????? ??????? ???????? ???? ?? ??? ??????? ?? ???? ??? ???? ???? ??? ????? ?????? ???? NaN. ?? ??? ??????? ?????? ??? ?? ??????? ??? ??? ?????? ????? ????. ?? ??? ??????? ?? ???? ??????? ?????? ???? ?? ???? ??? ???? ????? NaN.

??????? ??????? ??????

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????.

?? ???? ????? ??????? ?????? ???? ??? "???? ????? ??????? ????" ???? ????? ????? ??????? ??? ???. ??? ?? ???? ??? ?????? ????? ??? ??? Microsoft ???? ??????? ?????? ?????? ??? ??????? ??????.

?????? ???? ?????? ?????? ?? ?? ?? ???? ?????? ??? ??????? ??????? ???????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
(http://support.microsoft.com/contactus/?ws=support)
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

????????? ????????

  • ????? ??????? Microsoft SQL Server 2000 Service Pack 3 (SP3) ?? ??? ??????? ?????? SP3 ???? ?????? ??????? ?????? 8.00.1007.
  • ????? ??????? Microsoft SQL Server 2000 ?????? ????? ?????? Service Pack 4 (SP4) ?? ??? ??????? ?????? SP4.

?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2000 ?????? ????? ?????? Service Pack 3 ? SQL Server 2000 ?????? ????? ?????? Service Pack 4 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
290211
(http://support.microsoft.com/kb/290211/ )
????? ?????? ??? ???? ???? ???? ?? SQL Server 2000

????? ????? ?????????

??? ???? ??? ????? ????? ???? ????????? ??? ????? ??? ??????? ??????.

??????? ???????

??? ???? ??? ????? ??? ??????? ??? ??????? ??? ????? ??? ??????? ??????.

??????? ??? ??????? ??????

????? ??? ??????? ?????? ??? ??????? ???????? ?????? ??????? ???????? ?? ??? ??????? ???. ?? ?? ????? ??? ??? ??????? ?????? ???? ??????? ???? ??? ?? ???? ???? ?????? ???? ????? ?????? ????? ????.

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
??????? ?? ?? ????? ?? SQL Server 2000 Service Pack 3
   Date         Time   Version            Size    File name
   --------------------------------------------------------------
   15-Apr-2005  01:07  6.1.9.0            15,872  Spupdsvc.exe
   31-May-2005  22:58                      3,842  Tempcatsign.cdf
   31-May-2005  22:41  2000.80.1027.0    664,128  Autoplt.dll
   31-May-2005  22:41  2000.80.1027.0     78,400  Console.exe
   31-May-2005  22:41  2000.80.1027.0    332,352  Ctasksui.dll
   31-May-2005  22:41  2000.80.1027.0    315,968  Custtask.dll
   31-May-2005  22:41  2000.80.1027.0     33,340  Dbmslpcn.dll
   15-Apr-2005  01:17                    786,432  Distmdl.ldf
   15-Apr-2005  01:17                  2,359,296  Distmdl.mdf
   15-Apr-2005  01:17                        180  Drop_repl_hotfix.sql
   31-May-2005  22:41  2000.80.1027.0  1,905,216  Dtspkg.dll
   31-May-2005  22:41  2000.80.1027.0    528,960  Dtspump.dll
   31-May-2005  22:41  2000.80.1027.0  1,557,052  Dtsui.dll
   31-May-2005  22:41  2000.80.1027.0    639,552  Dtswiz.dll
   31-May-2005  22:41  2000.80.1027.0    102,992  Impprov.dll
   15-Apr-2005  01:17                    747,927  Instdist.sql
   15-Apr-2005  01:17                      1,581  Inst_repl_hotfix.sql
   31-May-2005  22:41  2000.80.1027.0    352,828  Isqlw.exe
   31-May-2005  22:41  2000.80.1027.0     82,492  Itwiz.exe
   31-May-2005  22:41  2000.80.1027.0     90,692  Msgprox.dll
   15-Apr-2005  00:59  8.11.41022.0      226,304  Mssdi98.dll
   31-May-2005  22:41  2000.80.1027.0     62,024  Odsole70.dll
   31-May-2005  22:42  2000.80.1027.0     25,144  Opends60.dll
   31-May-2005  22:41  2000.80.1027.0     57,904  Osql.exe
   31-May-2005  22:41  2000.80.1027.0    279,104  Pfutil80.dll
   15-Apr-2005  01:13                    551,012  Procsyst.sql
   15-Apr-2005  01:17                     12,305  Qfe469315.sql
   15-Apr-2005  01:17                     19,195  Qfe469571.sql
   15-Apr-2005  01:17                      5,157  Qfe472197.sql
   31-May-2005  22:41  2000.80.1027.0    143,940  Qrdrsvc.exe
   31-May-2005  21:38                  1,136,160  Replmerg.sql
   31-May-2005  22:41  2000.80.1027.0    221,768  Replprov.dll
   31-May-2005  22:41  2000.80.1027.0    307,784  Replrec.dll
   31-May-2005  21:40  2000.80.1027.0    159,813  Replres.rll
   15-Apr-2005  01:17                  1,088,240  Replsys.sql
   15-Apr-2005  01:17                    986,746  Repltran.sql
   15-Apr-2005  01:17                         55  Repl_uninstall.sql
   31-May-2005  22:41  2000.80.1027.0    287,304  Rinitcom.dll
   31-May-2005  22:41  2000.80.1027.0     78,416  Sdiclnt.dll
   31-May-2005  22:41  2000.80.1027.0    823,872  Semexec.dll
   31-May-2005  22:41  2000.80.1027.0     66,112  Semmap.dll
   31-May-2005  22:41  2000.80.1027.0     57,916  Semnt.dll
   31-May-2005  22:41  2000.80.1027.0    492,096  Semobj.dll
   31-May-2005  22:05  2000.80.1027.0    172,032  Semobj.rll
   31-May-2005  22:41  2000.80.1027.0     53,832  Snapshot.exe
   15-Apr-2005  01:13                    125,540  Sp3_serv_uni.sql
   31-May-2005  22:40  2000.80.1027.0     28,672  Sqlagent.dll
   31-May-2005  22:41  2000.80.1027.0    311,872  Sqlagent.exe
   31-May-2005  22:40  2000.80.1027.0    168,001  Sqlakw32.dll
   31-May-2005  22:41  2000.80.1027.0     33,344  Sqlctr80.dll
   31-May-2005  22:41  2000.80.1027.0  4,215,360  Sqldmo.dll
   31-May-2005  22:41                     25,172  Sqldumper.exe
   31-May-2005  21:38  2000.80.1027.0     28,672  Sqlevn70.rll
   31-May-2005  22:41  2000.80.1027.0    156,224  Sqlmaint.exe
   31-May-2005  22:41  2000.80.1027.0    180,792  Sqlmap70.dll
   31-May-2005  22:41  2000.80.1027.0    188,992  Sqlmmc.dll
   31-May-2005  21:52  2000.80.1027.0    479,232  Sqlmmc.rll
   31-May-2005  22:41  2000.80.1027.0    401,984  Sqlqry.dll
   31-May-2005  22:41  2000.80.1027.0     57,920  Sqlrepss.dll
   31-May-2005  22:41  2000.80.1027.0  7,721,041  Sqlservr.exe
   31-May-2005  22:41  2000.80.1027.0    590,396  Sqlsort.dll
   31-May-2005  22:41  2000.80.1027.0     45,644  Sqlvdi.dll
   31-May-2005  22:41  2000.80.1027.0    106,588  Sqsrvres.dll
   31-May-2005  22:41  2000.80.1027.0     33,340  Ssmsgnet.dll
   31-May-2005  22:41  2000.80.1027.0     33,340  Ssmslpcn.dll
   31-May-2005  22:41  2000.80.1027.0     33,340  Ssmsqlgc.dll
   31-May-2005  22:41  2000.80.1027.0     82,492  Ssnetlib.dll
   31-May-2005  22:41  2000.80.1027.0     25,148  Ssnmpn70.dll
   31-May-2005  22:41  2000.80.1027.0    123,456  Stardds.dll
   31-May-2005  22:41  2000.80.1027.0    158,268  Svrnetcn.dll
   31-May-2005  22:41  2000.80.1027.0     76,416  Svrnetcn.exe
   31-May-2005  22:41  2000.80.1027.0     49,228  Ums.dll
   31-May-2005  22:41  2000.80.1027.0     74,304  Xplog70.dll
   31-May-2005  22:41  2000.80.1027.0     98,872  Xpweb70.dll
   31-May-2005  22:41  2000.80.1027.0     57,904  Osql.exe
   15-Apr-2005  01:07  1.0.97.0          941,056  Sqlstpcustomdll.dll
   15-Apr-2005  01:07                     23,040  Sqlstpcustomdll.rll
   15-Apr-2005  01:07  6.1.9.0           344,576  Updspapi.dll
????? 64-?? ????? ?? SQL Server 2000 Service Pack 3
   Date         Time   Version         Size        File name      Platform
   -----------------------------------------------------------------------
   31-May-2005  22:49  2000.80.1027.0      56,832  Dbmslpcn.dll   IA-64
   31-May-2005  21:52  2000.80.1027.0     528,960  Dtspump.dll    x86
   31-May-2005  21:55  2000.80.1027.0     244,736  Impprov.dll    IA-64
   31-May-2005  22:54  2000.80.1027.0     185,856  Msgprox.dll    IA-64
   31-May-2005  22:52  2000.80.1027.0     150,528  Odsole70.dll   IA-64
   31-May-2005  22:49  2000.80.1027.0      27,136  Opends60.dll   IA-64
   31-May-2005  22:52                      19,880  Opends60.lib
   31-May-2005  22:51  2000.80.1027.0     148,992  Osql.exe       IA-64
   31-May-2005  21:57  2000.80.1027.0     353,280  Qrdrsvc.exe    IA-64
   31-May-2005  23:01  2000.80.1027.0     535,552  Replprov.dll   IA-64
   31-May-2005  23:03  2000.80.1027.0     769,024  Replrec.dll    IA-64
   31-May-2005  23:09  2000.80.1027.0     650,240  Rinitcom.dll   IA-64
   31-May-2005  23:04  2000.80.1027.0     160,768  Semmap.dll     IA-64
   31-May-2005  23:04  2000.80.1027.0     132,608  Semnt.dll      IA-64
   31-May-2005  22:57  2000.80.1027.0      88,576  Snapshot.exe   IA-64
   31-May-2005  23:08  2000.80.1027.0      10,240  Sqlagent.dll   IA-64
   31-May-2005  23:10  2000.80.1027.0   1,055,232  Sqlagent.exe   IA-64
   31-May-2005  23:05  2000.80.1027.0      90,112  Sqlboot.dll    IA-64
   01-Jun-2005  01:45  2000.80.1027.0      32,256  Sqlctr80.dll   IA-64
   31-May-2005  22:50  2000.80.1027.0     812,032  Sqldata.dll    IA-64
   31-May-2005  23:27  2000.80.1027.0  13,845,504  Sqldmo.dll     IA-64
   31-May-2005  22:55                      39,936  Sqldumper.exe  IA-64
   31-May-2005  23:16  2000.80.1027.0     493,568  Sqlmaint.exe   IA-64
   31-May-2005  22:50  2000.80.1027.0      23,040  Sqlmap70.dll   IA-64
   31-May-2005  23:03  2000.80.1027.0     152,064  Sqlrepss.dll   IA-64
   01-Jun-2005  01:45  2000.80.1027.0  30,138,880  Sqlservr.exe   IA-64
   31-May-2005  22:50  2000.80.1027.0     616,960  Sqlsort.dll    IA-64
   31-May-2005  22:55  2000.80.1027.0     120,320  Sqlvdi.dll     IA-64
   31-May-2005  22:55  2000.80.1027.0     227,328  Sqsrvres.dll   IA-64
   31-May-2005  22:49  2000.80.1027.0      53,760  Ssmslpcn.dll   IA-64
   31-May-2005  23:03  2000.80.1027.0      59,904  Ssmsqlgc.dll   IA-64
   31-May-2005  22:50  2000.80.1027.0     256,000  Ssnetlib.dll   IA-64
   31-May-2005  22:51  2000.80.1027.0      20,992  Ssnmpn70.dll   IA-64
   31-May-2005  23:00  2000.80.1027.0     430,080  Svrnetcn.dll   IA-64
   31-May-2005  23:00  2000.80.1027.0     185,856  Svrnetcn.exe   IA-64
   31-May-2005  22:51  2000.80.1027.0     183,296  Xplog70.dll    IA-64
   31-May-2005  22:57  2000.80.1027.0     187,392  Xpweb70.dll    IA-64
   31-May-2005  22:55  2000.80.1027.0     146,432  Replres.rll
   31-May-2005  23:08  2000.80.1027.0      41,984  Sqlagent.rll
   31-May-2005  23:08  2000.80.1027.0     574,976  Sqldmo.rll
   31-May-2005  22:51  2000.80.1027.0      19,968  Sqlevn70.rll
   31-May-2005  23:05  2000.80.1027.0       4,096  Sqlrepss.rll
   31-May-2005  23:00  2000.80.1027.0      15,872  Svrnetcn.rll

?????? ???? ?????? ?????? ???? ????? ???? ?? ?????? ???? ????? ??? ??? ??????? ?? ????? ????? ??? ????? ??????.
???? ??? ?????? | ????? ???????

???? ??????

??????? ?????? ??? ??? ??????? ?????? ???? ????? ???????.

??????? ??????

  1. ????? NaN ????? ?????? ?? ????? ?? ??????? ?????? ??? ??????? ????????? ????????? ?? ??? (RPCs). ???? ?? ?? ?? ??? ????? ??? NaN ??? SQL Server 2000.
  2. ???????? ???????? ???? ???????? ???? ????? ??? ??? ???????? "????" ?? ??? ???????? ????????. ???? ?? ????? NaN. ?????? ????? ?? ?????? ????????? ??????: 
    SELECT <unique column list>,
 CONVERT(varchar(30),<float column or real column1>)
 FROM <table name>
 WHERE ISNUMERIC(<float column or real column>) = 0
    ?? ??? ?????????:
    • ??????? <unique column list> ?? ????? ????? ??????? ?? ???? ?????? ?????? ?????? ???? ?? ???? ???? ???? ????.
    • ??????? <table name> ???? ?????? ???? ???? ?????.
    • ??????? <float column or real column> ?? ??? ??????.
???? ??? ?????? | ????? ???????

??????? ???????

?? ??? ?????? ??????? ???? ????? ??? ??????? ???? ?? ??? ????? ???????.

??????? ???????

??? ??? ??????? ??????? ??? ???? ???? ?? ?????? ?????? ??, ????? ??? ???????? ??????? ?? ???? ???? ??? ??? ???? ?? ??? ??????.
???? ??? ?????? | ????? ???????

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".
???? ??? ?????? | ????? ???????

??????? ????

????? ????? ????? ??? NaN ???????? ????? ??? ????? ?????. ??? ????? ?? ???? ????? ??? ???? ????? ??? ???? ????? ??? ????? ??? ?????? INSERT ?? ??? ??????? ??? ?? ???? ????.

????? ??????? ??????? ??? ??? ????? ????? NaN:
  • ????????? ?????
  • ????????? ???????
  • ???? ??? ??? (0/0) ?????
  • NaNs ?????? (QNaN)
  • ????? ????? NaNs (SNaN)
????? ?? ????????? ??? NaNs ???? Intel ????? ??????? ?????? ??????. ?????? ??? ??? ?????? ?? ?????? ???? Intel ??? ??? ??????:
http://www.intel.com/design/pentiumii/manuals/243191.htm
(http://www.intel.com/design/pentiumii/manuals/243191.htm)
???? Microsoft ??????? ??? ??????? ?????? ????? ???? ???????? ?? ?????? ??? ????? ??????. ?? ??? ????? ??????? ??? ??????? ??? ???? ?????. ??? ???? Microsoft ??? ??? ????????? ???? ???????.

????? ?? ????????? ??? ???? ??????? ???????? Microsoft SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
822499
(http://support.microsoft.com/kb/822499/ )
???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ????????? ???? ???????? Microsoft ??? ????? ??????? ??? ???????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
824684
(http://support.microsoft.com/kb/824684/ )
??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft
???? ??? ?????? | ????? ???????

???????

???? ???????: 900335 - ????? ??? ??????: 21/????/1428 - ??????: 2.5
????? ???
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit
  • Microsoft SQL Server 2000 Desktop Engine (Windows)
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Workgroup Edition
????? ??????: 
kbmt kbautohotfix kbsqlserv2000presp4fix kbfix kbbug kbpubtypekc kbhotfixserver kbqfe KB900335 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????900335
(http://support.microsoft.com/kb/900335/en-us/ )
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????