Smart autocompletion for SQL Server

dbForge SQL Complete add-in for SQL Server Management Studio now available from ComponentSource.
Janvier 31, 2011
Communiqué de presse

dbForge SQL Complete is an add-in for SQL Server Management Studio 2000, 2005 and 2008 that offers powerful auto completion. It filters the suggestion list based on various criteria: first typed symbols, whitespace and/or square brackets. When you type the names of user-defined and/or built-in functions and procedures, dbForge SQL Complete will display their parameter information in a hint. This allows you to get the necessary information promptly without browsing external documentation. Besides extending List Members, Complete Word and Parameter Info, dbForge SQL Complete also includes a SQL Formatter which automatically formats your T-SQL code and speeds up query writing.

Features

  • Context-based code completion
    dbForge SQL Complete thoroughly defines context to predict what you want to type next. The intellisense only prompts relative keywords and names of database objects. Just type several symbols and see the required word in the suggestion list. Press Enter and continue with your query.
  • Parameter Info
    When you type names of user-defined and built-in functions and procedures, dbForge SQL Complete will display their parameter information in a hint. Get the necessary information promptly without browsing external documentation.
  • Customizable SQL formatting
    Produce clear and well-formatted code without worrying about indents, whitespace, wrapping, line breaks, etc. Just keep typing your SQL and see it automatically transformed based on your preferences and formatting rules. With a wide selection of formatting options you can set any formatting style you need.
  • SQL Complete vs Microsoft native IntelliSense®
    dbForge SQL Complete provides intellisense for SQL Server 2000, 2005, 2008, regardless of SSMS versions. Native intellisense does not work with those SQL Server versions that differ from your SMSS version. For example, SQL Server Management Studio 2008 will work only with SQL Server 2008.
  • Smart filtering to suggest relative keywords and objects
    dbForge SQL Complete filters the suggestion list based on various criteria: first typed symbols, whitespace, camel case or a square bracket. You can be sure, whatever you type, suggestions will be just what you wanted.
  • Context-based sorting of suggestions in the list
    dbForge SQL Complete saves you time by sorting names of database objects by type, and displaying most relevant suggestions in the top of the list; others are moved to the bottom.
  • Determining a current database or schema
    dbForge SQL Complete displays a list of database objects from the current database or schema even if their names are not specified in a query. The names of the current database or schema are determined based on connection properties of the current SQL document. Besides, SQL Complete finds USE statements in the code and changes the current database for subsequent SQL statements.
  • Expanding a list of columns
    You can replace the * asterisk symbol with the list of columns from the required table or view on pressing the Tab key.
  • Suggesting conditions for JOIN statements
    SQL Complete can suggest a full statement based on foreign keys, or it can prompt conditions based on column names.
  • Automatic alias generation
    dbForge SQL Complete automatically generates an alias for each table object (table, view, stored procedure, function, synonym) in the FROM list of your SQL document.
  • Semi-transparent view of the suggestion box
    When your code is overlapped by the suggestion box, do not close the suggestion box. Hold Ctrl to make the suggestion box switch to a semi-transparent view.
  • Suggestions of T-SQL statements in procedures and functions
    dbForge SQL Complete supports: DECLARE statements for local variables, cursor variables, and table definitions; cursors (declared with the help of DECLARE CURSOR statements) in OPEN, CLOSE, DEALLOCATE statements; context for such control-of-flow as BEGIN...END, GOTO, IF...ELSE, RETURN, BREAK, CONTINUE, WHILE, WAITFOR, TRY...CATCH, CASE, RAISERROR.

About Devart

Devart (formerly Core Lab) is a leading company working in the database connectivity area. We offer well-known native VCL/CLX components and dbExpress drivers for direct access to Oracle, MS SQL Server and MySQL. Provide advanced data access solutions for the Microsoft .NET Framework - ADO.NET data providers for native connectivity to Oracle, MySQL, and PostgreSQL database servers. Core Lab is also a vendor of powerful database tools designed to automate and simplify database development process.

Viewing suggested autocompletion terms with dbForge SQL Complete.

Vous avez une question ?

Discutez en direct avec l'un de nos spécialiste des licences Devart .