SQL Server PRINT SELECT Print a select query result

Question

I want to print a particular value; is it possible? 

Example:

PRINT 
    SELECT SUM(Amount) FROM Expense

Answer 1

Although there may be a simpler method, the following comes to mind right away:

Declare @SumVal int;
Select @SumVal=Sum(Amount) From Expense;
Print @SumVal;

Of course, you may use this method to print any number of table fields. Of course, you would just direct your output appropriately if you wanted to publish every result from a query that returns several rows (e.g. to Text).

I hope this helps you.