PRINT statement in T-SQL

by

So, if you have a statement something like the following, you’re saying that you get no ‘print’ result?

select * from sysobjects
PRINT 'Just selected * from sysobjects'

If you’re using SQL Query Analyzer, you’ll see that there are two tabs down at the bottom, one of which is “Messages” and that’s where the ‘print’ statements will show up.
If you’re concerned about the timing of seeing the print statements, you may want to try using something like

raiserror ('My Print Statement', 10,1) with nowait

This will give you the message immediately as the statement is reached, rather than buffering the output, as the Query Analyzer will do under most conditions.

More Related Contents:

  1. How do I create a unique constraint that also allows nulls?
  2. Get first day of week in SQL Server
  3. What is the significance of 1/1/1753 in SQL Server?
  4. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  5. Escape a string in SQL Server so that it is safe to use in LIKE expression
  6. Insert Update trigger how to determine if insert or update
  7. SQL time difference between two dates result in hh:mm:ss
  8. What is the best way to truncate a date in SQL Server?
  9. Dynamic SQL (passing table name as parameter)
  10. SQL Server: Difference between PARTITION BY and GROUP BY
  11. How do you truncate all tables in a database using TSQL?
  12. Understanding SQL Server LOCKS on SELECT queries
  13. SQL Server: How to select all days in a date range even if no data exists for some days
  14. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  15. TSQL: How to convert local time to UTC? (SQL Server 2008)
  16. T-SQL Dynamic SQL and Temp Tables
  17. Find non-ASCII characters in varchar columns using SQL Server
  18. How can I determine in SQL Server if a dateTime range overlaps another
  19. How do you change the datatype of a column in SQL Server?
  20. TABLOCK vs TABLOCKX
  21. How to convert number of minutes to hh:mm format in TSQL?
  22. How do I select last 5 rows in a table without sorting?
  23. SELECT INTO a table variable in T-SQL
  24. T-SQL query to show table definition?
  25. How can I insert binary file data into a binary SQL field using a simple insert statement?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. SQL SERVER – Understanding how MIN(text) works
  28. Pivot multiple columns based on one column in SQL Server
  29. @@ERROR and/or TRY – CATCH
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment