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, 1689🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...