Where can one find a tutorial/documentation for learning how to write
statements(queries) in the SQL offered by ODBC? My goal is to create
Active Server Pages applications.
I have a good background in MS Access's flavor of SQL. I have the MSDN
library CDs, and own Visual InterDev; I've got LOTS of documentation, but,
for example, the doc's covering SQL in Visual InterDev seem to look at it
from a C programmers point of view (including managing connections,
memory, etc), all of which is unnecessary for ASP.
A case in point - I can't figure out how to write WHERE clauses using the
Between... And operator in ODBC SQL, what deliimiters does one use for
literal dates? Access uses #m/dd/yy#.
I'm really stuck here, and would appreciate learning where to find that
documentation. Buying (yet another) hefty and $$$ computer book is
acceptable too, although I bet the answers are on one of these CDs I have