Menu
Is it possible to comment code out in the SQL window in Microsoft Access?
422
The syntax for creating the comment in SQL using — symbol is the following. Any text between — and the end of the line will be ignored (will not be executed). The comment started with — symbol must be at the end of the line in your SQL statement with the line break after it.
Comments can be inserted on a separate line or within a Transact-SQL statement. Multiple-line comments must be indicated by /* and */. A stylistic convention often used for multiple-line comments is to begin the first line with /*, subsequent lines with **, and end with */.
No. You cannot have any extraneous text in Microsoft Access (JET-SQL).
You can make some constraints ignored, e.g.,
Where name = "joe" OR (state = "VA" AND 1=0) But that technique is a rather limited way to hide existing SQL.
143
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
