Quickly executing queries and sets of queries in Query Analizer

In the Query menu, you have several options of executing a query or a set of queries:
  • Execute (F5)
    Executes the current query. A semicolon ( ; ) is used as the query delimiter.

  • Execute All (Shift+F5)
    Executes all the selected queries or all the queries if there is no selection in the active SQL editor window.

  • Execute as Single Batch (Ctrl+F5)
    Executes the selected text as a single batch—without splitting it into individual SQL statements separated with a semicolon; executes all the text in the active SQL editor if there is no text selected.

  • Execute in Selected Databases
    Prompts for a list of databases to execute the active or selected statements in. SYSTEM and MASTER_DB are not included in lists of user databases.
Have more questions? Submit a request


Please sign in to leave a comment.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk