Which SQL?

Hi,

I'm reasonably proficient in writing my Access queries in SQL (in a .mdb file), and obviously I'm aware of the 'quirks' in Access SQL syntax.

Now I'm beginning to explore an .adp to the sql server at work I'm aware that I need to use different sql syntax to that used in an .mdb

I'm keen to read up on the sql syntax used in .adp's so would like to know if it has any particular name. I'm a little bemused by all the different types I see references to i.e. T-sql, MySQL, Ansi ??

Which is the one used in ADPs?

Many thanks.....Jason
.