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, 1654🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...