6.8.13 16-Jun-21
New features and improvements
- Support for WITH INLINE for CREATE OR ALTER FUNCTION
- Support of APPROX_COUNT_DISTINCT
- Support of ALLOW_BATCH_MODE
User-reported and internal bug fixes
- Incorrect behavior of the Go to Definition functionality when the table name matched any database name (T305421, #51909)
- A completion list disappeared when Visual Studio faced any issues within a script (#52650)
- SQL Complete used verbose tracing even when the option was disabled
- Some schema objects were missing in the completion list due to specific circumstances (#50715)
- Possible failures when waking up from hibernation mode with SQL Complete up and running
- SQL Complete might face critical error when checking trial information
- Possible problems when trying to load SQL scripts factory from integration assemblies
6.7.13 11-Mar-21
- Copy HTML to clipboard did not format the clipboard as HTML (#49495)
- Possible add-in failure when displaying loads of query execution result
- The objects just created within an SQL document were missing from completion list after opening a new query window (T318722)
6.7.5 03-Feb-21
New features
- Suggestion of COLUMN MASTER KEY
- Suggestion of COLUMN MASTER KEY in CREATE COLUMN ENCRYPTION KEY
- Suggestion of ALGORITHM in CREATE COLUMN ENCRYPTION KEY
- Support for the "Go To Definition" feature for COLUMN MASTER KEY
- Support for the "Script Object as CREATE/ALTER" feature for COLUMN MASTER KEY
- Suggestion of PERSISTENT_LOG_BUFFER=ON ( DIRECTORY_NAME='' ) in CREATE DATABASE
- Suggestion of DBCC SHOW_STATISTICS
- CRUD generation is wrapped to the regions
User-reported and internal bug fixes
- When describing database objects, SQL Complete blocked some other queries from being executed on a server (T323445)
- Incorrect formatting for the nested BEGIN/END blocks (T320336)
- The NOEXPAND table hint was not recognized by the syntax checker (T321765)
- Possible failure when trying to display images within Data Viewer (T319013)
- Incorrect conversion of editor screen coordinates to text position in specific circumstances led to critical errors (T319950)
- The INSERT statement was expanded incorrectly for tables defined in a scope of a script (T322202)
- Incorrect behavior of the Document Outline window in specific cases (T323758)
- Variables were missing from the completion list after the FETCH NEXT clause
- The "File not found" errors when renaming scripts within Visual Studio projects after switching between projects (T320072)
- Possible critical errors when calculating parameter info, quick info, and code completion items
6.6.12 16-Sept-20
User-reported and internal bug fixes
- SSMS was hanging when navigating through scripts with lots of temporary tables (T313440)
- Columns that had multiple description properties specified were duplicated within the completion list (T316667)
- SSMS was hanging when trying to rename an alias (T316057)
- Incorrect quotations when exporting data to CSV format (T316919)
- The 'OBJECT_ID' was present in the completion list twice
- A CSV file with exported data was created as UTF-8 regardless of the state of the 'Use Unicode' option
- Function parameters information hint could be displayed in a wrong position and/or with inaccurate contents
- It was impossible to cancel formatting via the wizard
6.6.7 01-Sept-20
New features
- Column sensitivity classification information is available in the completion list and quick info. The statements to add and drop such classifications are asso suggested in the completion list.
- The export settings for CSV file format is added
- An option to tune the accuracy of decimals for Grid Aggregate is added
- An export Execution History to CSV file format is added
- Converting stored routines execution into a script for procedures with incomplete parameters or with no parameters specified is implemented
User-reported and internal bug fixes
- An autosuggestion will not start listing the code snippets instead of the table names in the SELECT statement if a table is more suitable (T314629)
- SSMS was hanging when scrolling through large scripts (T314167)
- The invalid script was generated by the 'Convert Exec to Script' action in case the procedure parameters contained flag attributes
- The keyboard navigation within the completion list stopped working after disabling and then re-enabling code completionn
- The 'Script Object as CREATE/ALTER' action fails with a critical error on specific database triggers
- The 'Script Object as CREATE/ALTER' did not work with the user-defined aggregate functions
- The completion list was not displayed for disconnected SQL documents in specific cases
- Quick info will not been displayed for inactive IDE
6.5.48 18-Aug-20
User-reported and internal bug fixes
- The most recently used connections list was broken after restoring a disconnected document. (T315664)
6.5.38 03-Aug-20
User-reported and internal bug fixes
- Issue with restoring connection for cached documents in add-in due to the error when running SSMS 18.6 (T315034, T315036)
- Missing hard brackets on object schema name when generating ALTER scripts for procedures and functions under the caret (T309129)
- Improper work of code completion for SELECT queries without alias in the Express edition of the add-in (T314328)
- Absence of a table declared in an SQL file in completion list in case if the document is not currently connected to a server
- Critical failure of the add-in when trying to format SQL files larger than 200 MB
- Unavailable regions outlining when the code completion functionality is disabled
- Duplicate listing of the 'dbo' schema in the completion list in a newly created SQL document
- Possible display of confirmation message boxes in the installation setup launched in the 'verisilent' mode during update in specific circumstances
6.5.27 09-Jul-20
User-reported bug fixes
- Other User-reported bugs are fixed (T312372, T312411, T312414)
6.5.23 09-Jun-20
New features
- Full support for SQL Server 2019
- SQL Complete Standard Edition is introduced
- Properties for built-in metadata functions (SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc.) suggestion
- Temporary tables suggestion is introduced
- OPENJSON objects suggestion is introduced
- Support for the following functions is added:NEWSEQUENTIALID, CERTPRIVATEKEY, CERTENCODED, PWDENCRYPT and PWDCOMPARE
-
Support for the following SQL statements: GRANT ALTER ANY SECURITY POLICY, GRANT ALTER ANY SENSITIVITY CLASSIFICATION,
GRANT ALTER ANY DATABASE SCOPED CONFIGURATION, GRANT ALTER ANY COLUMN MASTER KEY,
GRANT ALTER ANY COLUMN ENCRYPTION KEY, GRANT EXECUTE ANY EXTERNAL SCRIPT, GRANT ALTER ANY EXTERNAL DATA SOURCE,
GRANT ALTER ANY EXTERNAL FILE FORMAT, GRANT ALTER ANY EXTERNAL LANGUAGE, GRANT ALTER ANY EXTERNAL LIBRARY,
GRANT ADMINISTER DATABASE BULK OPERATIONS
- Expanded support for the function PREDICT for SQL Server 2019 is added
-
Expanded support for the following statements is added:
CREATE USER for Azure SQL Database, CREATE INDEX for SQL Server 2019, CREATE EXTERNAL LIBRARY for SQL Server 2019,
ALTER DATABASE for SQL Server 2019, ALTER TABLE for SQL server 2019, ALTER EXTERNAL LIBRARY for SQL Server 2019,
ALTER AVAILABILITY GROUP for SQL server 2019, DROP EXTERNAL RESOURCE POOL for SQL Server 2019,
DROP EXTERNAL LIBRARY for SQL Server 2019, ACCELERATED_DATABASE_RECOVERY in ALTER DATABASE for SQL Server 2019
- SSMS v18.5 integration is added
User-reported bug fixes
- Other User-reported bugs are fixed (T308215, T307877, T306055)
6.4.28 17-Mar-20
User-reported bug fixes
- Issue with formatting is fixed (T303611)
- Issue with installation is fixed (T305633)
- Issue with splitter in SQL document is fixed (T305719, T305967, T306248, T306276, T306801, T306914, T306914)
- Issue with reactivation is fixed (T305847)
- Other User-reported bugs are fixed (T305831, T306061)
6.4.15 20-Feb-20
New features
- Code Debugger
- Copying results from the Aggregate Panel
- Modified HELP for Command Line
User-reported bug fixes
- Issue with starting SSMS is fixed (T284066)
- Other User-reported bugs are fixed (T303611, T303611, T304090, T302930)
6.3.16 18-Dec-19
New feature
- New formatting profiles added (Collapsed, Commas before, Indented, Right aligned, Compact, Extended, and MSDN SQL)
User-reported bug fixes
- Issue with rename alias is fixed (T292967)
- Problems with incorrect the registry key editing is fixed (T293877, T294018)
- Other User-reported bugs are fixed (T284510, T284651, T284717, T284861, T284912, T285155, T285200, T285567, T285902, T286441, T289183, T289637, T289997, T290886, T292531)
6.2.37 31-Oct-19
User-reported bug fixes
- Problems with SSMS crash are fixed (T293381, T293220)
- Issue with sending Trace Log is fixed (T292916)
- Problems with incorrect formatting IsNull() are fixed (T294456, T297203, T297196)
6.2.23 01-Oct-19
New features
- Support for integration to SQL Server Management Studio v18.3
- Support for the MIN_ACTIVE_ROWVERSION function
- The Extend Insert Highlight Occurrences feature to show a popup with a column name in the values area
- Displaying MS_Description for the Azure objects
- Suggesting properties for the built-in metadata functions (SERVERPROPERTY, FILE PROPERTY, DATABASEPROPERTYEX, etc)
- Prompting times zones in AT TIME ZONE
- Prompting hints names for USE HINT option(use hint(->
- Prompting objects in the context of DBCC SHOW_STATISTICS
- Prompting indexes in WITH clauses WITH(INDEX(->
- Prompting GENERATED ALWAYS AS ROW START clause
- Displaying property names for the SERVERPROPERTY functions
- Support for the DBCC CHECKIDENT construct
- Exclusion of IDENTITYCOL, $IDENTITY when unfolding asterisk
- Jumping between BEGIN TRY/END TRY and BEGIN CATCH/END CATCH
- Jumping between CASE and END
User-reported bug fixes
- Problem after SQL Complete turning off is fixed (T288899)
- Issue with alias and column name is fixed (T286335)
- Issue with incorrect code formatting is fixed (T284847)
- Other User-reported bugs are fixed (T251508, T197848, T251458, T289149, T285628, T281971, T284642, T281815, T284722, T285768, T289616, T292368, T284493, T284510, T284963, T285414, T285848, T286328, T290183)
6.1.72 10-Jun-19
User-reported bug fixes
- Problems with SSMS crash are fixed (T280148, T283680)
- Problems with Documents Restore functionality are fixed (T283543, T283573, T283605, T283638, T283882, T283916, T283982)
6.1.59 21-May-19
User-reported bug fixes
- Problems with 'SQL Complete Package' extension loading are fixed (T270142, T270203)
- Issue with text editor freezing is fixed (T264017)
- Compatibility problems with VS2019 are fixed (T277927, T277060)
- Auto complete Issue with CASE statement is fixed (T264017)
6.1.13 26-Mar-19
New features
- Visual Studio 2019 Support
- SQL Format Command Line
- Summary Panel Visibility
User-reported bug fixes
- Issue with aggregate panel is fixed (T276755)
- Issue with formatting UPDATE statement is fixed (T275246)
- Issue with formatting case-sensitive object names is fixed (T274277)
- Other User-reported bugs are fixed (T274915, T270005)
6.0.136 12-Feb-19
User-reported bug fixes
- Problems with SSMS launching after SQL Complete installed are fixed (T273089, T274274, T274284, T272455, T274630, T274985)
- Issue with establishing a connection to Azure SQL is fixed (T270260)
- Issue with a completion list is fixed (T273175)
- Issue with renaming a formatting profile is fixed (T273099)
6.0.101 27-Dec-18
User-reported bug fixes
- New option "Automatically hide when a single cell is selected" is added (T271378, T271436)
- Error during Snippet Manager opening is fixed (T270543)
- Wizard installation issue is fixed (T270173)
- Shortcuts issue is fixed (T268682)
6.0.79 04-Dec-18
User-reported bug fixes
- Freezing SSMS issues are fixed (T270037, T270109, T270142, T270037, T269942, T269845)
- SSMS Results Grid crashing issues are fixed (T270102, T270177, T270328, T270364)
- Issue with Error Report during script execution is fixed (T270406)
- Option name is corrected (T270328)
6.0.69 23-Nov-18
SQL Server support
- Connectivity Support for SQL Server 2019
- The latest SQL Server Management Studio v18.0 Public Preview 5 integration support
Find in Results Grid
- Invoke Search panel instantly with a new shortcut
Execution Notification
- Days are displayed in execution notification
SQL Formatter
- Description for disabling formatting is added in the 'Options' window
Code Snippets
- Sort snippets in Snippets Manager
Grid Aggregates
- Multiple Columns Grid Selection for Grid Aggregates Panel
- Option to make Grid Aggregates row permanently visible
- Support for the date/time and string data types MIN/MAX
- Separation with Space is added for the results of the aggregate functions in the status bar
Execution Warning
- Analyze DROP statement
- Analyze USE statement
- No warnings for part of the Script
Tabs Color
- Status bar coloring in addition to tabs color
- Objects Explorer coloring in addition to tabs color
- Ability to assign different tab colors for the databases belonging to the same connection
SQL Document
- Items are rearranged in the popup menu for better usability
- Proportional tab widths and the ability to control what was displayed in the tab name
Other Improvements
- The Express Edition will be activated after Standard Edition trial expires
User-reported bug fixes
- Problems with opening big files are fixed (T266832, T266833)
- Navigation issue is fixed (T247158)
- Command "Convert EXE to Script" issues are fixed (T266066, T266355)
- Quick Info issues in Express Edition are fixed (T262357, T266349, T266838)
- Tab Colors issue is fixed (T247550)
- Formatting issue is fixed (T264783)
- Issue with positioning on root element in Document Outline is fixed (T253216)
- Other User-reported bugs are fixed (T266804, T231498, T252989, T246607, T247548, T259302, T252989, T248336, T248616, T265332, T267173, T263194, T258632, T263802, T262268, T248148, T250961, T258294, T268341)
5.9.66 19-Jul-18
User-reported bug fixes
- Issue with Documentation links is fixed (T259701)
- Some problems with activation are fixed (T246023, T257072)
- Assembly loading issue is fixed (T259851)
- Invalid objects finding issues are fixed (T256421, T255710)
- Issue with Convert Exec to Script is fixed (T256047)
- Problems with NRE after freezes are fixed (T250738, T251702)
- Other User-reported bugs are fixed (T257787, T256958)
5.9.60 16-May-18
Connectivity feature
- Active Directory - Universal with MFA support
Code Completion features
- Suggestion TEMPORAL_HISTORY_RETENTION supported
- Suggestion HISTORY_RETENTION_PERIOD supported
- Suggestion IDENTITY_CACHE
- Suggestion Automatic database tuning supported
Code Refactoring features
- Rename variables in UPDATETEXT supported
- Rename variables in WRITETEXT supported
- Rename variables in READTEXT supported
- Rename variables in REVERT supported
Productivity features
- Results Grid Data Visualizers
- Copy Data As from SSMS grid to XML, CSV, HTML, JSON
- Copy Data As from SSMS grid to Clipboard
- Copy Data As from SSMS grid to File
- Shortcuts to SSMS grid popup menu assigned
User-reported bug fixes
- Formatting issues are fixed (T220855, T251389, T251508, T255373, T252500, T253851)
- Script generation issue is fixed (T237590)
- Issue with function parameters description is fixed (T247627)
- Some issues with NRE are fixed (T251681, T251695, T252145, T252453, T253644, T254698)
- Problems with requesting UI from the thread different from main are fixed (T247478, T248825, T250271, T251116, T251682, T252146, T252494, T254072, T254050, T254538, T254633, T256425, T248118, T248954, T250058, T250200, T247527, T248464, T252229, T254015)
- Issue with finding invalid objects is fixed (T253855)
- Other User-reported bugs are fixed (T246508, T246674, T248305, T251429)
5.8.188 03-Apr-18
User-reported bug fixes
- Numeric columns aggregation issues are fixed (T251798, T251464)
- Others issues with NRE are fixed (T247743, T251337, T247158, T251240, T251722, T251867, T251883, T251917, T252116, T252196, T252207, T252286, T252352, T252484, T252412, T252665, T252676, T252809, T252826)
5.8.187 16-Mar-18
User-reported bug fixes
- Issue with SQL Complete and SharePoint Online is fixed (T243740)
- Issue with assembly Devart.Shell.Common.r1 is fixed (T246483, T249112)
- Issues with formatting SQL statements are fixed (T247454, T248337)
- Issue with creating local temp table is fixed (T246674)
- Issue with navigating to definition is fixed (T247158)
- Issue with opening file from WEBDAV location is fixed (T249458)
- Issue with message "Keyword not supported: 'authtype'" is fixed (T249624, T249985)
- Issue with license file is fixed (T248620)
- Issue with temp table is fixed (T249623)
- Issue with closing Visual Studio is fixed (T250533)
- Other User-reported bugs are fixed (T246552, T247367, T248266, T248140, T250155, T250281)
5.8.178 15-Feb-18
User-reported bug fixes
- The operation was canceled (T247103, T247160, T247547)
- Collection was modified; enumeration operation may not execute (T246640, T246822)
- Issue with invalid procedures is fixed (T246490)
- Issues with editing SQL Document are fixed (T246482, T246691, T246903, T246908, T246965, T246967, T247062, T247122, T247349, T247322, T247314, T247347, T247424, T247626, T247756, T247744, T247947, T248080, T248130, T248210, T248252)
5.8.173 31-Jan-18
Code Completion features
- Prompt extension in SQLCMD Mode
- Display a list of CHECK and DEFAULT constraints
- Unwrap sp_executesql
- OLE DB provider names are now suggested for OPENROWSET and OPENQUERY
- XML methods suggestion XQuery
- Support of the following statements:
- ALTER MESSAGE TYPE
- DROP MESSAGE TYPE
- CREATE TYPE .. AS TABLE
- CREATE TYPE .. FROM
- SET DATEFORMAT
- SEND ON CONVERSATION
- CREATE QUEUE
- CREATE AGGREGATE
- CREATE ASSEMBLY FROM
- DBCC CLONEDATABASE
New productivity features have been implemented
- Jump between BEGIN/END allows navigation through the whole block on matching keywords of the BEGIN/END statements
- Jump between COLUMNS and VALUES in INSERT statement helps you easily find a corresponding value of the specified column in INSERT statements
- Execution Warnings shows a warning message that may cause data loss when executing UPDATE or DELETE statements without a WHERE clause, as well as TRUNCATE
- CRUD Generator generates a result script for SELECT, INSERT, UPDATE, and DELETE statements to a new SQL document
- Run script on multiple databases to execute a script to a new SQL document on the selected database on the connection you choose
- Execution Notifications displays name of the document and duration when the query execution is completed
- Transaction Reminder alerts users that a transaction has not been completed if you execute a script by clicking F5 in SSMS
- Find in Results Grid searches the required data by highlighting all the matches either by case, or whole words, or regular expressions in the results grid
- Copy Results Grid Headers makes a copy of the selected column names and/or types to CSV, XML, HTML, and JSON data formats
- Grid Aggregates: selecting two or more rows in one column automatically opens an aggregate grid that displays calculations on the SSMS status bar
- Named Regions allows users to parse named and unnamed regions automatically, as well as wrap and unwrap regions
- Find Invalid Objects allows users to search invalid objects in the selected database
- Formatting Profile Quick Select allows users to quickly switch between active formatting profiles, as well as edit profiles by opening the Formatting Profiles window
- Several fixes and improvements on Documents Sessions
User-reported bug fixes
- Code Completion issues are fixed (T245079, T240827, T237465, T197850, T243299)
- Installation and Integration issues are fixed (T157183, T243437, T244064, T244079, T244081, T244795, T237433)
- SSMS 2014 becomes completely un-responsive issue is fixed (T233514, T234843, T235413, T235331, T235341, T238014, T240544, T241625, T242939, T244938)
- Close All Unmodified Tabs issue is fixed (T231527, T237490, T237535)
- Other User-reported issues are fixed (T245029, T243765, T239491, T241366, T230844, T239173, T239166, T239841, T241228, T241526, T239210)
5.7.210 23-Nov-17
User-reported bug fixes
- Issue causing VS and SSMS restart is fixed (T235996, T236212, T236537, T237185, T237245, T237956, T235616, T238292, T238662, T238738, T238746, T238806)
- Issue with PIVOT and UNPIVOT statements is fixed (T233205, T233336, T234152, T234538, T234706, T234711, T234823, T234837, T234873, T235854, T236216, T236775, T238127, T238218, T238347, T238500)
- Performance issues with SSMS 2012 are fixed (T234530)
- 'Failed to compare two elements in the array' error message fixed (T235821, T237181)
- Issues with editing and saving some snippets are fixed (T233116)
- Other User-reported bugs are fixed (T235129, T233778)
5.7.206 13-Oct-17
User-reported bug fixes
- 'Cannot access a closed Stream' error message is fixed (T233062)
- 'Item has already been added. Key in dictionary: '-1284069302' Key being added: '-1284069302'' error message is fixed (T232607, T232867, T232923, T233058, T233221, T233231, T233311, T233472, T234424, T234422, T234191, T234540, T234569)
- 'Begin' snippet issue is fixed (T233116)
- Known SSMS 2014 issues are fixed (T233514, T234843)
- Fixed issue with some sessions are not shown in Document sessions window (T234345)
5.7.200 19-Sep-17
- Issue with disconnect connection functionality is fixed (T232398, T232451)
5.7.199 15-Sep-17
User-reported bug fixes
- Integration issues are fixed (T231026, T231552, T231961, T232161, T232162)
- Pivot issues are fixed (T232069, T232151)
- Other fixes and improvements (T231269, T232190)
5.7.195 06-Sep-17
User-reported bug fixes
- Issue with running several instances of SSMS 2012 and SSMS 2014 is fixed (T230787, T231080, T231137, T231143, T231185, T231218, T231220, T231232, T231238, T231243, T231266)
- Issue for users with limited access to Program Data folder is fixed (T229996)
- Other minor fixes and improvements
5.7.194 30-Aug-17
SQL Server support
- SQL Server 2016 Service Pack 1 (SP1) new syntax support
- SQL Server 2017 CTP2 new syntax support
- Azure SQL Data Warehouse connectivity support
- The latest SQL Server Management Studio v17.2 integration support
Code Completion
- Column match highlighting in the INSERT statement
- Database element dropping from the prompt in Completion List
- Possibility to exclude a scheme in the ON condition of the JOIN statement
- Possibility to connect/disconnect when describing/pre-describing objects of the same database
- Query navigation
- CASE END pairs highlighting
- Extended suggestion in the PIVOT/UNPIVOT queries
- Extended support for CTE
- Prompt and QI of variables in named transactions
- CREATE OR ALTER statement support
- Support of the following statements:
- DROP ROUTE
- ALTER ROUTE
- ALTER SERVICE
- ALTER QUEUE
- DROP SERVICE
- DROP CONTRACT
- ALTER EXTERNAL RESOURCE POOL
- CREATE PARTITION FUNCTION
- CREATE EXTERNAL TABLE AS SELECT
- ALTER EXTERNAL DATA SOURCE
- CREATE REMOTE TABLE AS SELECT
- ALTER EXTERNAL DATA SOURCE
- ALLOW_ENCRYPTED_VALUE_MODIFICATIONS at CREATE USER
- CREATE (ALTER, DROP) COLUMN ENCRYPTION KEY
- STRING_AGG
- CONCAT_WS
- TRANSLATE
- TRIM
- BULK INSERT and OPENROWSET (BULK...)
- BLOB_STORAGE option of EXTERNAL DATA SOURCE
- DBCC CLONEDATABASE
- ALTER ANY MASK
- BACKUP (RESTORE) DATABASE TO URL
- ALLOW_ENCRYPTED_VALUE_MODIFICATIONS
SQL Document
- New query execution history feature saves information about SQL statement you run
Other new features
- Generate Script As from SSMS grid
- Work with Azure Data Warehouse
- Tab Coloring
- Get Row Count in Quick Info Window
User-reported bug fixes
- Code Completion issues are fixed (T174928, T188896, T139538, T219741, T205775, T209951, T116500, T116500)
- Visual Studio 2013/2015 Shell is supported (T214197)
- SQL Formatter issues are fixed (T224697, T220514, T225119)
- Tabs Management issues are fixed (T219960)
- Other User-reported issues are fixed (T227635, T229651, T229401, T228528, T221227, T229404, T218100, T228469, T228576, T228851, T224476, T226054, T227213, T227596, T226417, T219628, T212055)
5.6.150 25-Apr-17
- Known Document Sessions issues are fixed (T215713)
- User-reported debug issue is fixed (T215835)
- User-reported issue with document schema is fixed (T214010)
5.6.146 21-Apr-17
- NRE when opening C# projects in VS2015 is fixed (T215527, T215543, T215554, T215565, T215573, T215580, T215549, T215619, T215623, T215576, T215633)
5.6.145 20-Apr-17
- Compliance with the Federal Information Processing Standard (FIPS)
- Trial product activation implemented
- Greatly improved visual style of the application with high DPI support
- Product now integrates into VS 2017 and SSMS 17.0 RC3
- Restoring last closed tab is implemented
- Restoring document sessions is implemented
- Ability to close unmodified tabs is implemented
- Ability to set custom SSMS main window title and caption for sql document tabs
- Support of the following statements:
- BULK INSERT
- ALTER APPLICATION ROLE
- DROP APPLICATION ROLE
- DROP DATABASE
- DROP DEFAULT
- DROP QUEUE
- CREATE LOGIN, ALTER LOGIN, DROP LOGIN
- CREATE APPLICATION ROLE
- RECEIVE
- DROP STATISTICS
- CREATE FULLTEXT STOPLIST
- CREATE DEFAULT
- CREATE XML SCHEMA COLLECTION
- Suggestion improvements:
- Filegroups suggestion
- System versioning
- Transactions Suggestions
- Stretch tables
- Always encrypted
- Dynamic data masking
- Row-level security
- Fully qualifying a table with the server name is supported
- Suggestion of databases created in script is supported
- Column suggestion for CTE is improved
- JOIN synonym suggestion is implemented
5.5.218 05-Dec-16
- SQL Complete now integrates into VS 2017 RC and SSMS 17.0 RC1
- Error report during parsing and editing text is fixed (T192703, T193151, T193396, T193472, T193744, T193599, T194022, T194491, T194908, T195244, T195841, T195970, T196024, T196027, T196723, T196951, T197140, T197532, T197640, T197856, T197872, T197907)
5.5.215 10-Oct-16
- SQL Compete will not catch exceptions of 3rd party installed modules anymore (T190902, T190767, T190762, T190753, T190749, T190697, T190672, T190893, T190785, T190632, T190195)
5.5.214 03-Oct-16
- Issue with Refresh Local Cache shortcut is fixed (T188265)
- User-reported issue with specific script is fixed (T187560)
- Issue with code suggestion context is fixed (T189328, T181959, T189329, T189689)
- Issue with ability to view error reports is fixed
5.5.205 16-Sep-16
- NRE when opening project is fixed (T187173)
- User-reported error messages are fixed (T184815, T181808, T184803, T183887, T184019, T185535, T186496, T186614, T187033, T186955, T186809, T185023, T186070, T186446, T186803, T187211, T182330, T182725, T182966, T183196, T183385, T183447, T183522, T183954, T184028, T184084, T184261, T184260, T184629, T185066, T185061, T185097, T185519, T185708, T185675, T185773, T185814, T186114, T186133, T186056, T186058, T186113, T186261, T186352, T186540, T186899, T186900, T187154, T187069, T187085, T187212)
- Issue when opening Database diagram is fixed (T185156)
- Code completion issues are fixed (T181928, T185094, T185141, T185522, T185051, T182082, T181963, T184616, T184865, T185092)
- Formatting issues are fixed (T183698, T184715, T184840, T187215, T184859, T182953, T183368, T182400, T184281, T185476)
- Fusion and CodeRush compatibility issues are fixed (T182800, T185801, T186196, T181201)
- Performance issues are fixed (T181959)
5.5.166 09-Aug-16
- Issue with Quick Info is fixed (T182503, T182668, T182729, T182737)
- Snippet issue is fixed (T181204)
- User-reported NRE is fixed (T182487)
5.5.159 04-Aug-16
- 'startIndex cannot be larger than length of string' error message is fixed (T179987, T180148, T180263, T180323, T180473, T181179)
- 'The code of your SQL script will be used only for debugging and fixing your problem' error message is fixed (T181925, T182077, T181906, T181960)
- 'Invalid offset: 105' error message is fixed (T181227, T181373, T181855, T182069)
- Formatting issue in Express edition is fixed (T181207)
- Issue with expanding column names from * is fixed (T181858)
- Other User-reported bugs are fixed (T181779, T181379, T181954, T181770, T182054, T180595)
5.5.145 26-Jul-16
- Integration issues into newer build of SSMS 2016 are fixed (T180130, T180149, T178876, T180215, T180241, T180409, T180414, T180416, T180458, T180347)
- Issue with functions suggestion is fixed (T178014, T180163)
- NRE are fixed (T180147, T179991)
- Installation issues are fixed (T179973, T180155, T180571)
5.5.136 20-Jul-16
- New SQL Server 2016 syntax supported
- SQL Complete now integrates into SSMS 2016
- Objects suggestions in CROSS/OUTER APPLY statement
- Suggestion of compound phrases
- Greatly improved suggestion performance
- Several new formatter options and profiles
- Both objects and schemas suggestions in Completion List when writing cross-database queries
5.1.46 22-Dec-15
- Visual Studio 2015 integration issue for non-admin account is fixed (T155536)
- Go to Definition issue is fixed (T154906)
- User-reported exception is fixed (T152392)
- DBCC IND command is supported
- Some known Install and Uninstall issues are fixed
5.1.42 04-Dec-15
- SSMS integration issues are fixed (T148834, T149496, T149283, T149546, T151495, T151593, T152940, T153914)
- Geospatial functions support improved (T148176)
- User-reported exceptions are fixed (T153546, T146511, T150036, T145874, T145498, T145770)
- Better formatting and suggestions support (T138756, T143135, T146178, T147295, T149991, T146962)
- Debugging in SQL Management Studio issue is fixed (T150174)
- Ability to select ngen options during installation process (T150688)
5.1.14 16-Sep-15
Integration to Microsoft Visual Studio 2015 is supported
-
SQL Complete features are now available in VS 2015
User-reported bug fixes
-
Bug fix and stability improvements (T142282, T142262, T143710, T142262, T143137, T143672, T142300, T142549)
5.0.34 19-Aug-15
- MSSMS 2005 and MSSMS 2008R2 crashes are fixed (T141481, T141727, T141699, T141756, T141725, T141718, T142163, T142208, T142067)
- Snippet issues are fixed (T141233, T141153, T140749, T141237, T127361, T142075)
- Issue when renaming variables is fixed (T140745)
- Other bugs fixed (T140743)
- Snippets and SQL Refactoring highlight color settings are improved
5.0.28 05-Aug-15
Statement Expansion
UPDATE statement support added
Code Snippets
TRANSACTION and ROLLBACK TRANSACTION code templates are now available
Custom Alias Mapping
Assigning of custom aliases to a table, view, table-valued function, or synonym referenced to in an SQL document
Code Highlighting
Highlight of both the opening and closing code elements to visually define separate code blocks and determine mismatched or misspelled paired code elements
Code Refactoring
Changing all occurrences of variable names and object names to new ones, automatically finds and corrects all references to them
Semicolon Insertion
Inserting missing semicolons after each statement in a query
SSDT Project Support
SQL Complete is now available in SSDT SQL Server projects
4.8.43 19-Feb-15
- Performance decrease issue in files with lots of code is fixed (T124068, T122743)
- 'Object reference not set to an instance of an object' issue is fixed (T124180)
- Issue with completion list in comments is fixed (T122604)
- Other completion list fixes and improvements (T123274)
- Dark theme colors issue is fixed (T105335)
- 'The EXECUTE permission was denied' error message is fixed (T118788)
4.8.34 25-Dec-14
- Object reference not set to an instance of an object exception is fixed (T120206, T120209, T120285, T120489, T120506, T120563, T120619, T118656, T118795, T119008, T119180, T119214, T119452, T119489, T119542, T119630, T119531, T120456)
- Some functionality improvements are implemented (T119646)
- Issue with [Security].Users table columns autocompletion is fixed (T119169)
- Issue with functions suggestions is fixed (T118980)
- Pasting text for literal name issue is fixed (T118875)
- Issue with Go To Definition is fixed (T118526)
- Autoformat not working on SQL Server 2008R2 is fixed (T118664)
- OutOfMemoryException for large scripts is fixed (T118263)
- Useless implicit code completion blocks are removed (T118333)
4.8.33 01-Dec-14
- ArgumentOutOfRangeException is fixed (T118467)
- Operation of the autocompletion functionality is fixed (T118255)
- Error with connecting to server is fixed (T112540)
- Error with suggesting keywords is fixed (T118061)
- Error with displaying the native IntelliSense in SQL Server2008 is fixed (T118255)
4.8.17 13-Nov-14
Code formatter
Code completion
Support of the following statements:
- MERGE
- CREATE DATABASE
- ALTER DATABASE
- DROP DATABASE
- BACKUP DATABASE
- EXEC sp_attach_db
- EXEC sp_detach_db
- CREATE STATISTICS
- UPDATE STATISTICS
- DROP STATISTICS
- CREATE INDEX
- ALTER INDEX
- DROP INDEX
- ENABLE TRIGGER
- DISABLE TRIGGER
Phrase completion
-
SQL Complete suggests not only separate keywords and object names, but entire code phrases
4.7.233 3-Sep-14
- Issue with VS 2012 Color Theme Editor (T108614)
- Issue with MSSMS 2005 integration is fixed (T109240)
- Issues with snippets usage are fixed (T110913, T111510, T111855)
- Issue with UPDATE statement formatting is fixed (T110968)
- Aggregate function suggestions are improved
- XML method suggestions are fixed
4.7.226 24-Jun-14
- User-reported bug fixes with black skins (T105335, T106880, T106892, T106939, T107037)
- Issue with Convert EXEC to script is fixed (T107152)
4.7.219 12-Jun-14
- Minor improvements and bugfixes
4.7.212 27-May-14
The new version contains a host of new features, including:
- Alias refactoring
- User defined table type suggestion
- Tables suggestion while creating indexes
- Support for new keywords introduced in SQL Server 2014
4.6.192 23-Apr-14
Integration to Microsoft SQL Server Management Studio 2014 is supported
-
SQL Complete features are now available in SSMS 2014
User-reported bug fixes
-
Exception when using MERGE statement is fixed (T101062, T101253)
-
Issue with disappearing suggestions is fixed (T102373)
-
Application updated with lots of minor bug fixes
4.5.178 17-Jan-14
-
A problem occurring while using a SSMS project is fixed (T95888, T95887, T95982)
4.5.177 14-Jan-14
-
An error occurring while installing SQL Complete on a computer with Microsoft Visual
Studio 2013 is fixed (T95606)
4.5.174 09-Jan-14
Integration to Visual Studio 2013 is supported
SQL Complete features are now available in Microsoft Visual Studio 2013.
New code formatter features
-
New Option: Add empty line after GO
-
New Option: Enclose identifiers within square brackets []
-
New Option: Add parentheses when inserting functions
-
New Option: Enable autoformat words while typing
-
New Option: Alias Text Case - As in declaration
-
Code formatter functionality is available even if SQL Complete is disabled
-
Do not format tag is implemented. Now it is possible to format a whole SQL document
in the editor ignoring selected code fragments which you do not want to be formatted.
Refresh suggestions cache
-
Automatic refresh suggestions cache by specified time is added
-
New option: Refresh suggestions cache on detecting changes on a server
New code completion features
-
SET IDENTITY INSERT tables suggestion is added
-
XML variables suggestion in the FROM statement is added
-
Column suggestion in the VALUES statement is added
-
Object suggestion for linked servers on SQL Azure is added
Minor improvements
-
Formatting CASE options are redesigned
-
Objects describe performance is improved
-
New snippets are added
4.0.140 06-Nov-13
-
A problem occurred while using connections for Azure databases is fixed (T90246,
T89728, T89777, T90303)
-
An error occurred while closing SSMS is fixed (T88386, T88619, T89574)
-
An exception occurred on closing an SQL document is fixed (T84588, T84670, T87662,
T88002, T89863)
4.0.137 16-Oct-13
-
An error, occurring while formatting a statement that contains row_number is fixed
(T87252)
-
Error report on renaming C# identifiers is fixed (T86278, T65080, T65140, T65205)
-
A problem related to the incorrect default schema definition is fixed (T84077)
-
Exception on closing an SQL document is fixed (T84588, T84670, T87662, T88002)
-
Error on detecting font is fixed (T59149, T86044)
-
New code formatting functionality for selected files and for all files in specified
directories, based on files extension, is added (T73730)
4.0.128 18-Sep-13
-
The error on formatting the FOR XML PATH construction is fixed (T84073)
-
The ability to multi-select and drag'n'drop snippets in Snippets Manager is added
(T83533)
-
The Issue with indenting the stack for the WHERE condition is fixed (T83479)
-
The bug with saving the status of the active profile when exporting/importing SQL
Complete settings is fixed (T83310)
-
The bug with the keyword NOLOCK in the suggestion list is fixed (T84077)
-
The bug with using user literals in Snippets Manager is fixed (T83533)
-
The bug with formatting the MAX specifier for the nvarchar data type is fixed (T83271)
-
The issue with changing the connection from SSMS 2012 to 2012 HADR availability
group is fixed (T74882)
-
The Issue with formatting the INSERT statement is fixed (T72808)
-
NullReferenceException on working with the SQL documents containing large XML content
is fixed (T84304)
4.0.120 23-Aug-13
-
New SQL Server connection string parameters are supported (T74882)
4.0.119 20-Aug-13
-
Formatting of built-in functions is fixed (R23495)
-
NullReferenceException on inserting a script in the Edit Profile window is fixed
(T75080)
-
FIRST_VALUE() and LAST_VALUE() functions are supported (T75169)
-
NullReferenceException on convert exec to script is fixed (T75954)
-
Problem on formatting block comments is fixed (T70679)
-
Problem on displaying hints when working with script objects is fixed (R26100, R26099)
-
Problem on F12 (Go to Definition) is fixed (T75067)
-
Issue with schema objects suggestion on using system role as schema object is
fixed (T74281)
-
Issue with suggesting keywords in the OVER clause is fixed (T74531)
-
Issue with displaying context menu in Microsoft Visual Studio 2008 is fixed (R24790)
-
Problem on displaying user name on using LOGIN literal in Snippets Manager is fixed
(T75592)
-
Inner query performance is optimized (T76865)
-
Issue with disabling SQL Complete in one environment after an error was encountered
when loading it in another environment is fixed (T72771)
4.0.109 31-Jul-13
-
The cursor variable formatting error in the UPDATE statement is fixed (R23749)
-
The WITH statement formatting error is fixed (T72808)
-
Comments indention formatting error is fixed (T70679)
-
An error occurs when attempting to update using the Update Manager is fixed (T74248, T74177)
-
Columns Sorting error in CTE (while expanding) is fixed (T74167)
-
The THROW statement formatting error is fixed (R24226)
-
In the INSERT statement an additional stack is added, for the output clause columns
(T73730)
-
An error occurs when attempting to use "Value" in the column name is fixed (T73080)
-
An error occurs when attempting to Convert EXEC to script is fixed (T72750, T72772)
-
A NullReferenceException while starting MSSMS 2008 is fixed (T72793, T72863, T72792)
-
A NullReferenceException while creating an SQL document is fixed (T72783)
-
The xml_schema_namespace function is added to the Member List (T72216)
-
The "As in declaration" option for variables is added (T72221)
-
The Parameter Info displaying error is fixed (T68797)
-
The statements to receiving the external indexes and foreign keys are optimized
(R22070, R25258)
4.0.89 21-Jun-13
-
'As in the declaration' formatting option is added (T22793)
-
Issue with formatting of comments is fixed (T21840)
-
NullReferenceException on changing a caret position is fixed (T22609)
-
Problem on importing the settings of previous product builds is fixed (T22752)
-
Issue with automatic formatting is fixed (T23064)
-
Issue with absence of the xml_schema_namespace function in the suggestion list
is fixed (T22881)
4.0.78 30-May-13
-
Error report when SQL Complete is resuming after hibernate is fixed (T66949, T69546,
T67571, T68582)
-
Error message occurring on working after a current database was dropped is fixed
(T68763)
-
Error report when opening a project that contains .sql files is fixed (T69064, T69878,
T69881, T70200, T70323, T70704, T70706, T71105, T71281, T71451, T71745, T72223)
-
Error report when loading SQL Complete with IDE using corrupted commands cache (.prf
file) is replaced with a resolve suggestion message (T68972)
-
Problem when typing <column_alias> = <expression> form of select list
item is fixed. Now SQL Complete doesn't commit items from Members List by typing
the '=' character (T69304)
-
Error during install SQL Complete is fixed (T69573)
-
Issue with using SQL Complete with SSMS 2005 Express is fixed (T69394, T69823,
T69924, T71680, T72118)
-
Issue with wrong formatting of the columns having the 'value' name is fixed (T70332,
T71689, T71712)
-
Syntax check errors when formatting some SQL statements is fixed (R21459, T71042)
-
Issue with adding table aliases when committing a column from Members List in
the SET clause of the UPDATE statement is fixed (T70220)
-
Problem on the formatting that removes a line break before comments is fixed (T70679)
-
Wrong expanding columns list is fixed (T71039)
-
Wrong formatting of CTE clause is fixed (T70927)
-
Wrong expanding of the ALTER PROCEDURE statement is fixed (T72216)
-
Problem on generating the AS keyword before a table alias with the corresponding
option being checked is fixed (T72284)
4.0.72 29-Mar-13
-
Error report when working with large T-SQL scripts is fixed (T68572)
4.0.71 20-Mar-13
-
IDE crash on formatting is fixed (T67992, T67130)
4.0.70 15-Mar-13
-
Error report on typing the CREATE VIEW statement is fixed (T68736)
4.0.69 13-Mar-13
-
Issue with generating aliases is fixed (T68029)
-
Issue with navigating to objects through connections like (local)server_name is
fixed (T68375)
-
Wrong formatting of CASE statement is fixed (T67992, T65799)
-
Issue with showing semi-transparent hints is fixed (T67917, T67895)
-
More accurate description of MIN/MAX aggregate functions is provided (T67913)
-
Wrong formatting of JOIN chains in subqueries is fixed (T67303)
-
Issue with highlighting identifiers that started with '_' symbol is fixed (T67126)
-
Error report when working with T-SQL documents is fixed (T67120)
-
Error report on closing VS 2010 is fixed (T67455, T67585, T68228)
-
Error report on closing a T-SQL document using VsVim command is fixed (T66835)
-
Wrong formatting of statements that contain syntax errors is fixed (T66626, T67533)
-
Problems with using SQL Complete hints in positions after subqueries are fixed (T66593)
-
Autocomplete words from incomplete Member List is disabled (T46165)
4.0.68 05-Mar-13
-
Issue with a CTE statement formatting is fixed (T68060)
-
Error report when opening CodeSmith Generator templates is fixed (T67534)
-
Error report when pasting code into the script with disabled SQL Complete is fixed
(T67391)
-
Incorrect formatting of built-in data types is fixed (T67334, T67631)
-
Error report when working with non T-SQL documents is fixed (T67352)
4.0.67 28-Feb-13
-
SSMS 2012 crash after executing query when 'Disconnect after the query executes'
option is turned on is fixed (T67813)
-
Error report on typing query in procedure body is fixed (T66715, T67288, T67404,
T67646, T67708, T67712, T67803, T67982)
4.0.65 19-Feb-13
-
Issue with the 'Refresh Local Cache' command is fixed (T67021)
-
Issue with saving shortcuts for SQL Complete commands is fixed (T66732)
-
GDI objects leak leading to SSMS 2005 crash is fixed (T66621, T36664)
-
Error report on saving a document is fixed (T65861)
4.0.61 22-Jan-13
-
Error report when showing popup menu in text editor is fixed (T64648, T64688, T65468,
T65810, T66016)
-
Error report on adding cursor declaration to routine body is fixed (T65756)
-
Error report when opening .sql file in Visual Studio 2012 is fixed (T65626)
-
Error report on expanding routine call is fixed (T65519)
4.0.58 16-Jan-13
-
Error when starting IDE with SQL Complete being installed using the "Run As .."
command is fixed (T64082, T64147, T64555)
-
Issue with formatting column list when expanding a statement to a full template
by pressing the Tab key is fixed (T65227)
-
Formatting of the CASE statement is improved (T65260)
-
Error message on formatting a script is fixed (T16983)
-
Issue with using SQL Complete in statements like 'select db..' is fixed (T65223)
-
Wrong snippet highlighting is fixed (T65261)
4.0.57 09-Jan-13
-
Error report when loading VS 2008 is fixed (T64192, T64193, T64198, T64199, T64501)
-
Error report when loading VS 2010 is fixed (T64300, T64526, T64568, T64706, T64876,
T64952)
-
Error report on renaming C# identifiers is fixed (T64238, T64278, T64893)
-
Wrong formatting IF blocks is fixed (R16744)
-
Wrong indenting FROM clause is fixed (T64156)
4.0.55 25-Dec-12
-
Error report during loading VS 2008 is fixed (T63755, T63990, T64043, T64049)
-
Error report during opening query is fixed (T63813, T63859, T63933, T64066, T64067)
-
Issue with saving custom shortcuts for SQL Complete commands is fixed (T63660)
4.0.54 20-Dec-12
-
'Do not change' identifier case formatting option added (T63683, T63686, T63713,
T63709, T63724, T63726, T63733)
4.0.53 11-Dec-12
Formatting profile introduced
-
Individual file for storing formatting preferences
-
Multiple formatting profiles and profile import are supported
-
Single-profile can be used for multiple workstations
New formatting options editor
-
Option quick search filter is added
-
Sample code formatting displayed according to current formatting settings
-
Editable sample code formatting preview is added
Enhanced formatting settings
-
Independent and precise adjustment for SQL-statements is added
-
Formatting settings for sub-queries are added
-
Word recognition for UPPER, lower and CamelCase formatting in identifiers is supported
-
Independent built-in datatype case formatting settings are supported
New SQL code refactoring features
-
Code and database identifier case synchronization is added
-
Stored procedure call expansion is supported
New code completion features
-
Table order in ON condition of suggested JOIN clause can now be reversed. Behavior
can be toggled in the options menu
-
Inserted columns in SELECTs are now automatically qualified with a table alias.
Behavior can be toggled in the options menu
-
Functions are now inserted from suggestion list with braces
-
'Refresh Local Cache' and 'Refresh Suggestions' commands now use the same shortcut
-
ALTER TABLE statement now has context-sensitive identifier suggestion
-
'Run Current Statement' command usability slightly improved
-
Code completion for temporary tables has been added to the Express edition
Integration with SSDT in Visual Studio 2010/2012 is supported
SQL Complete features are now available in the SSDT 2010/2012 SQL Editor.
3.5.83 12-Sep-12
-
Error report during expanding routine body is fixed (T54781)
-
Formatting "modify" function with wrong case is fixed (T51725)
-
Issue with Visual Studio freezing during opening vb.net project properties is
fixed (T50209)
-
Error report during expanding routine body with datetime parameters is fixed (T48482)
-
Memory leak is fixed (T58309, R11692)
-
Error report during opening query to default database is fixed (T42731, T48350,
T50212, T58292, T58879)
-
Error report during editing or formatting FROM list with braced items is fixed (T40627,
T40681, T41047, T41084, T42422)
-
Error report during formatting ALTER VIEW statement is fixed (T40965, T54019)
-
Error report during adding Entity Developer model to solution is fixed (T51727)
3.5.79 26-Jul-12
-
Support of Microsoft Visual Studio 2011 is added (T41145)
-
Error "Object reference not set to an instance of an object" is fixed (T41145)
-
Error report when opening SQL file from project is fixed (T41715, T41735, T41761,
T41769, T42118, T42192, T42225, T42327, T42427, T42437, T42713, T42921, T42934)
-
Issue with installation repair is fixed (R10948)
-
Error report when creating new project is fixed (T41719, T41779, T41792, T41809,
T41861, T41876, T41877, T41882, T41904, T41906, T41935, T41945, T41985, T41989,
T42011, T42012, T42053, T42057, T42079, T42080, T42081, T42110, T42116, T42137,
T42166, T42169, T42180, T42312, T42323, T42324, T42381, T42429 to T41719, T41779,
T41792, T41809, T41861, T41876, T41877, T41882, T41904, T41906, T41935, T41945,
T41985, T41989, T42011, T42012, T42053, T42057, T42079, T42080, T42081, T42110,
T42116, T42137, T42166, T42169, T42180, T42312, T42323, T42324, T42381)
-
Error report during describing database is fixed (T41963, T42212, T42260, T42436,
T42771, T42789, T42907)
-
Error report during re-executing query is fixed (T42006, T42410)
-
Error "Internal connection fatal error" is fixed (T42121, T42250, T42310, T42333,
T42342, T42353, T42358, T42466, T42626, T42637, T42684, T42695, T42738, T42741,
T42914, T42916, T42922)
-
User's snippet is added (T42130)
-
Error report during saving SQL file to the project is fixed (T42564)
-
Problem when using connections with large databases is fixed (T11398)
3.5.72 22-June-12
-
Added integration into Visual Studio 2012
-
Error Report on performing the Execute Current Statement command is fixed (R8645)
-
Bug on using the $DB$ literal in the snippet is fixed (R10125)
-
NullReferenceException on code comparing (T38224)
-
Warning on incorrect credentials entering or expired subscription is added in the
Product Update Manager (T40454)
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)
-
Issue with valid script formatting is fixed (T39487)
-
Right Margin formatting option limitation is changed to maximum possible (R9127)
-
Issue 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,
T38770)
-
Error report on *.sql file opening in VS2010 is fixed (T38240)
-
Issue with incorrect formatting within the BEGIN...END block is fixed (T38397)
-
Issue with formatting comments is fixed (R8395)
-
Issue with smart tag expanding for linked server is fixed (R8090)
-
Issue with formatting DDL statement without delimiter is fixed (R7708)
-
Issue with smart tag appearance after fully typed identifier is fixed (R7473)
-
Issue with saving snippets after uninstalling the express edition is fixed (R7753)
3.5.56 14-Mar-12
-
Issue 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, T36822, T36872, T36908,
T36912)
-
Error report on starting add-in is fixed (T36817)
-
Error report on using Member List is fixed (T36664)
-
Wrong formatting of words case is fixed (R7272)
-
Issue with columns suggestion is fixed (T35219, T36706, T36785)
-
Issue 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)
-
Issue 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 Issue with Productivity Power Tools VS2010 extension is fixed (T31296)
3.0.16 28-Jul-11
-
Issue 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
-
Issue 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)
-
Issue 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
This 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
-
Issue 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)
-
Issue 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)
-
Issue 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
-
Issue with formatting comments in BEGIN...END block is fixed (S11701569, S11701599)
-
Issue with freezing on a large number of UNION in subqueries is fixed (T26826)
-
Issue 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 committed
(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 statements
-
Performance improvements
1.00.62 24-Dec-10
-
Fixed error at startup (T25048)
-
Parsing performance 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 performance 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
© 2026 Devart. All Rights Reserved.