Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2004
    Posts
    9

    Unanswered: Placing Notes In Sql Statement

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

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Try using --
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jun 2004
    Posts
    9
    thanks works great!

  4. #4
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    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.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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 //
    Last edited by r937; 08-17-04 at 09:57.
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Quote Originally Posted by r937
    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"...

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    -- supposed to be ansi standard.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  8. #8
    Join Date
    Jun 2004
    Posts
    9
    PL SQL developer oracle version 9i
    Last edited by GRTHIGPEN; 08-25-04 at 17:48.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •