comments in SQL query

[Guest]

Hi,

Is it possible to add comments within SQL queries (in SQL view). If so,
what is the correct syntax?

E.g.
//I want comments in SQL view of my query to appear
//Comments: This query selects everything from table x
Select * From x

Thnks in advance

 

[Brian Wilson]

Hi,

Is it possible to add comments within SQL queries (in SQL view). If so,
what is the correct syntax?

E.g.
//I want comments in SQL view of my query to appear
//Comments: This query selects everything from table x
Select * From x

Thnks in advance

There is no standard way to do this. A query has a description which can be
viewed in the database window and would be suitable for the simple example
you gave. If you needed something more complex then you would have to do
something more imagintive for example having a vba module which creates the
query - that would allow the comments within the coding.

 

[John Vinson]

Is it possible to add comments within SQL queries (in SQL view).

Unfortunately, no, it is not.

John W. Vinson[MVP]