RE: Bitwise Comparison in WHERE Clause

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 07:51:04 GMT

Hi Michael,

Since Jet is designed for Access, it might not support for all transaction
SQL statements. The bitwise comparison is only supported by SQL server, so
I think it cannot be done using Jet.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Heterogeneous Replication with Jet Discontinued in SQL Server 2005
    ... With SQL Server 2005, support for heterogeneous replication with Jet ...
    (microsoft.public.access.replication)
  • Re: Jet grounded?
    ... Microsoft removed support in 2.6 but added it back in with version 2.7. ... Microsoft has deprecated the Microsoft Jet Engine, ... > what they can, within reason, to discourage Access and promote SQL Server. ...
    (microsoft.public.vb.general.discussion)
  • Re: ADO Recordset Seek Method ?
    ... perhaps someone with more experience of SQL Server might ... > Server and I am 99% certain I have seen documentation that say SQLOLEDB ... > does not support it (and considering what SQLOLEDB does support, ... that Seek is unique to Jet ... ...
    (microsoft.public.data.ado)
  • Re: Single file DB with smallest footprint
    ... Another DB that MS will support - MS SQL Server CE. ... And you can't install the JET-Engine without ... Jet SP is available on MS site and can be installed without Access. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: trigger counter part
    ... the Jet data engine does not support triggers or similar. ... I said constraints in Jet 4.0 are better than SQL Server ...
    (microsoft.public.access.tablesdbdesign)