FIX: ??????? ????? LIKE ?? ???? Jet OLEDB ????

?????? ????????? ?????? ?????????
???? ???????: 311159 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ????? ??????? SQL ???????? Microsoft Jet OLEDB ???? 4.0 ????? ???? LIKE ??? ???? ???? SQL ????? ???? LIKE ??? ?? ???? ???? ????? ?????? ????? ??????? Microsoft Jet ?? SQL Server. ???? ?? ??? ??????? ????? ??? ?????? ??? ???? ?????? ????? ??????? ?? SQL Server ?????? Jet.

???? ??? ??? ??? ??????? ???? ?????? ?????? ?????? Jet ???? LIKE ??? ????? ??????? ??????? ???????? ??? ????? ??????? ??? ?????? ? ???? ???? ??????? ???????? ??? ?????? ??????.

????

??? ??? ???????? ?? ?????? ???? ???? ???? Microsoft Jet 4.0. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
239114?????: ?????? ??? ???? ???? ???? ?? ???? ????? ?????? Microsoft Jet 4.0

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????. ?? ????? ??? ??????? ?? Jet 4.0 Service Pack 6 (SP6).

??????? ????

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

  1. ????? ????? ?????? Microsoft Access ???? ???? "C:\DB1.MDB".
  2. ???? C:\DB1.MDB ?? Microsoft Access ?????? ???? ????? ????? ??????? ???????? ?? ????? ?????? pubs (????????) ??? ???? SQL Server. ???????? ??? ?????? ??????? ????????? dbo_authors.
  3. ????? ????????? ?????? ???????? ???? OLEDB Jet Microsoft 4.0 ????? ????? ?????? Access C:\DB1.MDB.
    SELECT * from dbo_authors WHERE state LIKE 'M%'
    					
??? ?????? ???? SQL Server ????? ???????? ?????? ???????? SQL Server ???? ????? ??????? "? ???? ?? ?????? SQL ?????? ??? ??????? ??? SQL Server, ???? ??? ?? ??? ?????? ??????? Microsoft Jet ????? ???????? LIKE ??? ??????? ???? ?????? ?? ?????? ???????. ???? ?? ????? ???? ?????? SQL ??? ?????? ????? ????????? ???? ?????? SQL ?????? ??????? ?? ??? Microsoft Jet.
-- This is sent first by Jet to fetch all key values.  
-- Note that WHERE state LIKE 'M%' is not applied here.

SELECT au_id, state FROM authors 

-- This retrieves a single row using the first key value retrieved by the
-- above SQL statement. Jet will apply the LIKE clause internally
-- before retrieving the first row.

SELECT au_id,au_lname,au_fname,phone,address,city,state,zip,contract  
FROM dbo.authors WHERE au_id = @P1 
				
??? ??? ?????? ??????? SQL ?????? ???????? ?????? ????? ODBC Microsoft Access ???? LIKE ??? ???? ???? ??????? ??? ???? SQL ?? ????? SQL ????? ???? ??????? ????? ???? ??????.

???????

???? ???????: 311159 - ????? ??? ??????: 09/?????/1426 - ??????: 1.4
????? ???
  • Microsoft OLE DB Provider for Jet 4.0
????? ??????: 
kbmt kbhotfixserver kbqfe kbbug kbfix kbqfe KB311159 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????311159
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

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