FIX: ??????? SELECT ???? ??? ????? ????? ??? ??? ???? ?? ?????? ?? SQL Server 2005 ??????? Edition ??? SQL Server 2005 ??? Edition

?????? ????????? ?????? ?????????
???? ???????: 933697 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ????? ??????? SELECT ?? Microsoft SQL Server 2005 ??????? Edition ??? Microsoft SQL Server 2005 ??? Edition ????????? ???? ??? ????? ????? ??? ??? ???? ?? ??????. ???? ??? ??????? ??? ????? ???????? ?????????:
  • ????? ????????? SELECT ??? ??? ??????.
  • ??? ???????? ??????? ????? ??? ???? ??? ?????? ???????. ????? ???? ???? ??? ???? ???? ??? ?? ?? ??????? ?????? ??.
??? ???? ??????? ????? ????????? ?????? ?? SQL Server 2005 ??????? Edition:
select * from T1, T2 where T1.Col = T2.Col1 order by T1.Col
?????? ?? ??? ?????? ?????? T1 ????? ???? ??? ???? ?? ????? ????... ???? T2 ???? ??? ?????? ????1.

?????

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

????

??? ??? ???????? ?????? ???? ????? ???????:
  • ????? ???? ??? ?????? ??????? ?? ?????? ??????.
  • ??? ???? ?????? ??????? ?? ?????? ?????.
?????? ?? ?????? ?? ??? "???????" ?? ?????? ??????? ?? ?????? ?????? T2.Col1. ?????? ??????? ?? ?????? ????? ?? T1.Col.

?????

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

??????? ????

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

  1. ????? ???????? ??????? ????? ????? ?????? ?? SQL Server 2005 ??????? Edition:
    CREATE TABLE T1 (COL INT);
    GO;
    CREATE INDEX T1_IDX ON T1 (COL);
    GO;
    INSERT INTO T1 VALUES (1);
    INSERT INTO T1 VALUES (2);
    INSERT INTO T1 VALUES (3);
    GO;
    CREATE TABLE T2 (COL1 INT, COL2 INT);
    GO;
    INSERT INTO T2 VALUES (1,1);
    INSERT INTO T2 VALUES (2,2);
    INSERT INTO T2 VALUES (3,3);
    GO;
  2. ????? ??????? ???????:
    select * from T1, T2 where T1.Col = T2.Col1 order by T1.Col
    ????? ??????? ??????? ?? ??? "???????".

???????

???? ???????: 933697 - ????? ??? ??????: 23/???/1428 - ??????: 1.2
????? ???
  • Microsoft SQL Server 2005 Mobile Edition
  • Microsoft SQL Server 2005 Compact Edition
????? ??????: 
kbmt kbtshoot kbexpertiseadvanced kbbug KB933697 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????933697

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

 

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