Home » Tip Bank » Database Development » Sql Server

Language: Enterprise
Expertise: All

Jun 22, 2000

During development, it is often necessary to have blocks of code for debug purposes. If the debug code is lengthy, commenting and uncommenting it can be tedious. But if you put either a '--' in front of each line or a '/*' at the front and a '*/' at the end of each line, you can comment and uncomment the code block with a couple of keystrokes. Here are examples of each method:

Commented code

 /* Debug code goes in this block
Print 'Some debug info'
Print 'Some more debug info'
--*/

Uncommented code

 --/* Debug code goes in this block
Print 'Some debug info'
Print 'Some more debug info'
--*/

Just by adding or deleting two dashes at the beginning of the code block, the entire block can be commented or uncommented.