??? SQL Server 2008 ?? ??? ?????? ???????? ???? SELECT ??? ?? ????? ??? FIX: ?????? ?????: "???????? KEY ???????? '<primarykey>' ?? ???????? ???????? ??? ????????? ????? ?? ???????? ???? ?? ???? ' <tablename>' "</tablename></primarykey>

???? ?????? ???? ??????
???? ID: 970507 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
Microsoft ?? downloadable ???? ?? ??? ??? Microsoft SQL Server 2008 ??????? ?????? ???? ??? ??????? ????? ???? ???, ??????? ?? ?? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ???
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ???????? ?? ????? ????.:
  • ???? ??? Microsoft SQL Server 2008 ??????????? ???????? ?? ??????? ???
  • ???? ??? ??????????? ???? ?? ??? ??????? ?? ?????? ?? ???????? ????? ?????? ???

    ???:????????????? ???? ?? ??? ??????? ??, ?? ???? ?? ????? ???? ?????? ?? ???? outputs ???? ??????? ?????? ?? ???::
    INSERT T1 ? SELECT T1
  • ?? ?????? ??? ?? ???? ???????????????? ???? ?? ??? ???????? ?? ???????? ?? ?? ??????? ?????? ????? ????

    ???:???????? ??? ???????? ???????? ?? ???????? subquery ?? ????? ?? ??? ?????? ??? ???????? ????
?? ?? ??? ????? ???, ???? ????? ?????? ????? ????? ??:

????? 2627, ???? 14, ????? 1
???????? KEY ???????? ?? ??????? 'PrimaryKey'. ???????? ??? ????????? ????? ?? ???????? ???? ?? ???? 'TableName'.

??? ?? ???????? ????? ?? ???? ????, ?? ?? ????????? ????? ????????? ??Eager ??????????? ?????? ??? ?????? ??Eager ??????????? ?? ??????? ????? ????? ?????????? ??? ??, ??? ??? ???? ?? ????? ???? ?????? ????? ?? ????? ?????? ???

???:?? ?????? ?? ???? ?? ?? ?? ?? ???????? ?????? ??????? ????? ?????????

????

????? ?? ??? ??? ?? ?? ???? ?? ?????? ???? ??Eager ??????????? ???? ????? ??????? ?? ???? ????????? ????? ??? ?? ??????? ?? ???? ??? ????????? ????? ?????? ???

????????

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

?? ?????? ?? ????? SQL Server 2008 ?????? ??? 1 ?? ??? ????? ?????? 3 ??? ???? ?????? ???? ??? ??? ?? ????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
971491SQL Server 2008 ?????? ??? 1 ?? ??? ????? ?????? ?????? 3
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ??? Microsoft ??????? ???? ?? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
970365SQL Server 2008 SQL Server 2008 ?????? ??? 1 ?? ?????? ???? ??? ?? ?? ??? ?????? ??? ?? ?? ????? ??
Microsoft SQL Server 2008 ?????????? ??????? SQL Server ?????? ??? ?? ??? ???? ???? ???? ?? SQL Server 2008 ?????? ??? 1 ?? ??????? ???? ?? ??? ??? SQL Server 2008 ?????? ??? 1 ???????? ?? ???? ???? ?????? ??? ???????? ??? ??, ???? ?? ???????? ???? SQL Server ?????? ??? ??? ?????? ???? ???? ?? ?? ???? SQL Server ?????? ??? ??? ????? ???

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

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

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

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

?? ???????? ?? ???? ???? ?? ??? ?? ?? ???????? ?? SQL Server 2008 ?????? ??? 1 (SP1) ?? ??? ?? ?? ???? ?????? ???

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

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

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

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

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

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

?? ????????? ?? ????????? ??????? ??? ?? ????? ????????? (?? ??? ?? ????? ?????????) ??? ?? ????? ?????? ??? ???????? ???.. ?? ??????? ?? ??? ?????? ?? ???, ??????? ????????? ??? (UTC) ??? ???????? ??.. ?? ?? ????? ??????? ????? ???, ?? ?? ??????? ??? ??? ?????? ???? ???? ??.. "UTC ?? ??????? ??? ??? ???? ????? ?? ???, ???????? ??? ??? ""?????? ?? ??? ???"" ??? """"??? ???????"" "??? ????????? ?? ??????????? ???? ??? ???? ???
??? ??????? x86-?????? ????????? ?? SQL Server 2008 ??????? ?????
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
????? ???????? ?? ???????????? ?????????????:??????????
Sqlaccess.dll2007.100.2712.0405,35213-??-200917: 53x86
Keyfile.dll2007.100.2712.013,65613-??-200915: 37x86
Sqlservr.exe2007.100.2712.042,729,32013-??-200917: 56x86
??? ??????? x86-?????? ????????? ?? SQL Server 2008 ???????? ????
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
????? ???????? ?? ???????????? ?????????????:??????????
Msmdlocal.dll10.0.2712.023,461,72013-??-200916: 08x86
Msmdsrv.exe10.0.2712.021,955,41613-??-200916: 09x86
Keyfile.dll2007.100.2712.013,65613-??-200915: 37x86
Msmdpump.dll10.0.2712.06,180,69613-??-200916: 08x86
Msmdspdm.dll10.0.2712.0178,00813-??-200916: 08x86
Msmgdsrv.dll10.0.2712.08,558,93613-??-200916: 09x86
Msolap100.dll10.0.2712.06,532,95213-??-200916: 09x86
??? ??????? x64-?????? ????????? ?? SQL Server 2008 ??????? ?????
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
????? ???????? ?? ???????????? ?????????????:??????????
Sqlaccess.dll2007.100.2712.0412,00814-??-200901: 15x86
Keyfile.dll2007.100.2712.014,18413-??-200923: 55x64
Sqlservr.exe2007.100.2712.057,873,25614-??-200901: 17x64
??? ??????? SQL Server 2008 ???????? ?????? ?? x64-?????? ?????????
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
????? ???????? ?? ???????????? ?????????????:??????????
Msmdlocal.dll10.0.2712.023,461,72013-??-200916: 08x86
Msmdlocal.dll10.0.2712.044,436,82414-??-200900: 10x64
Msmdsrv.exe10.0.2712.043,713,36814-??-200900: 10x64
Keyfile.dll2007.100.2712.014,18413-??-200923: 55x64
Msmdpump.dll10.0.2712.07,430,48814-??-200900: 10x64
Msmdspdm.dll10.0.2712.0178,02414-??-200900: 10x86
Msmgdsrv.dll10.0.2712.08,558,93613-??-200916: 09x86
Msmgdsrv.dll10.0.2712.012,332,37614-??-200900: 11x64
Msolap100.dll10.0.2712.06,532,95213-??-200916: 09x86
Msolap100.dll10.0.2712.08,153,94414-??-200900: 11x64
??? ??????? SQL Server 2008 ??????? ????? ?? ???????-?????? ????????? ?? ???
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
????? ???????? ?? ???????????? ?????????????:??????????
Sqlaccess.dll2007.100.2712.0398,69613-??-200917: 01x86
Keyfile.dll2007.100.2712.019,30413-??-200915: 26IA-64
Sqlservr.exe2007.100.2712.0111,042,40813-??-200917: 08IA-64
??? ??????? SQL Server 2008 ???????? ?????? ?? Itanium-?????? ????????? ?? ???
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
????? ???????? ?? ???????????? ?????????????:??????????
Msmdlocal.dll10.0.2712.023,461,72013-??-200916: 08x86
Msmdlocal.dll10.0.2712.057,508,18413-??-200915: 44IA-64
Msmdsrv.exe10.0.2712.058,860,88813-??-200915: 46IA-64
Keyfile.dll2007.100.2712.019,30413-??-200915: 26IA-64
Msmdpump.dll10.0.2712.08,943,44813-??-200915: 45IA-64
Msmdspdm.dll10.0.2712.0178,00813-??-200915: 45x86
Msmgdsrv.dll10.0.2712.015,485,80013-??-200915: 47IA-64
Msmgdsrv.dll10.0.2712.08,558,93613-??-200916: 09x86
Msolap100.dll10.0.2712.010,065,24013-??-200915: 47IA-64
Msolap100.dll10.0.2712.06,532,95213-??-200916: 09x86

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

?? ?????? ?? ?? ???? ?? ??? MAXDOP ?????? ????? ?? ??? ???? ?? ??? MAXDOP ??????1?? ??? ?? ????? ?????

???:????? ???? MAXDOP ?????? ????? ?? ???? ???? ??? ??????? ?? ??????????? ?? ???????? ???? ???

??????

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

??????

???? ??????? ?? ??? ????????? Servicing ???? SQL ????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
935897?? ????????? Servicing ???? ?? SQL Server ??? ?? ??????? ?? ?? ???????? ?? ??? ?? ???????? ?? ?????? ???? ?? ??? ?????? ??


SQL ????? ?????? ?? ??? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
822499Microsoft SQL Server ?????????? ?????? ???????? ?? ??? ??? ?????? ??????


?????????? ?????? ???????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
824684Microsoft ?????????? ???????? ?? ????? ???? ?? ??? ????? ?? ???? ???? ???? ???????? ?? ?????

???

???? ID: 970507 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Workgroup
??????: 
kbsurveynew kbfix kbqfe kbexpertiseadvanced kbHotfixServer kbmt KB970507 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:970507

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

 

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