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
No comments:
Post a Comment
leave your comments here..