FIX: ????? ??? ????? ?? ??? ? ?????? ????? ?????

?????? ????????? ?????? ?????????
???? ???????: 282243 - ??? ???????? ???? ????? ????? ??? ???????.
BUG #: 351225 (SHILOH_bugs)
????? ???: 100900 (sqlbug_70)
????? ???? | ?? ????

?? ??? ??????

???????

??? ??????? ????? ??? ?????? ??? ??????? ???? correlated ?? ????? ????? ??? ???? ????? ??? ?????? ???? ?? ??????? ??? ????? ?? ????? ????? ?? ??? ????? ???? ???????? ??? ?????? ???? ??????? ?????? ?? ????? ?????? ?? ????? ??????? ??????, ?? ??? ????? ????? ??? ?????. ?????? ???? ??? ??????? ??????? ???????? ??? ?????? ?????? ?????? ????? ?? ?????? ??????.

?????

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

????

SQL Server 2000

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

SQL Server 7.0

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? Microsoft SQL Server 7.0. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
301511INF: ????? ?????? ??? ???? ???? ???? ??????? SQL Server 7.0
??????: ?? ?????? ?? ??????? ?????? ?????? ??? ??? Microsoft SQL Server 7.0 ?????? ????? ?????? Service Pack 4.

??? ?? ???? ?????? ?????????? ?? ??? ??????? ???? ??????? ??????? ?? ????:
   Version      File name      Platform
   ----------------------------------------------------

   7.00.0919    s70919i.exe    x86        SP2-based fix
   7.00.0919    s70919a.exe    Alpha      SP2-based fix

   7.00.0970    s70970i.exe    x86        SP3-based fix
   7.00.0970    s70970a.exe    Alpha      SP3-based fix
				
??????: ???? ?????? ?????? ???? ????? ???? ?? ?????? ???? ????? ??? ??????? ??????? ?? ????? ????? ??? ????? ??????.

?????

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

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

SQL Server 7.0
?? ????? ??? ??????? ???? ??? ?? Microsoft SQL Server 7.0 ?????? ????? ?????? Service Pack 4.

??????? ????

???????? ????? ?????? ???? ???????. ??? ????? ??????? ???????? ????? ????? ???? ?? TestCode ?? '???' ????? ?? ?? ???? ?? ?????? ??????? '' ? ??????? 'A'.
CREATE TABLE #tblIDs(TestID int, Code varchar(1))
CREATE TABLE #tblValues(Code varchar(1))

INSERT INTO #tblIDs(TestID, Code) VALUES(1,'a')
INSERT INTO #tblIDs(TestID, Code) VALUES(2,'A')

INSERT INTO #tblValues(Code) VALUES('a')
INSERT INTO #tblValues(Code) VALUES('A')

SELECT #tblValues.Code AS TestCode, 
   (SELECT #tblIDs.TestID FROM #tblIDs 
      WHERE CAST(#tblIDs.Code AS varbinary) = 
            CAST(#tblValues.Code AS varbinary)
    ) AS TestID 
FROM #tblValues

DROP TABLE #tblIDs
DROP TABLE #tblValues
GO
				

???????

???? ???????: 282243 - ????? ??? ??????: 04/?????/1424 - ??????: 3.1
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbfix kbsqlserv2000sp1fix KB282243 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????282243

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

 

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