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
Use your mouse to select the text
WHERE LastName = 'Sanchez'
.On the Edit menu, point to Advanced, and then click Comment Selection. The selected text is commented out with dashes (--).
Note
You can also use buttons on the SQL Editor toolbar to comment and uncomment text.