Access SQL Syntax

[DanielP]

Hi folks!

i am working with Access and its SQL engine since 1 year now... normal
i tried the syntax I used in MySQL and mosty it worked or I use
try&error to adjust
I cant simply find a normal SQL Docomentation in the Access help.

Can somebody give me a hint where I can find the SQL languag
specification of Access?

Thanks alot!

And one problem I actually have:
Can i set the default values for a column, when i create the table wit
"CREATE TABLE"? like "mycolumn INT DEFAULT 0" :rolleyes

 

[Tom Ellison]

Dear Daniel:

For any serious work with SQL Server, I recommend you get SQL Server
Developer Edition. This includes Books Online, which is good
documentation for what you want. It also includes Query Analyzer and
Enterprise Manager, which are powerful development tools you'll be
extremely glad to have.

The package should cost about $50.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts