Can I add Notes to Procedures in SQL?

[Kumba1]

Is it possible to add notes to the Queries in SQL, similar to how in VB you can pre-fix notes with a ' and they will be ignored by the parser... I'm trying to write down what each query does in my database so I dont hafta rely on a text-file on my desktop to remind me (incase I loose my computer)... Thanks

 

[mgolla]

If you are using Stored Procedures to execute the SQL then you can put comments using "--" before the commment.

I haven't been able to get this to work using Views

HTH
Mike

Dooobie...Doobie......Dooo

 

[cmmrfrds]

Both should work.

-- this is a comment
Declare var1 int -- this is a comment

/* this is a comment */
Declare var1 int /* this is a comment */

 

[Kumba1]

Kewl Now I can let SQL remember what the query does for me... LOL