Main > Network & Internet > Database Utils >

dbForge SQL Complete Express 2.50.92



 

dbForge SQL Complete Express 2.50.92

Sponsored Links

dbForge SQL Complete Express 2.50.92 Ranking & Summary

RankingClick at the star to rank
Ranking Level
User Review: 0 (0 times)
File size: 6.8 MB
Platform: Windows 2K / XP / Vista / Vista64 / 7
License: Freeware
Price: FREE
Downloads: 13
Date added: 2011-06-04
Publisher: Devart

dbForge SQL Complete Express 2.50.92 description

dbForge SQL Complete Express 2.50.92 is considered as a smart as well as professional add-in for SQL Server Management Studio 2000, 2005 and 2008. It offers powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense. Besides extending List Members, Complete Word and Parameter Info features, SQL Complete adds SQL Formatter to enrich the developer toolkit and provide the fastest T-SQL query typing ever possible.

Major Features:

  1. Context-based code completion
    • SQL Complete thoroughly defines the context to predict what you want to type next. It displays only relative keywords and names of database objects. Just type several symbols and see the required word in the suggestion list. It takes only to press Enter and go on with your query.
  2. Parameter info for functions
    • When you are typing names of user-defined and built-in functions and procedures, SQL Complete displays their parameter information in a hint.
  3. Customizable SQL formatting
    • Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, 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.
  4. Quick object info
    • To get essential information on a database object you don't have to look it up any more just hover the mouse cursor over the identifier, and it's here. For tables, the popup window with information will contain:
      • Column names with data types
      • Additional column properties (e.g., not null and identity attributes)
      • Primary, unique and foreign keys
      • User information from the extended properties.
    • For other objects it shows object type and user description if any.
  5. Smart filtering to suggest relative keywords and objects
    • SQL Complete filters the suggestion list based on various criteria:
      • First typed symbols,
      • A whitespace,
      • Camel case,
      • A square bracket.
    • You can be sure, whatever you type, the suggestions will be just what you wanted.
  6. Context-based sorting of suggestions in the list
    • SQL Complete saves you even a second 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.
  7. Determining a current database or schema
    • 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.
  8. 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.
  9. Expanding INSERT statements
    • You can expand INSERT statements to the full template on pressing the Tab key.
    • Except the template, the type of column data will be generated in the comments along with the NOT NULL and ROWGUID properties. For datetime, a template for inserting time will be created. Also DEFAULT clause is generated if a default value is created for a table.
  10. Suggesting conditions for JOIN statements
    • Get the fastest way of typing JOIN statements. SQL Complete can suggest a full statement based on foreign keys, or it can prompt conditions based on column names.
  11. Automatic alias generation
    • SQL Complete automatically generates an alias for each table object (table, view, stored procedure, function, synonym) in the FROM list of your SQL document.
  12. Suggestions of T-SQL statements in procedures and functions
    • 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.
  13. 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 semi-transparent view.
Enhancements:
  • Critical bug with showing Quick Info is fixed
  • Problem with checking updates is fixed (T29186)
Requirements:
  • Microsoft SQL Server Management Studio 2005 or 2008

dbForge SQL Complete Express 2.50.92 Screenshot

dbForge SQL Complete Express 2.50.92 Keywords

Bookmark dbForge SQL Complete Express 2.50.92

Hyperlink code:
Link for forum:

dbForge SQL Complete Express 2.50.92 Copyright

WareSeeker.com do not provide cracks, serial numbers etc for dbForge SQL Complete Express 2.50.92. Any sharing links from rapidshare.com, yousendit.com or megaupload.com are also prohibited.

Allok Video Splitter 2.2.0 Review:

Name (Required)
Email(Required)
Captcha
Featured Software

Want to place your software product here?
Please contact us for consideration.

Contact WareSeeker.com
Related Software
Express Edition is the ideal choice for small to medium sized organizations and individuals looking for an affordable time and attendance solution. Our Express Edition offers an ideal time management Free Download
Lex is an efficient language learning tool for working on authentic material on the web. With Lex you can easily look up words, listen to pronunciations, highlight words and make gap filling exercises Free Download
When you are typing in Microsoft Word, the program automatically completes the words considering the first letters entered. Free Download
Help Desk software designed to be operated via your web browser. Use it on the Internet, an Intranet or even run it locally on a stand-alone machine.Features:Operator and end-user access. Automatic es Free Download
Universal database tool with report builder. Viewing, editing, and printing data; building SQL queries; building reports; sorting and filtering; viewing and printing structure; searching and replacing Free Download
Crystal Clear Hire is a low cost rental software package designed for small to medium sized businesses within the hire industry. This hire software can be adapted for any rental business needs. Free Download
Recovery for SQL Server fixes corrupted MS SQL Server database files. It restores corrupted tables, views, stored procedures, triggers, indexes etc. Both standard and user-defined data types are recov Free Download
Patient Manager Express is a complete solution that contains comprehensive medical records implementation, contact management, scheduling and reporting functions. Free Download