FIX: UNION MERGE ?? ??? ????????? ?? ??? ???? ?????? UNION

?????? ????????? ?????? ?????????
???? ???????: 295037 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 351918 (SHILOH_BUGS)
????? ???? | ?? ????

?? ??? ??????

???????

??? ????? ??????????? ???? ?????? ???? ?? 20 ?????? ????? UNION ALL ?? ????? ????? ????? ?? UNION ??? ???? ?????? ? ????? ???? ??????? ????? ????? ??? ????? ?? ??? ?????????. implication ??? ?? ??? ????? ????? ???? ??? ????? 24 ?? ??? ?????? ? ??? ?????? ?? ????? ??? ??? ????? 20.

????

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

???? ??????

??? ?????? ???????? ????? ??????? UNION ??? ??? ???????. ???? ?? ?? ??? ??????? ?????? ?? ?????? ?????? ??? ??? ??? ?? ???????.

?????

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

??????? ????

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

  1. ??? ???? ?? "???? ???????".
  2. ?? ??????? ??????? ??? ????? ??? ???????.
  3. ????? ????????? ??????:
    use Northwind
    go
    select top 1 * from
    (
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders union all
    select orderid from orders 
    union all select orderid from orders
    ) xx
    order by orderid
    					
  4. ???? ??? ????? ??????? ????? ????? ????? ???????.
  5. ????? ?????? ????? ?????? ?? ?????????:
    union all select orderid from orders
    					
  6. ????? ????????? ?????? ????? ??????? ?? ??? ??? ????? ??????? ???? ?????.

???????

???? ???????: 295037 - ????? ??? ??????: 12/?????/1424 - ??????: 3.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbfix kbsqlserv2000sp1fix KB295037 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????295037

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

 

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