Text copied!
SQL Comments
Hi! You should check
SQL data types
post first.
SQL comment is a text, added to the code to provide information about what the code is doing. Comment is ignored by the SQL engine when the code is run. The purpose of comment is to help others to understand your code better.
There are two types of comments in SQL :
1. Single-line comments:
Single-line comment starts with two hyphens/dashes ( -- ). Anything after the two hyphens/dashes on that line is ignored. For example :
SELECT * -- this is a comment
FROM [Person].[Address];
2. Multi-line comments :
Multi-line comments starts with /* and end with */. Anything between these two symbols is ignored. For example :
/* This is a
multi-line comment */
SELECT *
FROM [Person].[Address];
SQL comment helps developer to maintain and document 'complex SQL queries' that improves code readability and testing.
Frequently Asked Questions :
Thank You! You should check
SQL constraints
post next.