Follow on Google News News By Tag * Sql Intellisense * More Tags... Industry News News By Location Country(s) Industry News
Follow on Google News | New SQL Complete Brings Excellent Intellisense for SQL Server Management StudioExtended version comes with rich autocomplete features, and keeps free intellisense for all SQL Server people.
By: Devart dbForge SQL Complete 2.0 will bring SQL Server database developers and DBAs around the world new speed in writing SQL statements to increase efficiency and code quality. dbForge SQL Complete 2.0 Technical Advancements Close collaboration with SQL Server database developers and DBAs resulted in the following new features: - Working with large scripts dbForge SQL Complete 2.0 provides sql code completion and formatting in scripts of any size. The first version supported the script size up to 150 000 symbols. - Expanding a list of columns Users can replace the * asterisk symbol with the list of columns from the required table or view on pressing the Tab key. -Suggesting methods for columns and variables dbForge SQL Complete suggests methods for columns and variables of varchar(max) - Extended support for statements dbForge SQL Complete fully supports such statements as CREATE (for table, view, procedure, and function), EXEC, PRINT, and TRUNCATE TABLE. When TRUNCATE TABLE statement is used in a query, the tool suggests a list of databases, schemas, and tables. - Suggesting conditions for JOIN statements dbForge SQL Complete can suggest a full statement based on foreign keys, or it can prompt conditions based on column names. - Automatic alias generation The tool can generate an alias for each table object (table, view, stored procedure, function, synonym) in the FROM list of SQL document automatically. - Inserting column names with prefixes dbForge SQL Complete can insert column names with the name of table, schema, and database it belongs to. - Sorting keywords by relevance Keywords are sorted by relevance in the suggestion list. - Expanded support for Transact-SQL statements SQL Complete supports: DECLARE statements for local variables, cursor variables, and table definitions; - Suggesting collations, data types, XML schema collections, and languages dbForge SQL Complete can suggest collations, XML schema collections, languages and data types when writing SQL statements. For example, when creating columns in a table, dbForge SQL Complete will suggest possible data types for it, including user-defined types. Pricing and Availability dbForge SQL Complete now comes in two editions to better cater for the needs of SQL database developers and DBAs. They can select a free Express edition to get free intellisense, or the Standard edition, which is available for a price of $49.95, to have surpassing sql code completion and formatting. DbForge SQL Complete Express and free trial version of standard edition of dbForge SQL Complete are available for immediate download at http://www.devart.com/ Users are welcome to write any comments and suggestions about dbForge SQL Complete on its support page — http://www.devart.com/ # # # About Devart Devart is a software development company with 11 years of experience on the software market and over 20 thousands of devoted users. We specialize in providing comprehensive development and management tools as well as native connectivity solutions for the most popular databases, including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite. For additional information about Devart, visit www.devart.com/ End
Account Email Address Account Phone Number Disclaimer Report Abuse
|
|