How to Execute SQL Query without Displaying results

by

I’m surprised nobody came up with the answer : switch on the “discard query results after execution” option; l I’m pretty sure that was what the interviewer was after. SET FMT ONLY is totally different thing IMHO.

In SSMS

  • open a new query
  • in the menu select Query / Query options
  • select the Results pane
  • check the “discard result after execution”

The reason you might want to do this is to avoid having to wait and waste resources for the results to be loaded into the grid but still be able to have e.g. the Actual Execution Plan.

More Related Contents:

  1. Case statement for multiple columns
  2. SQL where clause odd behavior [closed]
  3. SQL Server Exec issue [closed]
  4. Count(*) vs Count(1) – SQL Server
  5. How do I escape a single quote in SQL Server?
  6. Selecting data from two different servers in SQL Server
  7. Is a view faster than a simple query?
  8. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  9. How do I delete from multiple tables using INNER JOIN in SQL server
  10. Does Foreign Key improve query performance?
  11. SQL : BETWEEN vs =
  12. SQL Server: Howto get foreign key reference from information_schema?
  13. SQL Server convert string to datetime
  14. Should I design a table with a primary key of varchar or int?
  15. How do you import a large MS SQL .sql file?
  16. How do I make a composite key with SQL Server Management Studio?
  17. Difference between Subquery and Correlated Subquery
  18. How to execute .sql file using powershell?
  19. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  20. Return number of rows affected by UPDATE statements
  21. Execute Dynamic Query with go in sql
  22. TransactSQL to run another TransactSQL script
  23. How can I get a list of element names from an XML value in SQL Server
  24. SQL server identity column values start at 0 instead of 1
  25. How to rename something in SQL Server that has square brackets in the name?
  26. SQL Server 2008 paging methods?
  27. how to separate string into different columns?
  28. How to compare dates in SQL Server
  29. SQL SERVER DATETIME FORMAT
  30. Insert all values of a table into another table in SQL

Leave a Comment