DbForge SQL Complete
Encyclopedia
dbForge SQL Complete is an add-in for SQL Server Management Studio
2005, 2008, and 2011, and Visual Studio 2008 and 2010 created by Devart that offers autocompletion and formatting of T-SQL code. The main goal of the product is to enhance basic Microsoft IntelliSense
functionality.
Express is a free software, which provides basic SQL formatting and autocompletion functionality;
Standard includes much more features related to SQL formatting and autocompletion (including support of JOIN and SELECT statements, etc.). dbForge SQL Complete Standard Edition is a shareware
with free 30-day trial.
On 14 July 2011 SQL Complete 3.0 was released. In this release both Express and Standard editions were heavily updated.
dbForge SQL Complete release news, Devart
SQL Server Management Studio
SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions for configuring, managing, and administering all components within Microsoft SQL Server...
2005, 2008, and 2011, and Visual Studio 2008 and 2010 created by Devart that offers autocompletion and formatting of T-SQL code. The main goal of the product is to enhance basic Microsoft IntelliSense
IntelliSense
IntelliSense is Microsoft's implementation of autocompletion, best known for its use in the Microsoft Visual Studio integrated development environment...
functionality.
Editions (licenses)
dbForge SQL Complete has two editions: Express and Standard.Express is a free software, which provides basic SQL formatting and autocompletion functionality;
Standard includes much more features related to SQL formatting and autocompletion (including support of JOIN and SELECT statements, etc.). dbForge SQL Complete Standard Edition is a shareware
Shareware
The term shareware is a proprietary software that is provided to users without payment on a trial basis and is often limited by any combination of functionality, availability, or convenience. Shareware is often offered as a download from an Internet website or as a compact disc included with a...
with free 30-day trial.
History
The first version was released on 22 November 2010. It had only one, free, edition, which functionality was similar to Express Edition in version 2.0. The release of version 2.0 introduced a bunch of new features that are available in Standard Edition only.On 14 July 2011 SQL Complete 3.0 was released. In this release both Express and Standard editions were heavily updated.
dbForge SQL Complete release news, Devart
Functionality
Main features of dbForge SQL Complete, v3.0 (Standard Edition) include:- SQL Server support: support of SQL ServerMicrosoft SQL ServerMicrosoft SQL Server is a relational database server, developed by Microsoft: It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network...
2000, 2005, 2008, 2011 and SQL Azure, SQL Server Compact Edition; - Visual Studio support: support of Microsoft Visual StudioMicrosoft Visual StudioMicrosoft Visual Studio is an integrated development environment from Microsoft. It is used to develop console and graphical user interface applications along with Windows Forms applications, web sites, web applications, and web services in both native code together with managed code for all...
2008 (Professional and Team System editions), 2010 (Professional, Premium, Ultimate editions) - List members for major objects: database, schema, table, view, procedure, user and table-valued function (including CLR), built-in function;
- List members for advanced objects: synonym, CLR aggregate, collation, type, XML schema collection, language;
- Smart filtering in the suggestion list;
- Parameter information for user-defined and built-in procedures/functions;
- Customizable SQL formatting;
- Quick object information for tables, procedures, asterisk in the SELECT list, alias in the FROM list, columns, dropdown list items;
- Context-sensitive suggestion of keywords;
- Sorting suggested keywords by relevance;
- Determining a database context;
- Word autocomplete;
- Asterisk expansion (in SELECT statements);
- Expanding INSERT, ALTER, and EXEC statements;
- Suggesting JOIN expressions and conditions;
- "Go to definition" for database objects;
- Code snippets for recurrent using of code fragments;
- Document Outline window;
- Highlight occurrences of an identifier;
- Execute current statement;
- Qualifying a column name on completion (in SELECT statements);
- Auto-generation of table aliases (in SELECT statements);
- Context-sensitive suggestions of DML statements: INSERT, UPDATE and DELETE;
- Context-sensitive suggestions of T-SQL statements in procedures and functions;
- Context-sensitive suggestions of CREATE TABLE, CREATE VIEW, EXEC, PRINT, TRUNCATE;
- Manual refreshing of the suggestion list;