How to print value on console in SQL Server Transact-SQL? How to use the PRINT statements?

In Transact-SQL, you can use PRINT statements to print values on the console of the client tool, in the syntax of:

PRINT <value>

When a PRINT statement is executed, the system will:

• Print the value on the client tool's console, if the value is in character string data types.
• Or perform an implicit conversion from value's data type to a character string, if the value is not in character string data types. Then print the value.
• Or return with an error, if the implicit conversion fails.

Here are some examples on how to print values on the console:

-- Print the value from a literal
PRINT 9.99;
----
9.99

-- Print the value from a variable
DECLARE @price MONEY;
SET @price = 9.99;
PRINT @price;
----
9.99

-- Convert a number to DATETIME, the print
DECLARE @when DATETIME;
SET @when = 0.25;
PRINT @when;
-------------------
Jan  1 1900  6:00AM

PRINT 'What time is it?';
PRINT GETDATE();
-------------------
What time is it?
Oct 16 2017  9:00PM

PRINT 'What time is it?';
PRINT 'It''s '+CAST(GETDATE() AS NVARCHAR(30));
------------------------
What time is it?
It's Oct 16 2016  9:02PM

⇒ CONVERT/CAST Function in SQL Server Transact-SQL

⇐ SET Statements in SQL Server Transact-SQL

⇑ Variables and Data Types in SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials