SQL Studio Overview
SQL Studio is designed to aid in the development, maintenance, and in the learning and better
understanding of existing SQL programs. SQL Studio uses intuitive design views and functions to help
SQL developers design more effective programs. Its design is based on years of SQL development
experience by leading information technology professionals and managers. SQL Studio is an integrated and
effective development environment that fully exploits the power of SQL in a simple point and click environment.
The powerful debugger facility of SQL Studio provides the developer with a tool that will significantly reduce
coding errors and expedite the process of correcting existing bugs.
Features and Benefits
Navigator
Managing a group of database servers using SQL project. Providing an easy-to-use access way to
browse database objects and their properties. Any ODBC-compliant databases can be connected and database
objects can be browsed. However, only Sybase and SQL Server are fully supported, including debug functionality
at this release.
SQL Editor
Creating and editing SQL script. Displaying SQL script with highlighting SQL keywords and comments
in color and font effects. Making the code easy to be read and keyword typo easy to be identified not
only on the screen, but also in printout. SQL templates generated based on database objects can be easily
inserted here.
Debugger
SQL script including stored procedure or batches can be executing step by step, with break points,
or with window cursor position. New stored procedure can be debugged even without being installed
into database server first. Existing stored procedure can be debugged, or modified then debugged
without affecting the original one.
Results
Multi result sets are supported in two kinds of views. One is putting all the result sets into one rich
editor view for easy generating report. The other one is putting each result set to one grid view for easy
browse on screen.
Variables
The type, name, value and data type of local variables, global variables, input parameters, and output
parameters will be displayed during debugging.
History
An SQL script history list is managed automatically which provides a convenient way to reuse
the SQL script you entered.
Plan
Query plan and statistics information can be turned on/off when runs SQL script. The query plan and
statistics will be showed on a separated view.
Log
A view to keep some log information, like start and end time of each execution, and error or informative messages.
Property
Properties of current selected database object or a set of objects in navigator will be displayed.
You can turn on/off the display, or reload as needed.
Monitor
System activity statistics information for each connected database server, like number of connections,
cpu time, idle time, io time, read and write, will be refreshed automatically. You can turn on/off as needed.
System Requirements:
IBM-compatible personal computer with 486 or higher processor, Microsoft Windows 95 or Microsoft Windows NT,
VGA or higher resolution monitor, 16MB RAM minimum, Hard Disk Drive with at least 10MB of free space,
Must have 32 bit ODBC drivers for the types of database(s) you want to use
