FIX: ????? ???? ??????? ??????? 8624 SQL ??? ????? ?? ??????

?????? ????????? ?????? ?????????
???? ???????: 286249 - ??? ???????? ???? ????? ????? ??? ???????.
BUG #: 351305 (SHILOH_bugs)
????? ???? | ?? ????

???????

?? ???? ????? UPDATE ???? ????? ??? ??????? ???? ???? ?? ???? ???? ????? ?? UNION ALL ?? ????? ????? ???????:
????: ????? 8624 ? ????? 16 ???? 21 ? ???? 2
??? ????? ?? ???? SQL.

????

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? Microsoft SQL Server 2000. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
290211INF: ????? ?????? ??? ???? ???? ???? ??????? SQL Server 2000

???? ??????

??? ??? ????? ??????? ????? ????? ????????? ???????? ??? UNION ???? ? ??? ?????? ???????? ALL.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????. ?? ????? ??? ??????? ???? ??? ?? Microsoft SQL Server 2000 Service Pack 1.

??????? ????

????? ????? ??? ?????, ????? ??? ???????? ?????:
CREATE TABLE MaxCol(
PK INT PRIMARY KEY,
f1 INT,
f2 INT,
mx INT
)
GO

UPDATE MaxCol
SET mx =
    (SELECT MAX(f)
    FROM
        (
        SELECT f1 AS f
        FROM MaxCol AS A
        WHERE A.PK=MaxCol.PK
        UNION ALL
        SELECT f2
        FROM MaxCol AS B
        WHERE B.PK=MaxCol.PK
        ) AS TU
    )
				

???????

???? ???????: 286249 - ????? ??? ??????: 20/?????/1424 - ??????: 3.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbfix kbsqlserv2000sp1fix KB286249 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????286249

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

 

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