3.5.61 17-May-12
- Error report on snippet insertion with predefined literal is fixed (T39608)
- Error report on script modifying is fixed (T39572)
- Problem with valid script formatting is fixed (T39487)
- Right Margin formatting option limitation is changed to maximum possible (R9127)
- Problem with formatting is fixed, 3 white spaces are replaced with a TAB symbol (R9375)
3.5.60 10-Apr-12
- Error report on product update is fixed (T38266)
- Error report on changing a connection during metadata retrieving is fixed (T38309, 38770)
- Error report on *.sql file opening in VS2010 is fixed (T38240)
- Problem with incorrect formatting within the BEGIN...END block is fixed (T38397)
- Problem with formatting comments is fixed (R8395)
- Problem with smart tag expanding for linked server is fixed (R8090)
- Problem with formatting DDL statement without delimiter is fixed (R7708)
- Problem with smart tag appearance after fully typed identifier is fixed (R7473)
- Problem with saving snippets after uninstalling the express edition is fixed (R7753)
3.5.56 14-Mar-12
- Problem with suggesting user table types is fixed (T37576)
- Error report on editing large scripts is fixed (T37381)
- Error report on updating commands status is fixed (T37398)
- Error report on typing characters in virtual space is fixed (T37301, T37916, T38017)
3.5.54 21-Feb-12
- Error report on suggesting cursors is fixed (T36871)
- Error report on saving incorrect snippet shortcut is fixed (T36847)
- Error report on shown Quick Info hint is fixed (T36838, 36822, 36872, 36908, 36912)
- Error report on starting add-in is fixed (T36817)
- Error report on using Member List is fixed (T36664)
- Wrong formattting of words case is fixed (R7272)
- Problem with columns suggestion is fixed (T35219, 36706, 36785)
- Problem with the conflict with SQL Treeo is fixed (T36525)
3.5.51 2-Feb-12
New Features
- Support of SQL Server 2012 and SQL Server Compact Edition
As support for the new version of SQL Server was introduced together with full support for Compact Edition, developers got an opportunity to use the advanced SQL Intellisense functionality with any server version and edition, starting with SQL Server 2000 and up to SQL Azure.
- Column picker feature
New functionality will make it possible to create SELECT and INSERT queries, as it allows defining column lists for selecting, grouping, sorting and inserting without typing any code at all. The suggestion list appearance was changed now it supports hierarchical view for table columns and shows information about data type.
- Intellisense in SQLCMD mode
Scripts that are executed with the help of the command line utility, are usually parametrized. But often it is the reason of the fact that ability to show correct suggestions for objects is lost, because database or schema name can be a variable. Now SQL Complete solves this problem. Values of variables are taken from the text of the document and object suggestions work as with an ordinary SQL script.
- Automatic formatting of keywords on typing
Keywords are formatted according to the option settings. This will help to avoid appearance of keywords written in different registry, when part of them was inserted from the suggestion list and part was typed manually.
- Extended and revised SQL Snippets
We've revised existing code templates, added new ones, and changed the behaviour of the suggestion list on selecting a template. This will allow choosing the needed template as quickly as possible and reducing time needed for typing recurring code constructions. Also keep in mind that users can create their own SQL snippets with the help of the special editor.
- Extended T-SQL syntax support
Context-sensitive prompt of objects in the MERGE statement and a number of SQL Server 2012 T-SQL construction is supported.
- SQL formatting improved
Formatting of procedure and function code, CASE statements, comments, and column list inserted on wildcard expansion is improved.
- Express edition feature set extended
The free Express edition of our product is also improved. Now it supports SQL Server 2012 and SQL Server Compact Edition. Besides, information on columns is expanded, and hierarchical list structure that simplifies working with SELECT and INSERT statements is also available in the free edition.
3.1.28 15-Dec-11
- Error report on unloading SQL Complete commands is fixed (T34664, T34941, T35105)
- Error report on updating SQL Complete commands is fixed (T35167)
- Error report on opening Document Outline window on Visual Studio 2010 is fixed (T34828)
- Wrong syntax error on formatting a script is fixed (T35030)
- Problem with refreshing the list of databases when refreshing suggestions is fixed (T34777)
3.1.25 28-Nov-11
- Error report on unloading add-in is fixed (T33701, T34029, T34497, T34502)
- Error report on unloading SQL Complete commands is fixed (T34228, T34347, T34351, T34515)
- Application suspension on parsing chains of nested function calls is fixed (T33577)
- Wrong syntax error on formatting a script is fixed (T34234)
- Memory leak on working with documents is fixed (T34360)
3.1.21 9-Nov-11
- Error report on suggesting parameters is fixed (T33781)
- Bug with resetting toolbars layout between working sessions is fixed (T32978)
- Error report on describing metadata is fixed (T33650, T33518, T33680, T33713, T33751, T33765, T33773, T33848, T33860, T33875)
- Application suspension on parsing long expressions is fixed (T33471)
3.1.10 14-Oct-11
- Error report on describing metadata fixed (T32713, T33025, T33063, T33081, T33083)
- Error report on formatting code in Express Edition fixed (T32978)
- Error report on Quick Info fixed (T33170, T33185)
- Application suspension on large database fixed
3.1.5 4-Oct-11
- Error report on describing metadata fixed (T32005, T32902, T32924, T32934, T32936, T32942)
- Error report on turning off SQL Complete fixed (T32941)
3.1.3 3-Oct-11
New Features
- Linked servers support
- SQL statements support extended. The Standard Edition provides support for GRANT, REVOKE, DENY, ENABLE/DISABLE TRIGGER, and ALTER SCHEMA statements
- Highlight Occurrences on/off option is added
Improvements
- Usability of code completion improvement
- Installation process customization with the ability to integrate SQL Complete to different development environments is supported
- Tracing support
Express Edition Extension
- SQL statements support extended. Support for DROP, EXEC, and SET statements was added.
- Variables and parameters support
3.0.24 9-Sep-11
- Error report on suggesting tables to join is fixed (T31980)
3.0.23 6-Sep-11
- StackOverflowException that was leading to crashing SSMS has been fixed (T31980, T32005)
- A few other bugs were fixed as well
3.0.22 29-Aug-11
- Fixed memory leaks that can bring to OutOfMemoryException (T31700, T31263, T31220, T27617, T28922, T31543)
- Fixed snippet rendering (T31262)
- Added diagnostic facilities let users generate software productivity reports (T31265)
3.0.20 18-Aug-11
- Added integration into SSMS 2011 Denali CTP3 (T30730, T30788, 30910)
- Error report on formatting CURSOR query (T31066)
- Dedicated admin connection (DAC) is supported (T31024)
- Error report on working with snippet is fixed (T31325)
- Compatibility problem with Productivity Power Tools VS2010 extension is fixed (T31296)
3.0.16 28-Jul-11
- Problem with updating SQL Complete Express to new version is fixed (T30829)
- Error report on editing snippet in editor is fixed (T30981)
- Visual Studio 2010 freezes when open a project (T30964)
3.0.14 21-Jul-11
- Problem with reallocating hint windows is fixed (T30803)
- Error report on expanding ALTER VIEW statement
- Error report on expanding table valued function bodies in ALTER FUNCTION statement
3.0.13 20-Jul-11
- Error report at unload add-in is fixed (T30740)
- Error report on reseting alias generation options is fixed (T30743)
3.0.10 18-Jul-11
- Error report on deleting character is fixed (T30694, T30709, T30710, T30721)
- Problem with reallocating hint windows is fixed (T30680)
- Possibility to commit snippet with Tab key is added (T30644)
- Error report on scrolling items in Member List window is fixed (T30706)
3.0.7 14-Jul-11
New SQL Server versions support
- SQL Server 2011 (codename Denali)
- SQL Azure
- SQL Server Compact edition
Added integration into Visual Studio
- Visual Studio 2010: Professional, Premium, and Ultimate editions
- Visual Studio 2008: Professional and Team System editions
"Go to definition" for database objects
This function allows navigating from code editor to the object in the Object Explorer (Server Explorer in VS) tree.
Code Snippets
This feature makes it easy and convenient to use fragments of code over and over. The new functionality includes:
- Showing code templates in the dropdown list
- Opening templates on pressing Tab
- Adding and editing templates with the help of templates manager
- Possibility to add parameters to templates. Parameter values are entered by a user on inserting
New code completion features
- IntelliSense for temporary tables and table variables
- Expand EXEC statement feature. All parameters with value stoppers are inserted automatically on pressing Tab
- sys.sp_* procedures are now suggested without schema prefix in EXEC statement
- Expand ALTER statement for procedure, function, view, and trigger. Object body is inserted into the document automatically on pressing Tab
- Suggestions for DROP statements added
- Context-sensitive code completion for CREATE TRIGGER statement
- Extended support for T-SQL DECLARE statement
- Option for including default schema (dbo) into object name when pasting it into the text
- Hierarchyid data type support in code completion
Document Outline window
feature makes navigating through large SQL documents a real pleasure. The Document Outline window shows the structure of the current document. Besides, a user can synchronize structure with text right from the code.
Highlight occurrences of an identifier
This unique feature allows users to see all entries of an identifier in the document text. When the cursor is on the identifier, after a time lag all occurrences of this identifier into the text are highlighted.
SQL formatting component improved
- Stream formatting for large documents. Application no longer hangs when formatting
large SQL document. User can cancel the formatting process
- Common table expression formatting supported
- New formatting options for indenting JOIN clauses
- Message for invalid statements
Quick database object information extended
- Tool tip with parameters and descriptions of procedures and functions is shown
- Tool tip with columns list when the mouse cursor hovers over the asterisk in the SELECT list is shown
- For the alias in the FROM list, a table or expression with the list of columns is shown (if possible)
- Now name, type, keys, and some other properties are shown for columns
- Quick info is shown for the dropdown list items
"Execute current statement" feature
Now user can execute the current SQL statement (i.e. the one where the input cursor is located) in the document using the hot key.
Performance improvements
- Formatting speed increased
- Parsing speed of complex statements increased
2.50.92 30-May-11
- Critical bug with showing Quick Info is fixed
- Problem with checking updates is fixed (T29186)
2.50.91 27-May-11
- SSMS freezing when user scrolls a document to the end is fixed (T29293, T29294, T29309)
- Problem with SQL Complete keeping database connection open even if document was closed is fixed (T29279)
- NRE that occurs on collapsing and expanding regions is fixed (T29171)
- CTE queries formatting is fixed (T28971)
2.50.90 19-May-11
- SSMS freezing when user is working with script that contains collapsed regions is fixed (T28350)
2.50.89 13-May-11
- Some bugs with describing metadata from SQL Server are fixed (T27250, T28701, T28738)
- NRE on typing TRUNCATE keyword is fixed (T28350, T28693, T28703, T28751)
- NRE on parsing script scope declarations is fixed (T28628)
- Bug with column name insertion into column list in INSERT statement is fixed (T28412)
- Problem with changing local list separator to comma is fixed (T27639)
- NRE on editing MERGE statement is fixed (T27978)
- NRE on editing script when metadata from server is still being described is fixed (T28140, T28167)
- Bug on typing left parenthesis is fixed (T28084, T28144)
- Bug with formatting statements that contain quoted identifiers is fixed (T28659)
- Bug with suggestion of ELSE keyword is fixed (T27735)
- Problems with parsing large chains of nested method calls are fixed (T28467)
2.50.86 05-Apr-11
- Problem with formatting comments in BEGIN...END block is fixed (S11701569, S11701599)
- Problem with freezing on a large number of UNION in subqueries is fixed (T26826)
- Problem with formatting of ON condition in JOIN statement is fixed (T27429)
- NullReferenceException exception in Quick Info for aliases is fixed (T27535)
2.50.84 17-Mar-11
- Exception after typing the "]" symbol is fixed (T26826)
- ArgumentOutOfRangeException is fixed in several cases (T26915, T26946, T27023, T27119)
- Freezing of SSMS if Google Chrome is in background is fixed (T26353, T26474, T27133)
2.50.83 3-Mar-11
- NRE on INSERT formatting in stored procedures is fixed
- Application hanging on IF... ELSE ... IF parsing is fixed (T26794)
2.50.80 28-Feb-11
- Error on Quick Info displaying when some regions are collapsed in editor is fixed (T26718)
2.50.79 25-Feb-11
- Quick object info added
- Expand INSERT statement feature added
- Export/Import settings wizard added
- SSMS crashing on JOIN clause suggestion is fixed (T26417)
- Context-sensitive code completion for common table expressions (CTE) supported
- Improved logic for JOIN clause suggestions
- Put commas at the beginning of lines in lists option added
- Additional options to format CASE expressions and logical operands added
- Add/remove a space between a function name and an opening bracket of the argument list option added
- Reset Page Defaults button added
- Enabling native IntelliSense when SQL Complete is disabled (T26414)
2.00.51 10-Feb-11
- Changed behavior of suggestion commit on Tab (T25368)
- Fixed error in parameter info for functions of user-defined types (T26190)
- Fixed IndexOutOfRangeException while editing procedure text (T26234)
2.00.49 28-Jan-11
- Fixed critical bug with SSMS hanging (T25361, T25879)
- Fixed bug with replacing the caret to line end after a member list element commited (T25812)
- Fixed error at opening the SQL document with other editor (T25917)
2.00.48 27-Jan-11
- Fixed critical bug with describing metadata from SQL Server 2000 (T25870, T25873, T25899, T25903)
- Fixed bug with formatting selection (T25788, T25867)
- Closing connection after document closed (T25472)
2.00.46 21-Jan-11
- Fixed bug of formatting T-SQL statements with GOTO labels (T25752)
2.00.45 21-Jan-11
- Express (free) and Standard editions of the product available
- Possibility of working with large scripts
- Expanded support for Transact-SQL statements
- Suggesting conditions for JOIN statements
- Extended support for statements
- Suggesting methods for columns and variables
- Context-sensitive suggesting of collations, data types, XML schema collections, and languages
- Sorting keywords by relevance
- Qualifying a column name on completion
- Expanding a list of columns in SELECT statement
- Automatic alias generation in SELECT satatements
- Performance improvements
1.00.62 24-Dec-10
- Fixed error at startup (T25048)
- Parsing perfomance improved for UNION clause
- Fixed bug with keyword FROM suggestion (T25087)
1.00.61 13-Dec-10
- Fixed critical error at drop down list showing on localized SSMS (T24863)
1.00.60 13-Dec-10
- Parsing perfomance improved (T24602, T24612)
- Custom color schemes supported (T24685)
- Fixed error report at unload (T24573)
- Fixed a few bugs with drop down list scrolling by mouse wheel
- Fixed a few bugs with formatting of JOIN chains
- Fixed bug with keyboard tracking in drop down list when parameter info is shown
- Fixed bug with working in read only documents
1.00.57 1-Dec-10
- Fixed bug with insufficient memory when working with large scripts (T24435, T24463, T24504)
- Fixed bug: Two undo actions required to rollback inserted suggestion from drop down list
1.00.54 24-Nov-10
- Fixed error report at startup (T24380, T24364, T24423)
- Fixed bug with disabling embedded SSMS IntelliSense (T24445, T24455, T24464)
- Fixed bug with describing metadata from SQL Server Express edition
- Fixed error report at unload
1.00.48 19-Nov-10
First release of dbForge SQL Complete
© 2010-2012 Devart. All rights reserved.