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 Denali, 2008 R2, 2008, 2005, and 2000
  10. Visual Studio integration

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 code auto-complete

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

Browsable auto-complete pick list

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

Auto-complete object details

Object description

Unused parameters and variables highlighting

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

Unused parameters and variables highlighting

Syntax error highlighting

Automatically identify and highlight any syntax error within the code

Syntax error highlighting

Identifier bracketing

Quickly locate identifiers automatically enclosing them in brackets

Identifier bracketing

Auto-replacements

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

Auto-replacements

Snippets

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

Snippets

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

Visual Studio integration

Including Visual Studio 2010, 2008 and 2005

About ApexSQL Complete

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

June 1, 2011