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, 2481🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...