????? ????? FIX: ?? SQL Server 2008 ??? ????? ????? INSERT SELECT ??? ????: "?????? ????? PRIMARY KEY '<primarykey>'. ?? ???? ????? ????? ???? ?? ?????? '<tablename>' "

?????? ????????? ?????? ?????????
???? ???????: 970507 - ??? ???????? ???? ????? ????? ??? ???????.
Microsoft ?????? ????????? Microsoft SQL Server 2008 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

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

    ?????? ????? INSERT SELECT ?? ?????? ???? ????? ???????? ?? ??? ?????? ????? ????????. ??? ???? ??????:
    INSERT T1 ? SELECT T1
  • ???? ??????? ?????? ?? ??? INSERT SELECT. ????? ??? ??????? ???? ????.

    ?????? ??? ??????? ????? ??????? ?? ????? FROM ?? ??????? ???? ??? ?????? ????? ?? ??? ??? "??" ????????? ??????.
??? ????? ??????? ????? ????? ????? ???????:

msg 2627 ? ??????? 14 ???? 1
?????? ????? PRIMARY KEY PrimaryKey. ?? ???? ????? ????? ???? ?? ?????? ' TableName '.

??? ??? ??? ??????? ? ??? ??? ???? ??? ? ???? ????? ??????? Eager ????? ?? ??? ?????. ???? ??? ?????? ??????? Eager ??? ???? ????? ???. ???????? ??? ???? ?? ?????? ???? ????? ???????? ?? ??????? ??????? ???????? ?????.

?????? ???? ??? ??????? ????? ??? ????? UPDATE SELECT ?? ????? DELETE SELECT.

?????

???? ??? ??????? ????? ????? ??? ?? ??????? ?????? ???? ????? ??????? Eager ??? ?????? ??????? ?????? ???? ???? ??? ?? ?????. ???? ??? ?????? ????? ????? ?????.

????

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

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 3 ?? SQL Server 2008 ?????? ????? ?????? Service Pack 1. ????? ?? ????????? ??? ???? ??????? ???????? ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
971491???? ??????? ???????? 3 SQL Server 2008 ?????? ????? ?????? Service Pack 1
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? Microsoft ?????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
970365???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 ?????? ????? ?????? Service Pack 1
Microsoft SQL Server 2008 ??? ????? ????????? ??????? ??? ???? SQL Server ?????. ??? ????? ??????? ???? SQL Server 2008 ?????? ????? ?????? Service Pack 1 ??? ????? SQL Server 2008 ?????? ????? ?????? Service Pack 1. ???? ???????? ??? ????? ????????? ??????? ???????? ?? ???? ???? ?? SQL Server ?? ???? ???? ?? SQL Server ???????.

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

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

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

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

?????? ??? ??????? ??????? ??? ?? ???? ???? ??????? ???? ????? ??????? SQL Server 2008 ?????? ????? ?????? Service Pack 1 (SP1).

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

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

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
??????? ????? ????????? ???????? ??? x86 ?? ???? ????? ?????? ?? SQL Server 2008 x
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Sqlaccess.dll2007.100.2712.0405,35213 ???? 200917: 53x 86
Keyfile.dll2007.100.2712.013,65613 ???? 200915: 37x 86
Sqlservr.exe2007.100.2712.042,729,32013 ???? 200917: 56x 86
??????? ????? ????????? ???????? ??? x86 ?? SQL Server 2008 Analysis Services x
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Msmdlocal.dll10.0.2712.023,461,72013 ???? 200916: 08x 86
Msmdsrv.exe10.0.2712.021,955,41613 ???? 200916: 09x 86
Keyfile.dll2007.100.2712.013,65613 ???? 200915: 37x 86
Msmdpump.dll10.0.2712.06,180,69613 ???? 200916: 08x 86
Msmdspdm.dll10.0.2712.0178,00813 ???? 200916: 08x 86
Msmgdsrv.dll10.0.2712.08,558,93613 ???? 200916: 09x 86
Msolap100.dll10.0.2712.06,532,95213 ???? 200916: 09x 86
??????? ????? ????????? ???????? ??? 64 ?? SQL Server 2008 ????? Engine x
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Sqlaccess.dll2007.100.2712.0412,008?? ???? 200901: 15x 86
Keyfile.dll2007.100.2712.014,18413 ???? 200911: 55x 64
Sqlservr.exe2007.100.2712.057,873,256?? ???? 200901: 17x 64
??????? ????? ????????? ???????? ??? 64 ?? SQL Server 2008 Analysis Services ??? x
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Msmdlocal.dll10.0.2712.023,461,72013 ???? 200916: 08x 86
Msmdlocal.dll10.0.2712.044,436,824?? ???? 200900: 10x 64
Msmdsrv.exe10.0.2712.043,713,368?? ???? 200900: 10x 64
Keyfile.dll2007.100.2712.014,18413 ???? 200911: 55x 64
Msmdpump.dll10.0.2712.07,430,488?? ???? 200900: 10x 64
Msmdspdm.dll10.0.2712.0178,024?? ???? 200900: 10x 86
Msmgdsrv.dll10.0.2712.08,558,93613 ???? 200916: 09x 86
Msmgdsrv.dll10.0.2712.012,332,376?? ???? 200900: 11x 64
Msolap100.dll10.0.2712.06,532,95213 ???? 200916: 09x 86
Msolap100.dll10.0.2712.08,153,944?? ???? 200900: 11x 64
??????? ????? ????????? ???????? ??? Itanium ?? SQL Server 2008 ????? Engine ????????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Sqlaccess.dll2007.100.2712.0398,69613 ???? 200917: 01x 86
Keyfile.dll2007.100.2712.019,30413 ???? 200915: 26IA-64
Sqlservr.exe2007.100.2712.0111,042,40813 ???? 200917: 08IA-64
??????? ????? ????????? ???????? ??? Itanium ?? SQL Server 2008 Analysis Services ????????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Msmdlocal.dll10.0.2712.023,461,72013 ???? 200916: 08x 86
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: 45x 86
Msmgdsrv.dll10.0.2712.015,485,80013 ???? 2009??: ??IA-64
Msmgdsrv.dll10.0.2712.08,558,93613 ???? 200916: 09x 86
Msolap100.dll10.0.2712.010,065,24013 ???? 2009??: ??IA-64
Msolap100.dll10.0.2712.06,532,95213 ???? 200916: 09x 86

???? ??????

??????? ?????? ??? ??? ??????? ?? ?????? ?????? MAXDOP ?? ????? ????????? MAXDOP ??? 1 ?? ??????? ?? ????? ??????.

?????? ????? ?????? ?????? MAXDOP ???? ??? ???? ???? ??????????? ???? ???? ??? ??????.

?????

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

?????

????? ?? ????????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
935897????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????


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


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

???????

???? ???????: 970507 - ????? ??? ??????: 02/?????/1430 - ??????: 2.0
????? ???
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Workgroup
????? ??????: 
kbmt kbsurveynew kbfix kbqfe kbexpertiseadvanced kbhotfixserver KB970507 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????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