ApexSQL Complete release notes

Release: 2012.02.0009
Date: December 18, 2012
Description: Major feature, major fix release

Enhancements:

  • The "Quick cache refresh" command keeps the in-memory cache synchronized with the database catalog data
  • The "Code structure viewer" side pane creates an outline of SQL scripts thus allowing quick navigation through large SQL scripts
  • The "Tooltips for identifiers" tooltip provides detailed descriptions for database identifiers
  • The add-in supports reusing SQL code fragments by creating snippets and inserting context-specific values as needed
  • The "Closing characters auto insertion" feature automatically generates and inserts a closing tag after typing the opening tag for: single quotes, double quotes, parenthesis, comments and square brackets
  • Automatically inserted code formatting now uses automatic bracketing for SQL identifiers
  • BEGIN/END pairs and parentheses are now highlighted
  • The add-in now integrates with Visual Studio 2012
  • Reduced the memory usage when using syntax highlighting by up to 50%
  • Reduced the overall memory usage when the add-in is installed by up to 2,000%
  • Lowered the processor load for the multi-tabbed syntax highlighting by up to 55%

Fixes:

  • The "Check syntax" feature does not report a nonexistent column when creating a compressed index
  • Selecting a SQL table from the auto-complete hint list for INSERT INTO and UPDATE statements will also insert the names of the corresponding SQL columns
  • The add-in doesn't integrate into Visual Studio 2005
  • Almost all log file information is inserted into the ApexSQL Version log file when both applications are installed
  • The "Check syntax" feature reports the invalid "Incorrect syntax error near the 'ORDER' keyword" error when a FOR XML construction is used as a part of an ORDER BY clause in a SELECT statement
  • The "Check syntax" feature reports the invalid error "The multi-part identifier "c" could not be bound" when the "Table Value Constructor" construction is used
  • The "No active script window is available" message is displayed when starting the syntax highlighter in Visual Studio 2010
  • If two versions coexists on the single system, the new major version of the add-in stores its information in the same log file that was created by the previous add-in version
  • Visual Studio 2010 becomes unresponsive when copying from/pasting into a script larger than 100MB
  • The "Check syntax" feature reports invalid errors for column names of inserted or deleted SQL tables in the CREATE TRIGGER statement
  • The "About ApexSQL Complete" dialog always displays the "About ApexSQL Version" dialog, once the "About ApexSQL Version" dialog has been opened
  • The "System.ArgumentException" error is encountered when opening the error message generated after a Visual Studio 2010 project publishing has failed
  • The "Check syntax" feature reports the invalid error "The IDENT_CURRENT function requires 0 argument(s)" when using the IDENT_CURRENT data type function in a SELECT statement
  • The "Attempt to read or write protected memory" error is encountered when starting the SQL Server Management Studio feature "New Database Diagram"
  • The "Check syntax" feature reports invalid errors as it tries to analyze the IF condition in a SQL script
  • SQL table columns are missing from the hint list when using the ALTER TABLE statement with a NOCHECK clause and ADD CONSTRAINT
  • The auto-complete hints list, where all databases are shown, is displayed after the SET clause of an ALTER DATABASE statement
  • The "SSMS - SQL Server Management Studio has stopped working" error is encountered when double-clicking any column header divider in the Error list
  • Typing "." anywhere in the grid of the Aliases options tab, will unnecessarily open an auto-complete hints list
  • When deleting SQL lines from a query containing over a thousand errors, SQL Server Management Studio can become unresponsive for over 7 minutes
  • The "SSMS - SQL Server Management Studio has stopped working" error is encountered when enabling/disabling the "Auto-complete" and "Error list" options with more than one active query tab
  • The "SSMS - SQL Server Management Studio has stopped working" error is encountered when opening two empty query tabs while working in one of the three already populated ones
  • The add-in doesn't show information about objects included in scripts when hovering over the object name
  • The "Check syntax" feature reports the existing SQL triggers as nonexistent
  • Scripting of the "Full-Text Stoplist" using the "CREATE To" command is about 15000% slower if the add-in is installed in SQL Server Management Studio 2012
  • Auto-complete opens the hints list when typing the IP address in the SQL Server Management Studio "Connect to Server" dialog window
  • Initiating and using the incremental search in a query editor via the keyboard shortcut does not work with the "Auto-complete" option enabled
  • The "Check syntax" feature reports invalid errors for the CREATE PROCEDURE statements with output parameters in a valid SQL code
  • The "Check syntax" feature reports invalid errors for INSERT statements in a valid stored procedure creation code
  • The "Check syntax" feature reports the invalid error "Invalid object name" if CTE constructions are used in a JOIN statement
  • The "Check syntax" feature reports invalid errors related to object exposed names when multiple CTE constructions are used in the same SELECT statement
  • The "Check syntax" feature reports valid SQL view columns as invalid when they are used as system function parameters inside a CTE construction
  • The "Check syntax" feature reports the "Correlation name is specified multiple times in the FROM clause" error for a table alias when it is used with a JOIN clause/statement
  • The "Check syntax" feature reports the invalid error "The object doesn't exists" when DROP <object type> is used within a condition
  • The "Check syntax" feature doesn't recognize the CURRENT_TIMESTAMP SQL Server system function
  • The "Check syntax" feature doesn't report an error when the wrong argument is used in a TOP statement
  • The "SSMS - SQL Server Management Studio has stopped working" error is encountered when enabling "Auto-complete" after loading multiple 5-50MB queries or when opening more than four 5MB scripts with "Auto-complete" enabled
  • The "Check syntax" feature reports invalid errors when a non-declared variable is used in a script
  • The "Auto-complete" feature ignores the declared SQL table variable columns after the first closed bracket
  • If special SQL trigger tables (INSERTED, DELETED) have aliases in a FROM clause, their utilization in a SELECT statement will not be recognized by the "Check syntax" feature
  • If special SQL trigger tables (INSERTED, DELETED) are used in a SELECT statement but are not specified in a FROM clause, the "Check syntax" feature should report an error, since the "delete" alias is not declared in the FROM statement
  • The "Auto-complete" feature does not display columns when the "Table Value Constructor" is used
  • The highlighted error disappears when a change is made in a different GO block of the current script
  • A system procedure is not recognized if it is a part of a "dbo" schema
  • The "Check syntax" feature does not report an error for the nonexistent column used in the script when creating a compressed index
  • An incorrect qualification is added to temporary SQL table columns when objects are created in a script
  • The "Check syntax" feature reports that the SQL search property list doesn't exist when used in a DROP statement
  • The "Check syntax" feature cannot recognize columns if an existing synonym is used in the SQL code
  • If a COLUMNSTORE INDEX exists in the database when an ALTER/DROP INDEX is used, the add-in gets disabled until an application restart
  • The "Qualify object name" feature adds the name of a nonexistent variable to the column
  • The "Auto-complete" feature formats object names as keywords when objects are created in a script9325 - The "Check syntax" feature reports the "The multi-part identifier ‘[.]' could not be bound" error in a valid SQL code
  • The "Check syntax" feature ignores the procedure parameters
  • The "Check syntax" feature reports invalid errors for SQL table variable columns
  • The "Auto-complete" feature does not display SQL table variable columns in the hints list
  • The "Auto-complete" feature does not display static methods of CLR data types in the hints list
  • The add-in doesn't show information about functions included in scripts when hovering over the function name
  • Column names are not embraced with brackets when expanding wildcards when needed while using "Auto-complete"
  • The add-in prevents connecting of ApexSQL Version to Vault 5.x servers via MSSCCI
  • Scrolling in SQL Objects script dialog window created from auto-complete drop-down menu, scrolls the main script in a query tab
  • The "SQL Server Management Studio has stopped working" error is encountered when changing the script if the check syntax processing is in progress
  • The "A problem caused this program to stop interacting with Windows" SQL Server Management Studio error is encountered when more than 100 errors are present in Error list
  • The "A problem caused this program to stop interacting with Windows" SQL Server Management Studio error is encountered when entering the object name with over 25 characters in the script
Release: 2012.01.0006
Date: June 06, 2012
Description: Initial release

Enhancements:

  • Auto-complete hints lists are now shown for more SQL constructs and contain more relevant hints
    • Logins are now displayed in hints list when triggered after DROP LOGIN or ALTER LOGIN statements
    • Users are now displayed in hints list when triggered after ALTER USER statement
    • Methods of CLR data type variables are now displayed in hints list when triggered in a SELECT statement
    • Columns of table variables are now displayed in hints list when triggered in a SELECT statement
    • INDEX keyword is now displayed in hints list when triggered after CREATE COLUMNSTORE statement
    • COLUMNSTORE keyword is now displayed in hints list when triggered after CREATE NONCLUSTERED statement
    • COUNT system function is now displayed in hints list when triggered after HAVING clause in a SELECT statement
    • Script labels are now displayed in hints list when triggered after GOTO statement
    • Geometry, Geography, Xml and HierarchyId methods are now displayed in hints list when triggered after corresponding column or variable type
    • EVENT NOTIFICATION, COLUMNSTORE INDEX, NONCLUSTERED COLUMNSTORE INDEX, NONCLUSTERED INDEX, CLUSTERED INDEX and XML INDEX composite keywords are now displayed in hints list when triggered after CREATE or ALTER statements
    • Table columns are now filtered in the hints list while typing their name
  • Error list panel has been improved to find more errors in the code and report them more precisely
    • Error is now reported when directly using an aggregate function in a WHERE clause of a SELECT statement
    • Inexistent object errors are now reported when incorrect object names are specified after AS OBJECT or AS TYPE clause in EXECUTE WITH RESULT
    • SETS statement
  • Auto-complete hints list server metadata loading speed has been improved by up to 2700%
  • Auto-complete hints list appearing time has been improved by up to 30% when first used in a session
  • Auto-complete hints list appearing time has been improved by up to 50% in subsequent calls

Fixes:

  • 'The ORDER BY items must appear in the select list if the SQL statement contains a UNION, INTERSECT or EXCEPT operators' error is reported in Error list panel for statements without UNION, INTERSECT and EXCEPT operators
  • Auto-complete hints list doesn't appear automatically following space trigger in MERGE and USING statements
  • Error is reported in Error list panel for SELECT DISTINCT statement ORDER BY clause if columns are specified by their ordinal positions
  • Invalid object and column names errors are reported in Error list panel for SELECT statement when INNER JOIN clause specifies Tables from a different database than the current one in context
  • 'Value cannot be null' error is encountered when Ctrl+C is pressed in an empty Error list panel
  • Add-in opens ApexSQL Profile online help whenever help is invoked if ApexSQL Profile is also installed side-by-side and was used first in the SQL Server Management Studio session
  • Semantic errors are not displayed in Error list panel for code blocks containing both syntax and semantic errors
  • Add-in is not available in SQL Server Management Studio 2012 after applying KB2645410 system update
  • Error isn't reported in Error list panel for ORDER BY clause of SELECT statement if the same column is specified both by its name and its ordinal position
  • Support Forum menu command opens general instead of add-in specific support forum page
  • SQL Server Management Studio Query editor doesn't fill out all available parent window space after it is maximized
  • Auto-complete Options | General | Format Keywords setting doesn't affect manually typed DECLARE and SELECT statements
  • Encrypted object DDL script is not displayed in auto-complete tooltip when working with SQL Server 2012 database
  • Auto-complete hints list doesn't contain newly created Table objects after using Object Explorer Refresh context menu command
  • SQL Server Management Studio error is encountered when using space trigger to invoke auto-complete hints list in between CREATE PROCEDURE <Procedure name> AS statement and unfinished Procedure body also containing AS keyword
  • Error isn't reported in Error list panel for ORDER BY clause of SELECT statement when Geography or Geometry type columns are specified
  • Inexistent object error is reported for a Table specified in SELECT statement FROM clause if the Table was created in the same SQL Server Management Studio session in a different query window
  • Auto-complete hints list containing join candidates is displayed after JOIN ON clause when Show Join Candidates setting is OFF
  • Object DDL script tooltip isn't displayed after selecting the first hint in auto-complete hints list
  • Excess brackets are added to the script when using parenthesis key to select a Function in auto-complete hints list
Release: 2012.01.0002
Date: March 01, 2012
Description: Beta release

Enhancements:

  • Prompt message is now issued when deleting an alias on Aliases tab in Complete Options dialog
  • Errors list contents can now be copied to clipboard

Fixes:

  • Error description isn't shown on mouse over in SQL Server 2008 R2 Management Studio query editor
  • XML Schema Collections are missing from auto-complete hints list shown after DROP XML SCHEMA COLLECTION statement
  • No error is reported for non-existing database specified in USE <database> statement
  • Option tooltips shown in Complete Options dialog close too quickly
  • Add-in integrates improperly with SQL Server 2008 SP0 Management Studio
  • Errors in UPDATE statements aren't removed from errors list after correction in some cases
  • Object Count column of schema cache grid shown on Schema Cache tab in Complete Options dialog isn't refreshed while the dialog is open
  • "Object reference and Alias should not be empty" error message is shown after deleting an alias
  • No error is reported for mistyped system variables inside SELECT statement
  • Complete Options dialog size and position are not remembered within a session
  • Local *.CHM help file is not used when available
  • Object errors aren't removed from errors list after the respective object has been deleted with DROP statement
  • Incorrect About dialog may be shown if the add-in is installed together with Refactor 2011.01 or Version 2011.01 alpha add-ins depending on the invocation order
  • DATE data type is missing from auto-complete hints list shown after parameter name in Stored Procedure or Function header
  • INFORMATION_SCHEMA schema is completely missing from auto-complete hints lists
  • Columns are inserted prefixed with schema and object name into INSERT statement in case * (all columns) is selected in auto-complete hints list
  • Invalid errors are reported when equally named columns from different Tables are specified in ORDER BY clause at the same time
  • Invalid "Incorrect column or user-defined aggregate function" errors may be reported for script-based objects in some cases
  • Typing 2 successive dots after an alias in System Function call inside SELECT statement incorrectly opens auto-complete hints list
  • Variables are missing from auto-complete hints list shown for Function parameters
  • Errors aren't reported for SELECT statements inside ALTER VIEW
  • Invalid "Invalid column name" errors are reported for CONTAINSTABLE System Function
  • Typing 3 successive dots improperly opens auto-complete hints populated list with Scalar Functions
  • Exception is encountered when selecting no longer existing object in auto-complete hints list
  • No error is reported if statement preceding Common Table Expression isn't terminated with a semicolon
  • Auto-complete hints list shown after removal of the system variable prefix (@@) is incomplete
  • Duplicate error is reported for an attempt to use non-existing Stored Procedure in INSERT statement
  • Table and Trigger from DISABLE TRIGGER statement are reported as non-existing
  • Auto-complete hints list isn't shown after @ typed after copy-pasted SELECT keyword followed by a space
  • Invalid error is reported for CREATE CERTIFICATE statement
  • Invalid error is reported for RETURN keyword inside Stored Procedure
  • Selecting a column in auto-complete hints list shown after schema and object name in SELECT statement adds the object to FROM clause regardless of whether it's already specified there
  • Invalid error is reported for CREATE statement followed by DROP issued for the same object
  • Auto-complete hints list isn't shown after MERGE and USING keywords
  • Invalid error is reported for WITH .. AS statement
  • Auto-complete hints list isn't shown after GOTO keyword
  • No prompt message is issued when removing an alias on Aliases tab in Complete Options dialog
  • Errors list contents can't be copied to clipboard

Changes:

  • 'Auto-complete enabled' setting has been renamed to ‘Enable/Disable auto-complete'
Release: 2011.01.0001
Date: January 12, 2012
Description: Alpha release

Enhancements:

  • Automatically inserts SQL keywords, database, schema, object, parameter and variable names
  • Auto-completes SQL code fragments such as JOIN statements and cross-database queries
  • Provides a browsable visual hints list while typing
  • Displays hinted object definition and description automatically
  • Automatically generates aliases for inserted objects
  • Automatically identifies and highlights errors
  • Allows quick navigation to all detected errors
  • Supports Microsoft SQL Server 2012, 2008 R2, 2008 and 2005

Known issues:

  • Incomplete add-in menu in Microsoft SQL Server Management Studio 2008
  • Detected error remains in Error List pane even if it is corrected in the code