Automatic SQL completion and other productivity enhancing features available as SSMS or VS add-in – Sneak Peek – ApexSQL Complete 2011

ApexSQL, a Microsoft Gold Certified Partner and leading provider of Microsoft SQL Server solutions is proud to announce

ApexSQL Complete 2011. This brand new add-in seamlessly integrates with SQL Server Management Studio and Visual Studio and, among other features, includes enhanced auto-completion, visual identification of unused parameters and variables, auto-replacements, templates and many more productivity boosters.

Here’s a preview of what’s coming in this new release:

  1. SQL code auto-complete
  2. Browsable auto-complete pick list
  3. Auto-complete object details
  4. Unused parameters and variables highlighting
  5. Syntax error highlighting
  6. Identifier bracketing
  7. Auto-replacements
  8. Snippets
  9. Support for SQL Server 2012, 2008 R2, 2008, 2005, and 2000

Let’s take a quick look at these new features:

SQL code auto-complete
Auto-complete will allow you to automatically fill in SQL keywords, database, schema, object, parameter and variable names

sql autocomplete

Browsable auto-complete pick list
The browsable pick list will enable you to complete entire SQL fragments, such as JOIN statements or cross-database queries, in a single click

sql fragments

Auto-complete object details
No more need to backtrack to check the object’s definition or description – auto-complete will instantly provide you with both

object’s definition or description

Unused parameters and variables highlighting
Clean up your code by identifying and removing parameters and variables that aren’t used

removin parameters

Syntax error highlighting
Automatically identify and highlight any syntax error within the code

syntax error

Identifier bracketing
Quickly locate identifiers automatically enclosing them in brackets


Define cues which will be replaced with entire formatted SQL code fragments automatically

sql code fragments

Jump-start code writing with the built-in snippet library covering the most popular SQL constructs. Save the syntax of various SQL statements as snippets to reuse them at a later time.

sql statement

Support for SQL Server 2012, 2008 R2, 2008, 2005, and 2000
Full support for SQL Server 2012, 2008 R2, 2008, 2005, and 2000 data types and enhancements

About ApexSQL Complete
ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in which speeds up coding, completes SQL code statements automatically, inserts code blocks, identifies unused parameters and variables and much more

September 21, 2011