Online Documentation for SQL Manager for SQL server

Using Navigation bar and Toolbar

The Navigation bar and Toolbar provide quick access to tools implemented in Query Data.

 

 

 

The Navigation bar of Query Data allows you to:

 

Database

select a database for the query

 

General

execute the current query

view estimated query execution plan

show/hide information messages

run Design Query to design the query as a diagram

open cursor on client (server) side. If the server cursor is selected then the query dataset is processed with server resources, otherwise it's processed on the client side.

switch the results representation mode: on Edit tab or on separate tab

configure Query Data within the Tools | Query Data page of the Environment Options dialog

restore the default size and position of the editor window

 

Queries

add a new query (note that the current query text will not be lost)

rename the current query

delete the query

delete all queries from the editor

edit the query text using Favorites editor and add the query to the Favorite Queries list

 

Depending on the current tab selection, the Navigation bar expands to one or more additional panes with tab-specific actions that can be useful for working with queries:

 

Edit

activate the Find Text dialog

load a query from an *.sql file using the Open SQL File dialog

save the query to an *.sql file

save the query to an *.sql file using the Save as... dialog

save all queries to an *.sql file

 

Logs

activate the Find Text dialog

save the query log to a file

clear logs

 

Data Management

commit transaction

rollback transaction

export the returned dataset using Export Data Wizard

export the returned dataset as SQL script using the Export as SQL Script wizard

import data

 

Debug

debug the code using the Debug T-SQL tool

 

Items of the Navigation bar are also available on the ToolBar of Query Data. To enable the toolbar, open the Environment Options dialog, proceed to the Windows section there and select Toolbar (if you need the toolbar only) or Both (if you need both the toolbar and the Navigation bar) in the Bar style for child forms group.

 

 

---