Character Strings MSSQL Server Tutorial

How To Use Character Strings 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 character strings in select clause on sql command or statement in MSSQL Database Server Tutorial Example

   -- Northwind
   SELECT TOP 5
     'Product : ' + ProductName
     AS "This is Character Strings Example in MSSQL Server"
   FROM Products

   Make sure that you have "Northwind" sample database available.
   using "" you can add character strings 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 Character Strings In MSSQL Database Server Tutorial Example - Result in Microsoft Sql Server Management Studio Query Editor Client Tools