Anyone know how to place not functional "NOTES" in an SQL statements like the authors name or to note functionality?? thanks GRTTry using --
:D|||thanks works great!|||Just as an fyi, you can highlight entire lines in Query Analyzer and use these:
CTRL+SHIFT+C --Comments everything.
CTRL+SHIFT+R --Removes comments from everything.
This is great when you are troubleshooting or want to just type then highlight and comment.|||whenever you ask a question like this in the generic SQL forum, you need to specify which database system you're using
and you guys who give a database-specific answer to a generic question should preface your remarks that way
for example, if you're using microsoft access, you can't put comments in the sql at all
if you're using microsoft sql server, the double dash works, and so does /* comment */
guess which database allows //|||whenever you ask a question like this in the generic SQL forum, you need to specify which database system you're using
That's right. Repeat after me: "Microsoft SQL Server and SQL are not the same thing"...|||-- supposed to be ansi standard.
:rolleyes:|||PL SQL developer oracle version 9i
Tuesday, March 20, 2012
Placing Notes In Sql Statement
Labels:
authors,
database,
functional,
functionality,
microsoft,
mysql,
note,
notes,
oracle,
placing,
server,
sql,
statement,
statements
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment