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
2017-04-01, 878👍, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...