SQL commenting

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Is there a way to add comments to the SQL view of a
query? I haven't been able to find any reference to this
anywhere.
 
Its not like Stored Procedures in SQL Server.
If you right mouse click in the design view, one of the properties is called
"Description". You can add small comments there. If you view the query
objects in the database window by showing details, you will see your
comments show up there.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Thank you for your reply, Rob. But what I'd like to be
able to do when writing a new query (e.g., a Union Query)
or learning via looking at the SQL code is to use comments
to explain what's going on. Another time I've found
commenting very useful is to be able to comment out a
line, or several, and see how the results change.
 
Most of us would like this feature along with the ability to retain any
formatting we have done in SQL. It is not available.
 
John,

Oh yes, I'll definitely include myself in that group.

I would be overjoyed to see comments, format retention, and font-type and
font-size choices in MS Access's QueryDef SQL property (or whatever property
would be needed to keep that formatting and font choices, like, say,
SQLrtfFormat, maybe?).


Sincerely,

Chris O.
 
Back
Top