280 results found
-
Refactor > Change JOIN Order
Would be quite useful to have an option to change the JOIN order of a statement. Say, right click on the statement > Refactor > Change JOIN Order
2 votes -
Increase indentation in WHERE with nested OR clauses
In the case where you have a nested (parenthesized) condition, increase the indention after the new line.
How it currently operates:
SELECT *
FROM MyTable
WHERE
(a=1
OR b=2
OR d=5)
AND c=3This doesn't really convey the fact that this is a subexpression, and it requires tracing the parenthesis with more complex queries. Something like this would be better:
SELECT *
FROM MyTable
WHERE
(a=1
OR d=5
OR b=2)
AND c=3So for each parenthesis level with a different logical operator than the previous level (to help prevent over-indenting when parenthesis are applied too liberally), increase the indention level…
35 votesPlease have a look at the latest build of SQL Complete.
-
Provide quick access to the object definition SQL
E.g. by implementing the command that opens object definition in the new document.
124 votes -
When autocompleting a column or table name, automatically put brackets around SQL keywords
When autocompleting a column or table name, if the name is a SQL keyword, automatically place the brackets around the name. For example, the query "SELECT Version FROM Table" is currently auto-corrected to "SELECT VERSION FROM TABLE", which causes an error.
Instead, it would be nice if SQL Complete auto-corrected to "SELECT [Version] FROM [Table]".
34 votes -
Formatting Presets
Everyone has their own preferences for formatting, which is why I think the number of options you provide for the formatting is really impressive. I think, however, that people likely tend to fall in to camps when it comes to their preferred formatting, so it might be helpful to determine the common configurations of the formatter, and then provide a handful of presets for the user to try out (with a preview of how various queries would be formatted). They could then go through and find whichever preset most closely matches their style, and then tweak it from there. Should…
1 vote -
INSERT statement formatting
We need extra control of the formatting of various statements, e.g INSERTs. We like to have our INSERT statements formatted like:
INSERT INTO dbo.Test
(
UserID
, Name
, IsDeleted
)
VALUES
(
0 -- UserID - INT NOT NULL
, '' -- Name - VARCHAR(32) NOT NULL
, DEFAULT -- IsDeleted - BIT NOT NULL
)but we can't even get it close
4 votes -
Select columns from columns list using keyboard shortcut
When typing a select statement, the columns list is nice but to select several fields quickly I have to use the mouse.
Ideally, I'd be able to use the keyboard, I'd scroll down the column list and then press some keyboard shortcut (alt+enter, alt+space) to quicky insert one field, hit down arrow, alt+enter the second field. All without using the mouse
7 votes -
xml Data Type methods
The xml Data Type methods (http://msdn.microsoft.com/en-us/library/ms190798.aspx) MUST be lower case. We have keywords set to be upper case, and that makes the xml Data Type methods upper case too, which does not work.
0 votes -
Options -> Settings -> Qualify column name -> **enclose with []
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 [].
28 votesIt’s implemented in the latest build of SQL Complete. Have a look at the “Enclose identifiers within square brackets” option.
-
Add 'Place open brace on new line' option for WITH clause
WITH Dates
AS (SELECT DISTINCT test
FROM test
)
SELECT *
FROM Dateswhere I am expecting it to look like this:
WITH Dates
AS (
SELECT DISTINCT test
FROM test
)
SELECT *
FROM Dates1 vote -
Shortcuts for common queries like SELECT * FROM
I saw another program that allowed shortcuts such as typing ssf generated query "SELECT * FROM"
I could create new shortcuts too. See this for details: http://www.ssmstoolspack.com/0 votes -
Function names in uppercase
While writing a function name in a query, sqlcomplete force the name to lowercase. In Turkish we have "I" letter and its lower char is "ı" not "i". I mean, when i want to write MIN() function, sqlcomplete replaces with "mın()" not "min()". If you allow function names to be uppercase it would be great. Thank you
2 votes -
Installer - Give option to ignore message about running applications
Everytime I upgrade, the installer forces me to exit Visual Studio. However, I only install SQL Complete for Management Studio. Please give me an option to ignore that error message
35 votes -
Add 'Place view definition on new line' option
Make it ignore the DDL part and just format the actual view definition
ALTER VIEW v_xyz AS
SELECT
.. some complex queryGO
1 vote -
After the 'LIKE'
To have an option to on-off and when it is on -
when the keyword 'LIKE' is typed or selected, put the 2 percentage signs sorrounded by single quotes and keep the cursor in between.
Ex:
Select * from t where FirstName Like '%%'5 votesYou can create a snippet wit the Snippets Manager filling in its fields as follows:
Shortcut: like
Description: LIKE ‘$CARET$’
Text: LIKE ‘$CARET$’
-
Highlight the BEGIN/END ?
Highlight the BEGIN/END ?
5 votes -
Declare indent
Allow option to not fancy indent declared variables, but just put a new line after declare, and have all variables just indented with a tab (normally).
1 vote -
Product Update Manager Improvements
It should offer to close SSMS, wait for the save dialog to exit and launch the update.
Or if that can't be done, it should at least launch explorer with the file highlighted after download.
6 votes -
13 votes
-
4 votes
- Don't see your idea?