???? ID: 288095 - ????? ???????: 03 ?????? 2010 - ??????: 2.0

????? ???????? ???? ?? ?? ?? ???? ?????? ??? ?? IN ?? SQL ????? ??? ??? NOT IN ??? ?? ???? ???? ??? ??? ?????? ?????

???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
# BUG: 235727 (shiloh_bugs)
# BUG: 58274 (sqlbug_70)
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

?????? ?? IN ?? ??? NOT IN ??? ?? ???? ???? (????) ?? ?? ??? ?????? ??? ?? ??? ???? ????? ???????? ????? ?? ???? ??? ?????? ?? ???, ????? ?????? ?????? ???? ????? ????????:
SELECT max(au_id) FROM authors WHERE au_id IN(1,2,5,......,11571)  
-- Query contains over 11570 arguments.
SQL ????? ?????? ??? ??? ????? ?? ???? ??????? ?? ?? ????? ???????? ???? ??:
2000-08-10 12:02:37.87 spid51    08/10/00 12:02:37 Stack Overflow Dump not possible - Exception c00000fd E at 0x00587286
2000-08-10 12:02:37.87 spid51    Address=587286 Exception Code = c00000fd
2000-08-10 12:02:37.87 spid51    eax=195922d0 ebx=19592338 ecx=2ad0e938 edx=00000007
2000-08-10 12:02:37.87 spid51    esi=196ce2c8 edi=19592180 eip=00587286 esp=2ac93000
2000-08-10 12:02:37.87 spid51    ebp=2ac93028 efl=00010202
2000-08-10 12:02:37.87 spid51    cs=1b ss=23 ds=23 es=23 fs=38 gs=0
2000-08-10 12:02:37.87 spid51    1: Return Address 00587286
2000-08-10 12:02:37.87 spid51    2: Return Address 0058728B.................
??? ?????? ???, SQL ????? ?? ??? ??? ??? ?????? ?? ????? ???????? ?????? ??? ?? ???? ?? ???? ???
????? ?? ???? ????

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

?????? ????????? ?? ??? ?? ?? IN ??? ?? ????? ???? ?? ???? IN ???? ??? ????? ???? ?? ??? ??? #temp ?????? ?? ????? ????? ?????? ?? ???, ???? ?????? ?? ??? re-written ?? ???? ???:
CREATE TABLE #IN_values (au_id char(4))
INSERT INTO #IN_values select au_id FROM Table_with_values_123456789...

SELECT max(au_id)
FROM authors as A
JOIN #IN_values as I ON (A.au_id = I.au_id)
????? ?? ???? ????

??????

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

???? ???????

??????? ?????????? ???? ???? ??? ??, ????? ?? ?????? ????? ? ???? ??:
????? ?????: 8621, ???? 17, ?????? 1, ?????? 2 ?????? ?????? ???????? ??????: ???? ?? ?????? ???????? ?? ????? ????? ?? ???? ?????? ???????????? ?? ??????
????? ?? ???? ????
???? ???? ???? ??:
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ?? ???? ????
??????: 
kbprb kbpending kbmt KB288095 KbMthi
????? ?? ???? ????
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:288095  (http://support.microsoft.com/kb/288095/en-us/ )
????? ?? ???? ????