T-SQL » Comments » Multi Line Comment
- Syntax:
-
/* Text to be commented
can be entered here */
Multiple lines can be commented as well using a comment block. The text in between /* and */ will be commented.
Examples
Code:
CREATE TABLE Students
/* A table named Students
with Primary Key as Id
will be created */
(
Id INT PRIMARY KEY,
Name VARCHAR(50) NOT NULL,
Address VARCHAR(40) NOT NULL,
/*Only the phone number accepts null value */
Phone INT
)
Explanation:
Creates the Students table. The lines of text after /* and before the very next */ are comments and will not be evaluated by the SQL Server.
Language(s): MS SQL Server
