Placing Notes In Sql Statement

GRTHIGPEN · #1 (**permalink**) 08-16-04, 11:32

Anyone know how to place not functional "NOTES" in an SQL statements like the authors name or to note functionality?? thanks GRT

LKBrwn_DBA · #2 (**permalink**) 08-16-04, 11:43

Try using --

GRTHIGPEN · #3 (**permalink**) 08-16-04, 12:15

thanks works great!

derrickleggett · #4 (**permalink**) 08-17-04, 08:29

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.

r937 · #5 (**permalink**) 08-17-04, 08:55

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 //