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.
Â
2017-05-29, 1398👍, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...