FIX: ??? ????????? ???? ??? ?????? ORDER BY ?? SQL Server 2008 ??????? ??????? ????? ?? ????? ??????

?????? ????????? ?????? ?????????
???? ???????: 926292 - ??? ???????? ???? ????? ????? ??? ???????.

SQL Server 2008

Microsoft ?????? ????????? Microsoft SQL Server 2008 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.

SQL Server 2005

Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ?? ????????? ??? ????? ?????? ????????? ???? ?? ??????? ??? ????? SQL ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
957826??? ????? ?????? ??? ???? ?? ????????? ??? SQL Server 2008 ???? ???? ?? ??????? ??? SQL Server 2008 ? ???? SQL Server 2005 ???? ?? ??????? ??? SQL Server 2005 ?????? ????? ?????? SP2
????? ???? | ?? ????

?? ??? ??????

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

???????

???? ????? ??? ?? ????? ?????? ?? SQL Server 2005 ?? SQL Server 2008. ?? ????? ????? ????? ????? SELECT ???? ????????? ???????:
  • ????? SELECT ?????? ??????? (100) PERCENT TOP.
  • ?????? ????? SELECT ORDER BY.
??? ????????? ?? ???? ????? ??? ??? ????? ??????? ?? ????? ??????.

??? ???? ????? ??? ?????? ?? Microsoft SQL Server 2000. ??? ????? ??????? ?? SQL Server 2000 ???????? ???? ?? ?????? ?? ????? ORDER BY.

SQL Server 2008

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 1. ????? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? ?? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956717???? ??????? ???????? 1 ?? SQL Server 2008
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956909???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008

SQL Server 2005

???? ??????? ?? ??? ??????? ??????. ?? ????? ????? ???? ???? ??????? ??? ???? ????? SQL Server 2005. ?? ????? ??????? ?????? ???? ??????? ??? SQL Server 2005 Service Pack 2 (SP2). ??? ??? ???? ?????? ???? ????? SQL Server 2005 ????? ??????? ?????? ?????? ?? ??? ??????? (???? 1554). ??? ??? ???? ?????? SQL Server 2005 ?????? ????? ?????? SP2 ????? ???? ??????? ???????? 2 SQL Server 2005 ?????? ????? ?????? SP2 (???? 3175). ??? ??? ???? ?????? SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1) ????? SQL Server 2005 ?????? ????? ?????? SP2 ?? ?? ?????? ???? ??????? ???????? 2 ?? SQL Server 2005 ?????? ????? ?????? SP2 (???? 3175). ???? ??????? ???????? 2 SQL Server 2005 ?????? ????? ?????? SP2 (???? 3175) ?????? ?? ????? "????? ??????? ?? Microsoft" 936305. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
936305????? ???? ??????? ???????? 2 SQL Server 2005 ?????? ????? ?????? SP2

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

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

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

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

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

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

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

??? ????? ????? ???? SQL Server ??? ????? ??? ??????? ??????.

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

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

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

???? ??? ??????? ?????? ????? ???? 168. ??? ????? ??? ??????? ??????? ??? ????? ?????? ????? 168. ?????? ??? ??????? ??? ????? ????? ????? ???? ?? SQL Server 2005 ???? ??? "?????" ?? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms188396.aspx
???????? ??? ???? ???? ????? ????? ????? ????? ???????? ???? ????? ??? ????? ????? ??? 80.

?????? ????? ????? ???? ??????? ???????:
  1. ??? Studio ????? ???? SQL ?? ?? ?????? ??? ???? SQL Server 2005.
  2. ???? ??? ?????? ?????? ??? ????? ???????? ???? ????? ??? ????? ????? ?? ???? ??? ?????.
  3. ?? ??? ????? ???? ? ???? ??? ??????.
  4. ?? ????? ????? ????? ??? SQL Server 2000 (80).
?????? ??? ????? ????? ???? 168 ??? ????? ????? ???????? ??? SQL Server 2005. ??? ?? ????? ????? ???? 168 ??? ????? ????? ???????? ? ???? ????? ????????? ?? ??? ?????.

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Logread.exe2005.90.1554.0397,088????? ?????? ????16: 06x 86
Microsoft.sqlserver.replication.dll2005.90.1554.01,608,480????? ?????? ????16: 06x 86
Microsoft.sqlserver.smo.dll9.0.1554.01,559,328????? ?????? ????16: 06x 86
Microsoft.sqlserver.sqlenum.dll9.0.1554.0895,776????? ?????? ????16: 06x 86
Msmdlocal.dll9.0.1554.015,626,528????? ?????? ????16: 08x 86
Msmdredir.dll9.0.1554.03,929,888????? ?????? ????16: 08x 86
Osql.exe2005.90.1554.051,488????? ?????? ????16: 04x 86
Replrec.dll2005.90.1554.0781,088????? ?????? ????16: 06x 86
Sqlaccess.dll2005.90.1554.0349,472????? ?????? ????16: 06x 86
Sqldiag.exe2005.90.1554.0960,288????? ?????? ????16: 06x 86
Sqlservr.exe2005.90.1554.028,791,640????? ?????? ????16: 08x 86

?????

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

SQL Server 2008

?????? ??? ???? ?? ????????? ??? ????? ?? ?? ??????? ? ?????? ??? ??????? ??? ??? ??????? ????? ?????? ???? ??????? ???????? ???? ????? ??? ??????? ?????? ?????? ?? ????? "????? ??????? ?? Microsoft" ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956717???? ??????? ???????? 1 ?? SQL Server 2008

SQL Server 2005

??? ??? ?????? ??? ??????? ?????? ??? SQL Server 2005 ??? ????? ??? ??????? ?? SQL Server 2000 ??? SQL Server 2005 ????? ??? ??????? ?????? ??????? ???? ?? SQL Server 2005. ??? ???? ??????? ????? ?????? ??? ???????? ?? ????? ???? ?? ?????. ?????? ????? ??? ???? ??????? ORDER BY ?? ????? SELECT ???? ???????? ?? ????????? ?? ???? ????? ???. ??? ????? ??? ??????? ?????? ????? ??????? ????? ??? ????? ??????? ?? ?????.

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

??? ????? ??????? ???? ????? ????? ???? 168 ?????? ????? ????? ????? ???????? ??? ???? ??? 90.

?????

?????? ??? ???? ?? ????????? ??? ??????? ????????? ???? ????? ??? ????? SQL Server 2008 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
956909???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008
????? ?? ????????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935897????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft
?????? ??? ???? ?? ????????? ??? ????? ????? ????? ?????? ?? SQL Server 2005 ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/ms178653.aspx
????? ?? ????????? ??? ????? ????? ?????? ??? ??????? ?????? ?? SQL Server 2005 ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/ms345416.aspx
?????? ??? ???? ?? ????????? ??? ????? ??????? ?????? ??? ????? ???? SQL Server ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/ms190737.aspx

???????

???? ???????: 926292 - ????? ??? ??????: 19/?????/1429 - ??????: 5.0
????? ???
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
????? ??????: 
kbmt kbautohotfix kbhotfixserver kbfix kbexpertiseadvanced kbqfe kbpubtypekc KB926292 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????926292

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

 

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