MS SQL Server - Comments

In this article, we would like to show you how to use comments in MS SQL Server.

Quick solution:

xxxxxxxxxx

-- Single-line comment

xxxxxxxxxx

/* 

  Multi-line

  comment

*/

In this example, we use a single-line comment as a code fragment explanation:

xxxxxxxxxx

-- Select all users

SELECT * FROM [users];

In this we use a single-line comment to ignore a statement at the end of the line:

xxxxxxxxxx

SELECT * FROM [users] -- WHERE [name]='Tom';

In this example we use a multi-line comment as a code fragment explanation:

xxxxxxxxxx

/* Select all

 from the [users] table: */

SELECT * FROM [users];

In this example, we use a multi-line comment to ignore many statements:

xxxxxxxxxx

/*SELECT * FROM [users];

SELECT * FROM [products];

SELECT * FROM [orders];*/

SELECT * FROM [departments];

In this example, we use a multi-line comment to ignore part of a line:

xxxxxxxxxx

SELECT [name], /*[surname]*/ [country] FROM [users];