EN
MS SQL Server - Comments
0 points
In this article, we would like to show you how to use comments in MS SQL Server.
Quick solution:
xxxxxxxxxx1
-- Single-line commentxxxxxxxxxx1
/* 2
Multi-line3
comment4
*/In this example, we use a single-line comment as a code fragment explanation:
xxxxxxxxxx1
-- Select all users2
SELECT * FROM [users];In this we use a single-line comment to ignore a statement at the end of the line:
xxxxxxxxxx1
SELECT * FROM [users] -- WHERE [name]='Tom';In this example we use a multi-line comment as a code fragment explanation:
xxxxxxxxxx1
/* Select all2
from the [users] table: */3
SELECT * FROM [users];In this example, we use a multi-line comment to ignore many statements:
xxxxxxxxxx1
/*SELECT * FROM [users];2
SELECT * FROM [products];3
SELECT * FROM [orders];*/4
SELECT * FROM [departments];In this example, we use a multi-line comment to ignore part of a line:
xxxxxxxxxx1
SELECT [name], /*[surname]*/ [country] FROM [users];