Key Features
Code Completion
Code completion in SQL Complete predicts not only keywords and object names,
but also whole code fragments to simplify and accelerate your work. Intelligent
suggestions with smart filtering make the code typing process really smooth
and fast.
View Screenshot
SQL Formatter
SQL code can be automatically formatted using SQL Complete. The formatter can work
either with available code or the code that is being typed. You don't need to pay
that much attention to case, line breaks, whitespaces, indenting,
wrapping, etc - the application will take care of them all for you.
View screenshot
Statement expansion
INSERT, ALTER, and EXEC statements will be expanded to the
full code template on pressing the Tab key to avoid tedious typing.
Except the template, the type of column data will be generated in the comments.
View feature in action
SQL Snippets
For frequent repetitive usage of code fragments, SQL snippets feature can be used.
The application shows available code templates in the dropdown prompt list,
and any of them can be inserted into the code you are typing on pressing Tab. In
Snippets Manager, predefined templates can be modified and new ones can be added.
View feature in action
Quick object information
The application gives you essential information on database objects while
you are writing code. Get such information for tables, procedures, and other objects.
Parameter information prompts you with stored procedure and function parameters
when writing call statements and relieves your memory.
Quick info screenshot | Param info screenshot
Code Navigation
With the Go to definition option, you can locate the needed object in the
Object Explorer tree in a moment.
Document outline window, in its turn, allows navigating through large SQL
documents. The window shows the structure of the current SQL document which can
be easily synchronized with the code both ways.
View feature in action | View screenshot
SQL Complete Express - free SQL IntelliSense add-in for SSMS
You can use SQL Complete Express as a free add-in for SQL Server Management Studio.
This edition of our SQL code completion tool provides basic functionality for autocompleting
and formatting code for free.
It may be reasonable to use SQL Complete, if you:
- Newbie in development
- Enthusiast that works with non-commercial projects
- Could not prove the necessity of spending extra amount of money from the company
budget to buy the full edition
What functionality does the free edition of this SQL code completion tool provide?
- Code completion for SELECT, INSERT, UPDATE, EXEC, and DELETE statements
- Basic SQL formatting functionality
- Smart filtering in the suggestion list
- Parameter information for procedures and functions
In spite of the limitations of the Express edition of our SQL autocomplete add-in,
we keep an eye on the fact that it should provide more extended IntelliSense capabilities
than the standard functionality.
Just thought I'd let you know that you've all done an awesome job fixing that issue
- thank you all so very much. No more crashes and I have to say that I'm extremely
impressed with your response times, issue resolution times and customer service
- all excellent!
Well done and thank you all so much!!!
Tony Hales, Software Developer, DeMontfort Fine Art Ltd