Which SQL?

[Jay]

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

 

[Sylvain Lafontaine]

ADP can connect only with Microsoft SQL-Server and the language used for MS
SQL-Server is known as T-SQL.

SQL-Server 2005 has bring many enhancements to the version used by
SQL-Server 2000; some of these - like advanced schemas - are not really
compatible with ADP.