Collections:
PRINT Statements in SQL Server Transact-SQL
How to print value on console in SQL Server Transact-SQL? How to use the PRINT statements?
✍: FYIcenter.com
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:
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
2017-04-01, 2735🔥, 0💬
Popular Posts:
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...