Quick Start Guide

NB: This guide has been updated for version 2.1. If you are using an earlier version then it is recommended that you upgrade to the latest version of soome parts of this guide may not make sense

This guide will take you through the basic process of using the application to run a query against multiple databases:

Step one

Open up a new instance of SuperQuery or if SuperQuery is already running make sure you are looking at a blank query tab (select File -> New Query)

Step two

Select the "Add" button to open up the "Add Database" wizard:
select_adddb.png

Step three

The first page of the Wizard will prompt you to select which database system you want to use. Currently only plug ins for SQL Server exist but more will follow.
adddb_select_plugin.png
Once you have selected the desired database system plugin, click the "Next" button

Step four

Enter the details to connect to a database server on your network. In the example below we are connecting to a SQLExpress instance on the local machine:
adddb_page1.png
Once you have entered the correct details click the "Next" button

Step five

A list of databases that exist on the current server but have not already been selected and added previously will be displayed. In this case the only databases are the default ones on a blank SQL Server install:
adddb_page2.png
Select one or more databases (in the above instance we clicked the "Select All" button to ensure all databases are added)
When you are happy click "Finish" and the databases will be added to the current query window

Step six

Enter a query to run. For the purposes of this tutorial enter "sp_help" as this will run on any database and will give us a nice result set:
enter_query.png

Step seven

We want to make sure that SuperQuery runs this query and displays the results as a table of data to view. For this to happen we need to make sure the "Query Type" drop down is set to "Table".

Normally you can leave this set to "Auto" and SuperQuery will try and guess as to whether the query will return a table or whether it will just return the number of rows affected (this is to improve performance and reduce memory usage as storing tables of data is slower and takes more memory). As we are running a stored procedure SuperQuery will currently not expect a table of results so we have to force it to save the results table.
select_querytype.png

Step eight

Now we are all set click on the "Run all databases" button and after a short while the icon next to all the databases should turn into a green tick to indicate that the query ran successfully.

Click on the name of one of the databases in the list to display its results in the grid at the bottom of the screen:
run_query.png

If you click on the "Output" tab then you see some text that indicates any non-tabular output from the query. In this case it is just the number of rows returned. If the query failed (indicated by a red cross icon next to the database name) then the "Output" tab will contain the error message returned when the query was run:
run_query_output.png

Last edited Mar 22, 2011 at 9:34 PM by NybbleUK, version 2

Comments

No comments yet.