# FIX: ????? ??? ????? ??? ????? ??? ????? ??????? ??????? ???? 3.5 Compact ???? SQL

?????? ?????????
?????
???? ???????: 2494715
????? ???? | ?? ????

## ???????

??? ????? ??????? ?? ????? ????? ?????? Microsoft SQL Server ??? 3.5? ??? ????? ????? ??? ?????. ???? ??? ??????? ????? ????? ????????? ??? ???? ??? ??? ????. ??? ??????? ?? ??? ??????? ???????? ? ? OR? ????????? ??? ?? ??? ??????? ????? ???????:
• ??? ????????? ?? ? ???? ??????? ?? ????? ?? ????? ????? ??? OR ???? ?????.
• ????????? ??OR????? ???? ????? ?????? ???? ??? ??? ??????. ?????? ???? ??????? ???? ???? ???? ?????? ?? ?????????.
• ????? ???? ?? ????? ????? ????? ??? ???? ??? ???? ?????? ??? ?????? ??????? ?? ?????? ???? ?? ?????? ?? ???? ????? ?????? ?????? ?? ??? ???????. ?????? ?????? ???? ???? ????????? ??? ??? ???????.
??? ???? ??????? ????? ?? ???? ?????? ??????? ??????? ???? ?????? ?? ????? ?????? 3.5 ??? ? SQL Server.
```CREATE TABLE T1( C1 int, C2 int ) GO CREATE INDEX IND_T1 ON T1 (C1, C2) GO CREATE TABLE T2( C1 int, C2 int ) GO CREATE INDEX IND_T2 ON T2 (C1, C2) GO INSERT INTO T1 VALUES (1, 0) GO INSERT INTO T1 VALUES (2, 0) GO INSERT INTO T2 VALUES (1, -1) GO INSERT INTO T2 VALUES (2, 0) GO```
?? ????? ????? ????????? ??????:
```SELECT T1.C1 [T1.C1], T1.C2 [T1.C2], T2.C1 [T2.C1], T2.C2 [T2.C2] FROM T1 INNER JOIN T2 ON T1.C1 = T2.C1 AND (T1.C2 = T2.C2 OR T2.C2 = -1) GO```
??? ????? ?????????? ???? ????? ??????? ??????? ??? ?????:
?? ??? ??????????? ??? ??????
 T1.C1 T1.C2 T2.C1 T2.C2 2 0 2 0
??? ???? ????? ??????? ???????:
?? ??? ??????????? ??? ??????
 T1.C1 T1.C2 T2.C1 T2.C2 1 0 1 -1 2 0 2 0
?????????? ??? ??????? ???? ??? ??????????????? ?????? ???? ??? ??? ?????? ??? ???????. ??? ???? ??????? ???? ??? ??????? ???? ??? ????? ?????? ????????? ??????:
```SELECT T1.C1 [T1.C1], T1.C2 [T1.C2], T2.C1 [T2.C1], T2.C2 [T2.C2] FROM T1 INNER JOIN T2 ON T1.C1 = T2.C1 WHERE T1.C2 = T2.C2 OR T2.C2 = -1 GO```

## ????

??? ????? ??????? ???? ??? ??? ??????? ?? ???? ??????? ???????? 4 ? SQL Server ??? 3.5 Service Pack 2.

?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? 4 ? SQL Server ??? 3.5 Service Pack 2? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2516828 ??????? ???????? 4 ? SQL Server ??? 3.5 Service Pack 2

## ???? ??????

??? ???? ??? ??? ???????, ??? ????? ????????? ???????? ????? ????? ???????:

#### ??????? ??????

?????? ??????? ?????? ?? ????????? ?????? ???????. ??? ???? ??????? ?? ?????? ????????? ?????? ?????? ???????:
```SELECT T1.C1 [T1.C1], T1.C2 [T1.C2], T2.C1 [T2.C1], T2.C2 [T2.C2] FROM T1 INNER JOIN T2 WITH (INDEX(0)) ON T1.C1 = T2.C1 AND (T1.C2 = T2.C2 OR T2.C2 = -1) GO ```

#### ??????? ???????

?????? ??????? ????????? ????? ???????? ?????? ???? ??? ???????? ?? ?????? "Symptoms":
```SELECT T1.C1 [T1.C1], T1.C2 [T1.C2], T2.C1 [T2.C1], T2.C2 [T2.C2] FROM T1 INNER JOIN T2 ON (T1.C1 = T2.C1 AND T2.C2 = -1) OR (T1.C1 = T2.C1 AND T1.C2 = T2.C2)```

## ?????

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

## ???????

???? ???????: 2494715 - ????? ??? ??????: 23/????? ??????/1432 - ??????: 2.0
##### ????? ??????:
kbfix kbqfe kbexpertiseadvanced kbsurveynew kbmt KB2494715 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2494715