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, 1653🔥, 0💬
Popular Posts:
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...