Mini SQL Query Help

Main Window - Index

Overview

Mini SQL Query is a very basic, highly extendable generic SQL query tool. It has a small footprint and can connect to many different databases, for example MSSQL, Access, Oracle etc. When Mini SQL Query starts up it will look similar to the screenshot below.

Mini SQL Query at startup

Quick Start

When the tool is run first time, check the current connection strings, by default they are:

• Server=.; Database=master; Integrated Security=SSPI
• Server=.\sqlexpress; Database=Northwind; Integrated Security=SSPI
• Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SomeDirectory\access.mdb

The default connection selection is now empty. Use the "Connection" dropdown combo box to select a connection by name:

Mini SQL Query - Selecting a Connection

Obviously you may not have a default install of MSSQL locally so a connection will need to be modified or updated. To edit connections, use either the Edit -> Edit Connection Strings menu option or the Edit Connection Strings button to set a connection.

Mini SQL Query Database Connection List Editor

Keyboard Shortcuts

To open a new query window use CTL+N or the 'File/New Query Window' menu option (CTL+S to save, CTL+O to open).

The editor supports all the usual keyboard shortcuts for cut CTL+X (including full line style), copy CTL+C, paste CTL+V, undo CTL+Z, redo CTL+Y.

You can toggle a line as commented using "CTL+/". This will work for the main languages (SQL, C#, VB, HTML/XML etc).

To execute a query press F5 or use the 'Query/Execute' menu option. F5 is also used to refresh the "Table Data" view or to execute a templet while in edit mode.

If you want to change connection, just select a new provider (if requred) and connection string on the main toolbar then press the Edit Connection Strings button.

A new query window with basic query and result

Index

Updated Thursday, 8 March 2008.