Very Computer

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
laying around.

-mm

I always try the MS Query program to discover what is the correct syntax in
ODBC SQL. I make the QBE query and then have a look into the SQL generated
statement. I don't bother too much in generating these kind of queries
since I prefer using stored procedures (SQL Server). If your queries are
ad-hoc this is another story.
Regards

Quote:>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
>laying around.

>-mm