FIX: ?? ????? ??? ????? ???? ??? ????? SQL Server 2005 ?????? ????? ?????? Service Pack 1

?????? ????????? ?????? ?????????
???? ???????: 932393 - ??? ???????? ???? ????? ????? ??? ???????.
????? #: ????????? SQL 50000820
??????
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ??????? ??? ??? ?????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????

???????

?? Microsoft SQL Server 2005 ?? ????? ??? ????? ???? ??? ????? SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1). ???? ??? ??????? ??? ????? ??????? ?? ???? ?????? ?? ???? WHERE. ??? ???? ??????? ????? ??????? ??????? ??? ???:
SELECT * FROM
(
SELECT CASE 
                  WHEN col1 IS NULL THEN  3
                  WHEN col1=0 THEN 3
                  WHEN col1=2 THEN 0
                  ELSE 3
                  END Col2
FROM T1
WHERE col3 =N'') T2
WHERE col4 in(0,1,2)

?????

???? ????? ????????? ?????? ?? SQL Server 2005 ?????? ????? ?????? SP1 ????? ??????? ?????? ??? ???? ?????? ??????. ???? ??? ?????? ??? ????? ????.

????

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

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

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

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

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

?????? ??? ??????? ??????? ??? ?? ???? ???? SQL Server 2005 ?????? ????? ?????? Service Pack 1 ?????.?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? Service Pack 1 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
??????? ?????? SQL Server 2005 ??????? ?? ??
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2223.069,488?? ?????? ????11: 46x 86
Databasemailengine.dll9.0.2223.075,120?? ?????? ????11: 46x 86
Logread.exe2005.90.2223.0400,752?? ?????? ????11: 47x 86
Microsoft.analysisservices.adomdclient.dll9.0.2223.0546,160?? ?????? ????11: 47x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2223.0140,656?? ?????? ????11: 47x 86
Microsoft.analysisservices.dll9.0.2223.01,217,904?? ?????? ????11: 47x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2223.078,192?? ?????? ????11: 47x 86
Microsoft.sqlserver.sqlenum.dll9.0.2223.0910,704?? ?????? ????11: 47x 86
Msasxpress.dll9.0.2223.024,944?? ?????? ????11: 47x 86
Msgprox.dll2005.90.2223.0200,560?? ?????? ????11: 47x 86
Msmdlocal.dll9.0.2223.015,646,064?? ?????? ????11: 47x 86
Msmdredir.dll9.0.2223.03,993,968?? ?????? ????11: 47x 86
Mssqlsystemresource.ldf??? ???? ???????524,288?? ?????? ????21: 32??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,032?? ?????? ????21: 32??? ???? ???????
Qrdrsvc.exe2005.90.2223.0369,520?? ?????? ????11: 47x 86
Rdistcom.dll2005.90.2223.0643,440?? ?????? ????11: 47x 86
Repldp.dll2005.90.2223.0187,248?? ?????? ????11: 47x 86
Replmerg.exe2005.90.2223.0320,880?? ?????? ????11: 47x 86
Replprov.dll2005.90.2223.0550,256?? ?????? ????11: 47x 86
Replrec.dll2005.90.2223.0784,752?? ?????? ????11: 47x 86
Replsub.dll2005.90.2223.0407,408?? ?????? ????11: 47x 86
Spresolv.dll2005.90.2223.0177,008?? ?????? ????11: 47x 86
Sqlaccess.dll2005.90.2223.0350,576?? ?????? ????11: 47x 86
Sqlagent90.exe2005.90.2223.0321,392?? ?????? ????11: 47x 86
Sqlservr.exe2005.90.2223.028,979,112?? ?????? ????11: 47x 86
Sysdbupg.sql??? ???? ???????218,486?? ?????? ????13: 53??? ???? ???????
Xmlsub.dll2005.90.2223.0195,440?? ?????? ????11: 47x 86
Xpstar90.dll2005.90.2223.0295,280?? ?????? ????11: 47x 86
Xpstar90.rll2005.90.2223.0155,504?? ?????? ????11: 47x 86
??????? ?????? SQL Server 2005 ????????? 64 x
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2223.088,944?? ?????? ????23: 50x 64
Databasemailengine.dll9.0.2223.075,120?? ?????? ????23: 50x 86
Logread.exe2005.90.2223.0525,168?? ?????? ????23: 51x 64
Microsoft.analysisservices.adomdclient.dll9.0.2223.0546,160?? ?????? ????23: 51x 86
Microsoft.analysisservices.adomdclient.dll9.0.2223.0546,160?? ?????? ????11: 47x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2223.0140,656?? ?????? ????11: 47x 86
Microsoft.analysisservices.dll9.0.2223.01,217,904?? ?????? ????11: 47x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2223.094,064?? ?????? ????23: 51x 64
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2223.078,192?? ?????? ????11: 47x 86
Microsoft.sqlserver.sqlenum.dll9.0.2223.0877,936?? ?????? ????23: 51x 86
Msasxpress.dll9.0.2223.030,064?? ?????? ????23: 51x 64
Msasxpress.dll9.0.2223.024,944?? ?????? ????11: 47x 86
Msgprox.dll2005.90.2223.0262,000?? ?????? ????23: 51x 64
Msmdlocal.dll9.0.2223.015,646,064?? ?????? ????11: 47x 86
Msmdredir.dll9.0.2223.03,993,968?? ?????? ????11: 47x 86
Mssqlsystemresource.ldf??? ???? ???????524,288?? ?????? ????21: 32??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,032?? ?????? ????21: 32??? ???? ???????
Qrdrsvc.exe2005.90.2223.0434,032?? ?????? ????23: 51x 64
Rdistcom.dll2005.90.2223.0836,464?? ?????? ????23: 51x 64
Repldp.dll2005.90.2223.0237,936?? ?????? ????23: 51x 64
Repldp.dll2005.90.2223.0187,248?? ?????? ????11: 47x 86
Replmerg.exe2005.90.2223.0417,648?? ?????? ????23: 51x 64
Replprov.dll2005.90.2223.0747,888?? ?????? ????23: 51x 64
Replrec.dll2005.90.2223.01,011,056?? ?????? ????23: 51x 64
Replsub.dll2005.90.2223.0528,240?? ?????? ????23: 51x 64
Spresolv.dll2005.90.2223.0225,648?? ?????? ????23: 51x 64
Sqlaccess.dll2005.90.2223.0357,744?? ?????? ????23: 51x 86
Sqlagent90.exe2005.90.2223.0392,560?? ?????? ????23: 51x 64
Sqlservr.exe2005.90.2223.039,268,208?? ?????? ????23: 51x 64
Sysdbupg.sql??? ???? ???????218,486?? ?????? ????13: 53??? ???? ???????
Xmlsub.dll2005.90.2223.0319,856?? ?????? ????23: 51x 64
Xpstar90.dll2005.90.2223.0543,600?? ?????? ????23: 51x 64
Xpstar90.rll2005.90.2223.0156,016?? ?????? ????23: 51x 64
??????? ?????? SQL Server 2005 ????????? ????? Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Bcp.exe2005.90.2223.0157,552?? ?????? ????01: 55IA-64
Databasemailengine.dll9.0.2223.075,120?? ?????? ????01: 55x 86
Logread.exe2005.90.2223.01,098,096?? ?????? ????01: 56IA-64
Microsoft.analysisservices.adomdclient.dll9.0.2223.0546,160?? ?????? ????11: 47x 86
Microsoft.analysisservices.adomdclient.dll9.0.2223.0546,160?? ?????? ????01: 56x 86
Microsoft.analysisservices.deploymentengine.dll9.0.2223.0140,656?? ?????? ????11: 47x 86
Microsoft.analysisservices.dll9.0.2223.01,217,904?? ?????? ????11: 47x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2223.078,192?? ?????? ????11: 47x 86
Microsoft.sqlserver.mgdsqldumper.dll2005.90.2223.0165,744?? ?????? ????01: 56IA-64
Microsoft.sqlserver.sqlenum.dll9.0.2223.0877,936?? ?????? ????01: 56x 86
Msasxpress.dll9.0.2223.024,944?? ?????? ????11: 47x 86
Msasxpress.dll9.0.2223.057,712?? ?????? ????01: 56IA-64
Msgprox.dll2005.90.2223.0545,136?? ?????? ????01: 56IA-64
Msmdlocal.dll9.0.2223.048,718,704?? ?????? ????01: 56IA-64
Msmdredir.dll9.0.2223.06,249,328?? ?????? ????01: 56IA-64
Mssqlsystemresource.ldf??? ???? ???????524,288?? ?????? ????21: 32??? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,108,032?? ?????? ????21: 32??? ???? ???????
Qrdrsvc.exe2005.90.2223.0943,984?? ?????? ????01: 56IA-64
Rdistcom.dll2005.90.2223.01,884,016?? ?????? ????01: 56IA-64
Repldp.dll2005.90.2223.0187,248?? ?????? ????11: 47x 86
Repldp.dll2005.90.2223.0511,344?? ?????? ????01: 56IA-64
Replmerg.exe2005.90.2223.0957,296?? ?????? ????01: 56IA-64
Replprov.dll2005.90.2223.01,619,824?? ?????? ????01: 56IA-64
Replrec.dll2005.90.2223.02,144,112?? ?????? ????01: 56IA-64
Replsub.dll2005.90.2223.01,159,536?? ?????? ????01: 56IA-64
Spresolv.dll2005.90.2223.0498,032?? ?????? ????01: 56IA-64
Sqlaccess.dll2005.90.2223.0352,112?? ?????? ????01: 56x 86
Sqlagent90.exe2005.90.2223.01,143,664?? ?????? ????01: 56IA-64
Sqlservr.exe2005.90.2223.072,190,832?? ?????? ????01: 56IA-64
Sysdbupg.sql??? ???? ???????218,486?? ?????? ????13: 53??? ???? ???????
Xmlsub.dll2005.90.2223.0593,264?? ?????? ????01: 56IA-64
Xpstar90.dll2005.90.2223.0953,712?? ?????? ????01: 56IA-64
Xpstar90.rll2005.90.2223.0154,992?? ?????? ????01: 56IA-64

?????

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

??????? ????

????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 932393 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 1.4
????? ???
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems Community Technology Preview
????? ??????: 
kbmt kbautohotfix kbsql2005tsql kbsql2005engine kbfix kbhotfixserver kbqfe kbpubtypekc KB932393 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????932393

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com