MSSQL Server Comments Tutorial

How To Use Comments In MSSQL Database Server Tutorial Example

Run microsoft sql server management studio query editor or any client tools you like then copy & paste the below code to use comments in select clause on sql command or statement in MSSQL Database Server Tutorial Example

   -- Northwind
   SELECT TOP 5               -- select top 5 rows
        'Product : ' + ProductName    -- concatination
        AS "Product + Product Name" -- character strings
   FROM    Products
   Make sure that you have "Northwind" sample database available.
   using "" you can add character strings in MSSQL
   + is concatination in MSSQL
   -- "AS" keyword is optional in MSSQL
   /* */ is multiline code comments in MSSQL
   -- is comment in MSSQL
   -- in fact it is comment in Oracle and MySQL as well

How To Use Comments In MSSQL Database Server Tutorial Example - Result in Microsoft Sql Server Management Studio Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..