Collections:
Comments in SQL Server Transact-SQL Statements
How to enter comments in SQL Server Transact-SQL statements?
✍: FYIcenter.com
There are 2 ways to enter comments within Transact-SQL statements:
Here are some good examples on how to enter comments:
/* The following statement creates a table called fyi_links */ CREATE TABLE fyi_links ( id INTEGER PRIMARY KEY, -- the primary key url VARCHAR(80) NOT NULL, -- address of the link notes VARCHAR(1024), counts INT, -- number of clicks created DATETIME NOT NULL DEFAULT(getdate()) ); -- Get rid of this table DROP TABLE fyi_links;
By the way, comments are not considered as statements.
⇒ Statement Batch in SQL Server Transact-SQL
⇐ Start and End of Statement in SQL Server Transact-SQL
2017-05-29, 1856🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...