When formatting a statement:

SELECT sometable.fieldname AS something FROM sometable

SQL Complete KNOWS the proper case of the table and field names (as it allows you to autocomplete them as you're typing it in). So, why doesn't it alter the case of them once they're already in the statement?

If the table was actually SomeTable in the database, and the field was called FieldName, the "format" function should fix the statement like so:

SELECT SomeTable.Fieldname AS something FROM SomeTable

when typing a query have the table alias inserted before the column automatically. For example, in the query below, the t. will automatically get inserted before the column names after the table with an alias is entered.

Select t.column1, 1.column2
from tablename t
where t.column1 = @value

Resharper, a popular addon for visual studio has a nifty feature where you can hit ctrl+t to open a compact search window where you can type part of a type name, and a list of clickable suggestions is presented as you type.

http://www.jetbrains.com/resharper/features/navigation_search.html#Go_to_Type

It would be quite handy to have something similar for Management Studio.
Clicking any of the matches could open a new query window with an ALTER statement prepared.

When autocompleting a parameter less function like say: getdate, include also the braces () and put the caret after the closing brace so you can continue typing without having to type the braces youself

When autocompleting a function with parameters, also automatically put the braces, but place the caret in between the braces (<caret here>) so you can directly start typing the parameter.

Auto-complete always enters an ON clause as:

SELECT * FROM Table1
INNER JOIN Table2 ON Table2.Value = Table1.Value

This is really annoying to me. I would like an option to reverse the ON clause so it completes like this.

SELECT * FROM Table1
INNER JOIN Table2 ON Table1.Value = Table2.Value

Option to place table name after JOIN on a new line

...
FROM
TABLE_A
INNER JOIN
TABLE_B
ON .......

Have the ability to right-click or hover over an alias and be able to choose "Rename". By renaming the alias in one place it would automatically rename all other references to the alias in the query.

For example: I create a table and it get aliased as r1. I then rename it to rnk, which would change the loin reference to rnk right away.

To differentiate the 'Keyword case' formatting setting for keyword commands like SELECT, FROM, LIKE and WHERE and data types like int, varchar and money.

It would be very nice to have options for separate formatting for subquery, for example:

SELECT
OrderID,
OrderName,
OrderDate
FROM Orders
WHERE ClientID = (SELECT ClientID FROM Clients WHERE ClientCode = 'ABC')

Here, I need the main SELECT to be stacked and formatted appropriately, and subquery SELECT - to be wrapped and in one line).

In large and complex SQL script this feature is invaluable.

Currently it is not possible - one format is applied for everything.

Thanks.

Space after comma is great, but please add an option for "except when comma is first on a row" (eg. stacked lines).

It would be a nice feature if you can add to database, schema and table brackets []. If you use certain characters like $ you have to enclose it with [].

In an office environment, it may be useful to use the same formatting file across multiple machines. This will be used on a read-only basis (but could be created by exporting it, so the manager can create or update the file).
Using a shared file rather than exporting and emailing the file to be imported would mean that changes made by the manager would be instantly reflected for all users in the dept.

Guys,
Synchronize SQL Complete "Refresh Suggestions" command with built-in "Refresh Local Cache".

Overwise, It's always needed to click both of these commands (first refreshes intellisense, sencond refreshes error highlighing)

Automatically alias a second reference to a table even if "generate alias on commit" is not enabled

I'll be very glad if I could select a partial script in smart way and then run it with CTRL + SHIFT + E shortcut. The separator should be 2 blank lines, one at the top and one at the bottom of the script, and yes, I'm a shortcut addict. thanks a lot guys!