Syntax to enter comments in the SQL SELECT statement ?

  • Thread starter Adrian Constantin
  • Start date
A

Adrian Constantin

Hello.

I have a very long SELECT statement in my application (7 pages when
pretty-printed). I would like to enter comments in SELECT statement to
make it easier (actually to make it possible) to understand and debug,
but I did not find the syntax for comments in Access 2003 help.

How do I enter a comment in the SQL SELECT statement for a query ?

Thank you
Adrian Constantin
Romania
 
J

John Spencer

In Access, you can't add comments to the SQL statement. Something that has
been on the wish list of a lot of people for a long time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling Parameterized Query Using SQL Syntax 3
select case statement in sql 2
changing the syntax of an SQL Select statement to appease VBA 4
comments in SQL query 2
SQL Syntax for SELECT within SELECT 9
SQL statement in the table 3
Union query not displaying select statement 1
Update Query Syntax 5

Top