Using Comments

SQL Server Management Studio allows you to easily comment out a portion of your script.

Commenting Out Part of a Script

To comment out a portion of your script

  1. Use your mouse to select the text WHERE LastName = 'Sanchez'.

  2. On the Edit menu, point to Advanced, and then click Comment Selection. The selected text is commented out with dashes (--).

In addition to using the Edit menu, you can comment or uncomment a selected portion of your script by using either of the following methods:

  • Click the buttons on the SQL Editor toolbar.

  • Press CTRL+K and CTRL+C to comment the text, or press CTRL+K, CTRL+U to uncomment the text.