PRINT Statements in SQL Server Transact-SQL

Q

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

✍: FYIcenter.com

A

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

 

Variables and Data Types in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-04-01, 266👍, 0💬