-- (Comment) (Transact-SQL)
Indicates user-provided text. Comments can be inserted on a separate line, nested at the end of a Transact-SQL command line, or within a Transact-SQL statement. The server does not evaluate the comment.
Is the character string that contains the text of the comment.
Use two hyphens (--) for single-line or nested comments. Comments inserted with -- are terminated by the newline character.
There is no maximum length for comments.
A GO command included within a comment generates an error message.
The following example uses the -- commenting characters.
-- Choose the AdventureWorks database. USE AdventureWorks; GO -- Choose all columns and all rows from the Address table. SELECT * FROM Person.Address ORDER BY PostalCode ASC; -- We do not have to specify ASC because -- that is the default. GO