comments in SQL query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Help me said:
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
Click to expand...


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.
 
Back
Top