309 results found
-
Add option to include (NOLOCK) when auto-completing
Due to the nature of our data, we use NOLOCK on most of our queries. It would be useful for us to be able to automatically have (NOLOCK) included when part of a statement is auto-completed. It may be useful to have it so that this option can be turned on only in specific databases.
63 votes -
"Folding" queries
It would be interesting to be able to "fold" and "unfold" a query from a single line state (still showing the full query) to a multiline, formatted state.
The following query, for example,
| |
|+| SELECT * FROM SomeTable WHERE SomeField = 3.14;
| |would unfold to
| |
|- | SELECT
| | *
| | FROM
| | SomeTable
| | WHERE
| | SomeValue = 3.14;
| |and back.
28 votes -
Option to add a space after table alias.
To prevent a snippet from getting inserted when the alias is the same as a snippet. Many times I will start a query and an alias is the same as the snippet. When i hit tab or enter that snippet in inserted in place of the alias. This is especially true when you have SSMS Tools installed and many of the snippets from it are one letter (s for select, e for execute and so on)
3 votes -
trailing spaces
Option for removing trailing spaces
3 votes -
Wrap words in IN clause
You can opt to have SELECT, GROUP BY, UPDATE, and other clauses stack their parameters. I think the IN clause should also have this capability.
6 votes -
Don't qualify column name in certain scenarios
Currently SQL Complete has an option to automatically qualify column names. Unfortunately, turning the option on means turning it on for everything.
I love that SQL Complete qualifies the column name with the table name in regular SELECT statements such as:
SELECT t1.Column1, t2.Column2 FROM dbo.Table1 t1 JOIN dbo.Table2 t2 ON t1.Column1 = t2.Column1
However, I find it unnecessary when you are dealing with only one table in an UPDATE/INSERT/DELETE statement. For example qualification is unnecessary in the following statements:
UPDATE dbo.Table1 SET Column2 = 123 WHERE Column1 = 10
or
INSERT INTO dbo.Table1 (Column1, Column2) ...
or
DELETE FROM…4 votes -
Stop autocomplete of table name if you haven't specified the table name yet
For example, when I attempt to write out this query:
SELECT t.Column1 FROM dbo.Table1 t
As soon as I type "SELECT t." the "t" turns into whatever object name matches t the closest (in my database's case, it's some random UDF). I want to write "t.Column1" before I've specified what t is.
3 votes -
Add option to remove empty lines in BEGIN ... END block
Example:
IF 1 = 1
begin
SELECT
'it does'
print('it does')
end
else
begin
SELECT
'it does not'print('it does not')
end1 vote -
Ability to configure JOIN suggerstions for tables with no relations
Automatically propose join tables when JOIN instruction is typed.
Proposal should not be baseed on existing tables relationships since most ERP out there do not have such relationships within the database.What I would like is that the user can configure all joins he knows for each tables and when the user types a SELECT instruction with JOIN that SQL Complete propose the list of all preconfigured joins for the tables already part of the SELECT.
Ex:
SELECT fields
FROM Table1
INNER JOIN Table2 ON Table1Key=Table2.Key
INNER JOIN <here SQL Complete> would propose all preconfigured joins for Table1 AND Table24 votes -
Host SQL Snippets on some sharing site
Provide a facility for us to easily access our snippets from anywhere and share with the community.The Community should be able to upload or browse for interesting and useful snippets.
Possibly allow to search for snippets online. much like how VS2010+ allows to find extensions.
2 votes -
54 votes
-
Show list of procedures on typing procedure name even with no EXEC
Show the list of available procedures when start typing a procedure name, for example:
sp_proc1
3 votes -
Put ON at top of suggestion list when using JOIN
When typing inner join table1, make the ON keyword display at the top of the suggestion list
6 votes -
When creating/modifying stored procedure, include the current procedure at the top of suggestion list
When creating/modifying a stored procedure, it would be nice for the autotext to include the current procedure at the top (dare I say, like SQLPrompt)
1 vote -
Add bookmarks feature
This feature will allow set or clear bookmark on a line of SQL code, and allow move to successive bookmarked lines. as in Textpad (Ctrl + F2) and (Shift + F2).
3 votes -
Once ON is typed put the name of the current procedure at the top of the suggestion list
When creating a procedure, often the next step is to execute a piece of permission code. ie:
CREATE PROCEDURE db.uspdbForgeSQLComplete
GO
GRANT EXECUTE ON ..... TO .....
GOOnce ON is typed it would be great if the prompts list included the name of the current procedure at the top of the list even if it hasn't yet hit that cache or been created.
0 votes -
collapse blocks to definitions
hi, I work with MS SQL Managemenet System and a lot of *.sql files for updating databases
to my specific file can have a lot of lines of code (up to 1000 lines) and navigation and reading becomes tragic - I always manually collapse (press on [-] next to block name) all blocks like CREATE PROCEDURE, CREATE FUNCTION
I really love your SQL Document Outline feature
so you can handle another feature 'Collapse all blocks to definition' and simplify the life of a lot of db coders
Will be glad to be among your clients
Thank you and good luck,…3 votes -
Filter formatting options based on selection
This would likely have to wait until the live preview is implemented http://devart.uservoice.com/forums/87893-sql-complete/suggestions/1434717-a-handy-feature-would-be-to-show-a-live-preview-of
It would be awesome if there was a way with the live preview for the UI to indicate which options affected a given line. So, for instance, you click on one of the conditions in the WHERE clause, and it indicates that the 'New Line Before', 'Indent Clauses', and 'Word Wrap' options all contributed to how this line looks. That way if, for instance, the formatter is placing the 'AND' statement after the condition rather than before as you would prefer, the many options would be filtered…
1 vote -
Word Wrap SELECT list only
Currently there is an option in the Code Formatter to word wrap code if it exceeds the right column margin, but that isn't ideal for the instance where you want an individual clause in the WHERE statement to stay on a single line no matter how long they are (makes it clearer what the exact logic is). Disabling this, though, forces all of the columns in the SELECT list to be on one line (I have stacking disabled for the fields). I'd say it is a common enough convention to warrant a special flag just for word-wrapping the columns in…
11 votes -
Hide other databases from suggestions
An option to not suggest other databases while populating the suggestion dropdown would be nice. In our system, we have discrete databases for each client, and so our development machines have hundreds of databases on them. When attempting to type a table name, it is not uncommon for SQL Complete to suggest a database name that matches the abbreviation, but for our use case this will never be ideal (queries are basically never ran across databases, and when they are we can deal with having to manually type out the database name).
At the very least, I think it would…
2 votes
- Don't see your idea?