Commenting in SQL

  • Thread starter Thread starter VWP1
  • Start date Start date
V

VWP1

Is there any "comment" characters I can use in SQL which will be ignored,
similar to HTML's <!-- comment --> ?

VWP1
 
Unfortunately not in Access. I have heard of some comvoluted workarounds such
as running the SQL in code where you can make it happen.
 
Is there any "comment" characters I can use in SQL which will be ignored,
similar to HTML's <!-- comment --> ?

VWP1
Click to expand...

We've been yelling at MS for years to add this feature, but... at present, no.

About all you can do is a snarky getaround: creating a phony calculated field,
e.g.

SELECT "This isn't a real field, just a comment" AS IgnoreThis, <other fields>
FROM mytable...
 
John W. Vinson said:
We've been yelling at MS for years to add this feature, but... at present,
no.
Click to expand...

Yes, come to think of it is something I've been forgetting to yell about!

About all you can do is a snarky getaround: creating a phony calculated
field,
e.g.

SELECT "This isn't a real field, just a comment" AS IgnoreThis, <other
fields>
FROM mytable...
Click to expand...

Well, at least I can say I'm very proud of you, since you've added the word
snarky to above statement.
(no question, the above is a last chance saloon type of solution).
 
Back
Top