Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-23 : 17:41:40
|
Don Burch writes "I am an ASP developer accessing databases (and occasionally creating some) for client websites; but the particular database product used depends on several factors:
- MS Access if the application is simple, with few hits, and customer is not hosting it themselves
- MS SQL Server for more robust apps
- Oracle or whatever the client is already using
I tried to use SQL to provide a common database interface, but have been frustrated at the differences in syntax/keywords between Access, SQL Server and Oracle. There are lots of SQL books out there, but they all seem to focus on one SQL supplier and ignore the others.
Can you recommend a book, pocket guide, article, or whatever which compares the syntax of each SQL variants ?
Ideally I have been looking for a book I can use as my single SQL reference text, and also shows the difference between the major SQL packages." |
|
|
|
|
|
Comparison of Access/SQL Server/Oracle/... SQL syntax