开发工具:
文件大小: 7mb
下载次数: 0
上传时间: 2010-07-30
详细说明: SoftTree SQL Assistant v5.0 - What's New New Code Analysis and Refactoring Functions - smart object, column, and parameter renaming methods; smart code extraction methods; advanced code dependencies analysis Graphical analysis of dependencies for objects (tables, views, procedures, functions), table and view columns, procedure and function parameters. Code refactoring - Extract View definition from procedural code - 3 clicks method for conversion of a block of code to a view - customizable templates. Code refactoring - Extr act sub procedure definition from procedural code - 3 clicks method for conversion of a block of code to a stored procedure or function - customizable templates. Code refactoring - Rename procedure/function in database including automatic discovery of dependencies, code preview before updating, including all dependencies. Code refactoring - Rename table/view in database including automatic discovery of dependencies, code preview before updating, including all dependencies. Code refactoring - Rename table/view column view in database including automatic discovery of dependencies, code preview before updating, including all dependencies. Code refactoring - Rename procedure/function parameter in database including automatic discovery of dependencies, code preview before updating, including all dependencies. Code refactoring - rename local variable - rename local variables in procedures and functions (standalone code loaded in the editor or part of a large script). Syntax checker improvements - highlighting for unused variables. Advanced Code Entry Automation - updated code snippets engine, programmable code snippets using SQL language Support for user-defined interactive prompts. See new $PROMPT$ macro . User-defined programmable macros using SQL code. See new $$..$$ and accompanying macros $CURRENT_NAME$, $CURRENT_SEL$, etc... . Removed certain limitations on the use of functionally similar macros in the same snippet code. For example, $COLUMNS$ and $COLUMNS_KEYS$ macros can be now used in the same code snippet. Improved SQL Intellisense and Code Formatting Improved keyword prompts - preferred keywords and SQL constructs displayed on top of the keyword prompts. You can now customize preferred keywords list to match your preferences. Column popups after ORDER BY and GROUP BY keywords are now feature checkboxes. Multiple columns can be picked at once. While-you-type and standalone code formatters support new formatting options allowing simultaneous use of different cases for keywords and for system functions, for example uppercasing keywords and using mixed or lower case for system functions. New options for handling name delimiters. "Always Add Delimiters" option supports new mode "Only if name = keyword (limited)" You can now customize list of keywords that you also use as object and column names, and which you don't want SQL Assistant to treat as keywords, for example, the default configuration includes ID and Name, names, you can add your own. "Show Keys and Indexed Columns" is preset for all assistance types by default. Primary keys, foreign keys, and indexed columns are displayed by default in column popups and mouse-over hints. Mouse-over hints for table and view columns display hyperlinks for sample data preview and for DDL code view for views. . Mouse-over hints for procedure and function parameters display hyperlinks for procedure/function DDL code view. Improved display of column name popups for PostgreSQL. The popups now indicate auto-generated values and indexed columns. Improved recognition of auto-generated values in various SQL statements. For example, SQL Assistant does not insert references to "timestamp" columns in SQL server when generating code for table INSERT and UPDATE statements. Improved control of column name popups. You can now configure additional symbols that trigger automatic column name popups, for example, you may add <, <>, >, BETWEEN and other symbols to trigger automatic column popup display. SQL Intellisense implemented for CREATE INDEX statement. SQL Intellisense implemented for CREATE OR REPLACE AND COMPILE JAVA SOURCE. Preset code formatting rule added for Oracle VARRAY. Preset code formatting rule added for DEFAULT VALUES in INSERT/UPDATE statements in Transact-SQL. Database name and schema name completion is now supported after Ctrl+Space. That is handy if you work with long names and need to type them often. Behavior change for query suggestions based on code entry history. To avoid accidental insertion of historical queries into the code, historical items are not pre-selected automatically. . Added new option for controlling alias generation. You can now specify name prefixes that you want SQL Assistant to ignore. Database Code Unit Testing Framework New complete database code unit testing framework supports interactive and automated database code unit testing; allows quick bulk setup of unit tests for multiple database projects. New Add-ons Add-ons for Delphi with built-in SQL Editor. Add-ons are available for all Delphi Windows versions from Delphi 2005 to Delphi 2010;. Experimental support for pre-release version of Visual Studio 2010 ( limited testing performed on Windows XP and Vista). Data Import/Export/Generation New test data generator for quickly populating tables and schemas with realistic test data. Supports updates of multiple tables in one project. Enhanced scripting and exporting table data now this feature supports exporting data from multiple tables and views, as well as from multiple schemas. Miscellaneous Syntax Check Results and Messages panes support copying and saving messages. New user-friendly interface for protecting from run-away queries and results. Added handling for XML windows in SQL Server Management Studio. SQL Intellisense is disabled in XML windows. Improved SEH (Structure Exception Handler) for better code quality and support. Added new API functions, including new function for off-line code formatting, with support for multiple files. A number of other minor improvements ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台,提供交流渠道,下载内容来自于网络,除下载问题外,其它问题请自行百度。
- 本站已设置防盗链,请勿用迅雷、QQ旋风等多线程下载软件下载资源,下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载,请稍后再次尝试;或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎,请到消费记录里找到下载记录反馈给我们,经确认后退回积分.
- 如下载前有疑问,可以通过点击"提供者"的名字,查看对方的联系方式,联系对方咨询.