272 results found
-
Saved Filters in SSMS
Within SSMS, allow for the saving of filters.
Justification:
Particularly within large databases, often there is a reoccurring need to work with just a subset of tables. Sometimes, within different contexts, the particular subset changes. Being able to easily apply commonly used filters can allow increased productivity by eliminating frictional work (e.g. scrolling and hunting). Additionally, when filters across object types can be applied, there can be a lot of power. For example, being able to filter a particular set of SQL Agent Jobs, associated tables, and procedures related to those jobs, allows a troubleshooting developer to quickly set into…4 votes -
More Intelligent Intellisense
While camel casing matching is extremely helpful, it breaks when adding middle characters to it, perhaps consider adding to it the same way Visual Studio does it, it’ll be much more helpful.
For example, consider I have a column "FinalSellingFee" and a column "FreeShippingFunction", when I enter "fsf", both appear, now I only want the second, in Visual Studio I'll simply enter "fsfu" (adding a "u" at the end), or "fshf" (adding an "h" after the "s"), and it'll automatically get that I want the second. It makes it so much easier and quicker.
3 votes -
Persist column layout in Execution History
The execution history is a great feature. It can be made more using if SQL Complete was able to persist column changes (moves or exclusions). Currently, the end user is able to move the columns, for example, move the Server column to the left or right. The end user can also remove unwanted columns. However if you close SSMS and reopen, the columns are back to their original positions. This is not very user friendly as the purpose of a user changing the column layout is to have it displayed the way they want.
1 vote -
Installer - Allow option to keep edits I've made to default snippets
When installing an upgrade, my additions to the snippets manager are maintained. However, I would like the option to keep all edits I've made to the default set of snippets as well.
3 votes
AdminPMs
(Admin, Devart)
responded
We just checked and confirm that changes made in the snippets are preserved when upgrading dbForge.
-
Add context menu item "Copy to new window" to Results window
I often use SQL to generate SQL commands based on information from sys tables. This enables me to keep things in sync.
Currently I need to Ctrl-C my selection, open a new tab, Ctrl-V in it, and then hit F5.
A context menu item, that does all this (except F5) would be a nice addition.1 vote -
Toggle Comments
New option to Toggle commenting/uncommenting on the current line selections as most other editors have. Map to CONTROL-/ by default to match the commenting behavior of other editors.
Why SSMS does not have this baked in is f'in ponderous.
7 votes -
Insert missing square brackets when formatting selection or whole script.
We have a policy of always putting square brackets around identifiers in SQL Scripts. When using SQL Complete we have the option turned on to always use square brackets and this works fine when scripting brackets are inserted for us just fine. However when we open a legacy script and format the document, missing square brackets are not inserted so we have to manually go through the script to add them.
If Always On is selected for square brackets then I press Ctrl+K Ctrl+D to format the document I would like to have missing square brackets inserted, that is all…
5 votes -
Keep list members open
It would be awesome, if you easily could select more than one suggestion in the "List Members" dropdown.
I often need to choose more than one field from a table - and if the table needed isn't the first one, it takes some extra typing to find it.
One option could be to leave the dropdown open when choosing an item. Another option (Stolen from LinqPad), is to press a dedictated key (½ or ` in LinqPad) which chooses it, but leaves the suggestion list open.
3 votes -
Higlight Case errors
Like Microsoft's IntellySense does, when you open or write a script, case errors in variable names, table names, and field names are underlined in red (higlight) as a warning and can be corrected if desired.
This funcionality is like a spell checker.
You currently open a script and SQLComplete is not able to tell you what case errors there are.
This is quite important in environments where this requirement is required to be met.1 vote -
multiple row tab
Provide for MULTIPLE TAB ROWS like TabsStudio has. This way there's no need for the file menu drop-down list, no need to manually pin tabs, the tabs keep stable order.
Thanks
4 votes -
Extract to a function or a procedure
By selecting a portion of the code in a stored procedure, giving the ability to create a new stored procedure or function from that code.
All variables present in the selected code are automatically passed as parameters. The selected code is then replace by a call to the function/procedure
This will help to divide the code in sub function and been auto documented.
1 vote -
Option to Format Index Statements
As a user it would be helpful to be able to customize how INDEX statements are formatted.
For example, it would be nice to be able to configure the indent for the second line where the "INCLUDE" statement is as shown below:
CREATE NONCLUSTERED INDEX [IXTableColumn] ON [dbo].[Table] ([Column1],[Column2], [Column3])
INCLUDE ([Column4],[Column5],[Column6])
GOCurrently, SQL Complete formats the above text pushing the second line all the way to the left as shown below:
CREATE NONCLUSTERED INDEX [IXTableColumn] ON [dbo].[Table] ([Column1],[Column2], [Column3])
INCLUDE ([Column4],[Column5],[Column6])
GOI am unable to find a current setting to indent the second…
3 votes -
Format Block Comments
As a developer, I would like options to format Block Comments.
Each of these would be check boxes to enable/disable the feature. The last two options would have a text input box at the end to allow the user to enter the character(s)
☑Insert empty line before block comments
☑Insert empty line after block comments
☑Add border above block comments using: *
☑Add border below block comments using: *Before:
USE AdventureWorks2012
GO/* First line of a multiple-line comment.
Second line of a multiple-line comment. */SELECT * FROM HumanResources.Employee
SELECT * FROM Person.Address /*Single line comment*/
GOAfter:
…
3 votes -
Spelling check of the comments and optionally in variables, column names, etc
It is very common to make typos or spell words incorrectly as you code or write comments. It would be nice to introduce a spelling check of the comments and optionally in variables, column names, table names, procs, functions similarly how it is done in PyCharm.
That is especially useful when you create new tables. If you misspell a column name it is such a pain to fix it later.
1 vote -
code completion not working when db is offline
when db is offline during ssms startup - it won't get code completion.
you have to bring it online and restart ssms1 vote
AdminDevart
(_, Devart)
responded
Could you please clarify if it does not work only for offline databases or for each database on the server?
A video or screenshots would be also of help.
-
compare
add feature to compare 2 open tabs in management studio, or compare 2 code objects from different db's to see the changes highlighted
1 vote -
Suggestion: Null & Not Null count on Grid aggregates
It would be really useful if the option is added to see NULL & NOT NULL Count info on the Grid aggregates info-bar along with other aggregates. This will save a lot of time in finding any null value if presents in large data result set.
3 votes -
TEST MODE
There should be a toggle-button that flips between a TEST mode and a production mode for your "code/code window"... And when its in TEST mode, whatever code is there, BEFORE it is executed, is WRAPPED in a Transaction AND rolled-Back.
APEX SQL has this feature, trying to switch to Devart, and missing it.
1 vote -
Alias generation new rules
Hello,
I would like to get new options for alias generation that are not based on first letters of the object name but more on parts of the name itself.
I work with a database that uses the following name standard: T{1}{222}tablename where {1} equals the type and {222} equals the unique trigram for the table (ie: TRCUScustomer for customers table, R being a reference type). I would like the alias to use the {222} part of the name (so "cus" in this case).
So a new rule such as "T*{3}*" where the 3…1 vote -
Can write a label to any tab
I click new New Query, then a new Tab open, I wrote my code, then I click again New Query and other Tab open, so I dont want to save to disk this tabs, but I would like to rename and put a label on each so if I have 10 Tabs opened, I can identify quickly for the tittle each one.
1 vote
- Don't see your idea?