New in Version 3.5 |
|
- Use of coding history cache has been turbo-charged. Code suggestions based on historical
coding patterns are available in many places.
- Eclipse plug-in. That's right SQL Assistant can be now used with Eclipse and derivate
products, including Eclipse Data Tools Platform
- Multiple column selection lists are supported in UPDATE and INSERT statement. Checkboxes
have been added to these column list allowing to chose multiple columns at once.
- Multiple-column foreign keys are supported in JOIN clauses. The entire JOIN with all
columns can be now added with a single mouse click or a single key-press.
- New Code Bird's View feature helps to navigate long files and scripts, supporting jumps
between code fragments without scrolling and reading the actual code.
- New coding statistics and productivity gain display. Some of our internal tests achieved
as much as 1200% productivity gain from using SQL Assistant! Try it for yourself.
- Additional code-wrapping options have been added to formatting rules.
- Support for batch delimiters available for all environments, including parsing and
support for MySQL's DELIMITER keyword and DB2's SET TERMINATOR.
- Expanded support for Oracle objects and packages - added code IntelliSense for types,
type and package constants, exception handlers and declarations, package and type scope
records.
- New code block commenting/uncommenting function can be used with non-SQL editors such
Notepad, UltraEdit and other not supporting such commonly used function. Numerous other
minor enhancements and usability changes..
- Numerous other minor enhancements and usability changes.
|
|
New in Version 3.1 |
|
- Direct code execution – Notepad and all other simple editors can now fully compete
with specialized SQL editors and development environments.
- Table data mini-preview (single-click on a table, view, or synonym shows first 100
records)
- Support for MS Access as a back-end database, via direct integration with Access IDE and
via ODBC database connection from other SQL editors (for example, you can now run MS
Access queries and make data changes from Notepad).
- Data export to Excel and text files.
- SQL Code Structure support for CALL statements and other enhancements in the Structure
view.
- DB2 and MySQL – support for FOR NOT FOUND and CURSOR..FOR constructs.
- Connection interception for SSMS in SQL Server 2008 (Katmai).
- Add-on registration for SSMS in SQL Server 2008 (Katmai).
- Branch expansion in popups and enhanced multi-level item filtering in expanded branches.
- Full support for synonyms in SQL 2005/2008
- New options to fully or partially qualify object names.
- Formatting code enhancements – added support for code structures beginning with the
same keyword, for example, BEGIN and BEGIN TRY.
- Logical join completion for subqueries - joins between tables referenced in the main
query and tables referenced in subqueries.
- Support for join candidates using matching column names.
- Introduced 2 new macro-variables in code snippets for generating vertical column and
parameter lists.
- Improved code auto-indent handling.
- Reworked and expanded database connection handling. Starting with this version
ADO.NET-based and ODBC-based connections can be used with all supported database systems.
For ODBC-based connections both DSN and DSN-less connections are now supported.
- Client-side authentication is now supported for DB2 and Sybase database connections
using ADO.NET interfaces.
- Numerous other minor enhancements and usability changes.
|
|
New in Version 3.0 |
|
- Context SQL suggestions based on the typing history.
- Matching brackets and code block delimiters (BEGIN..END, IF..END IF, LOOP..END LOOP,
etc...) highlighting and one-click navigation
- One-step complete SELECT statement generation after selecting columns in SELECT prompt.
- Support for multiple-column selection using check boxes in SELECT and other
prompts.
- Advanced Auto-indent features.
- Support for procedure parameters in MySQL.
- Support for subqueries and derived tables with variable parameters in SQL Server.
- Code syntax validation for DB2 and MySQL.
- Support for objects and columns declared in temp tables and table variables.
- Code expansion for * and other elements in DML statements.
- Advanced code completion in DML statements and statement generation based on selection
of a JOIN or WHERE clause.
- Context suggestions for code expansion in DDL statements. Context sensitive help with
DDL commands.
- Support for multiple formatting styles.
- Advanced code snippets for auto-generating object-specific code fragments.
- Advanced selection and code generation of variables in DECLARE statements.
- Improved popup activation after dot or bracket.
- Auto-generation of table aliases.
- Support for MySQL native client connections.
- MySQL Query Browser Connect Interception.
- IntelliSense list content filtering control added to Options.
- Improved code formatting - control of bracket positioning.
- Built-in add-ons for SSMS, VS, VS for Database Team Professionals (former Data Dude).
- Support for Toad for MySQL/DB2/SQL Server.
- Expiremental support for Sybase databases.
|
|
New in Version 2.5 |
|
- New one-click Procedural Code View - with a single click you can lookup and browse code
of referenced procedures, functions, packages or just type the name and click it
- New integrated spell checker for SQL code comments and hard-coded string
- Improvements in Code Formatter and Beautifier
- Smarter IntelliSense in the code auto-completion features
- Enhancements in the Code Structure View - added support for loops and conditional
statements, support for more types of SQL commands
- Added support for more SQL editors and IDEs
- Significant improvements made in the Options making it easier then ever to customize SQL
Assistant behavior.
- other minor improvements over version 2.0
|
|
New in Version 2.0 |
|
- Support for MySQL and DB2 databases and editors
- Support for more editors and IDEs for SQL Server and Oracle with more flexible
customization options
- Code Structure View for quick code navigation - anyone who deals with large SQL files
would much appreciate this new feature
- Advanced code IntelliSense and auto-completion for extended set of SQL commands,
including many DML and DDL commands
- New code auto-expansion options
- Smart code auto-indent feature
- Code Formatter and Beautifier
- Code syntax validation for all Oracle and SQL Server editors, can be used even with
Notepad
- other minor improvements over version 1.0
|
|
|
