141 results found
-
Filter autocomplete list by any substring, not just word initials
Today, SQL Complete supports filtering the AutoComplete list by typing the initials of CamelCase identifiers. In Resharper, you can type any sequence of characters from the member you are looking for, and the autocomplete list is filtered by any members which contain the character you typed, as long as they appear in the same order you typed. This makes it easier to find what you are looking for, because it's easier to type parts of words than to remember the exact words and their initials.
3 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 -
auto alias with full table name or allow rename for non-aliased names
This will interface beautifully with the rename option that is included with SQL complete. Frequently i'll copy code sets that use two different objects or start as table reads and later become a read from a temp table. being table to change the "from" and easily being able to the rename the alias/table to the new source and have all other references to it be updated as well would be great
3 votes
AdminDevart
(_, Devart)
responded
Could you please provide us an example of this?
You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
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 -
code preview when hovering a tab or session in the "Documents Sessions" window
Code preview when hovering a tab or session in the "Documents Sessions" window. I often have several tabs open at once and they are all called "SQLQuery#.sql" which doesn't help. Allow me to see what code is in the tab by hovering it, or ctrl+tab or like tabing through windows or hovering windows in the taskbar in Windows.
3 votes -
Creating relation mappings for databases that may not be changed
In our company we are working with SAP Business One (SBO). SBO has a fixed database stucture which may not be changed at all. Relations are not directly built into the database.
A custom relation mapping feature would help us with correct suggestions for the databases while still maintaining the database structure as it is.
3 votes -
Format Document button enhancement, to give the ability to select Style
It would be nice if the "Format Document" / "Format Selection" toolbar buttons in SSMS had a drop-down arrow next to them (like the "Other Windows" button in the Standard Toolbar). When pressing that arrow, all available Formatting Styles would appear in order for the user to select the formatting style to use. If the button was directly pressed, the default Style would be used.
If that is difficult, it would be nice to have a separate combobox containing all Styles and use that to perform the formatting when the button is pressed.
3 votes -
Add a flag to individual snippets to exclude from formatting
Sometimes we have pre-defined snippets that are already formatted in a specific way, e.g. on one line, and shouldn't get adjusted by formatting.
To support this, add a couple of checkboxes to snippets:
[x] Exclude from line-break formatting
[x] Exclude from in-line character formattingThe first would cause formatting to ignore the snippet with regards to rules that insert line breaks; the second would cause formatting to ignore the snippet wit regards to non-breaking formatting (case, spacing, etc).
Common use-case; we have a subquery that gets used a lot to find the max value in a field, and if expanded…
3 votes -
Format Comments
I would like to format the comments that appear at the end of a line as part of the "stack columns" and "Table View".
The stacking and table view for comments should have similar behavior as the column and alias view. They appear column aligned.
Example (because posting destroys the formatting of my post, I'll use "." for spacing):
SELECT
.....column1.....AS a.........-- CommentA
.....col2............AS b........ -- CommentB
.....col3........... AS abc.....-- CommentCThank you. Jake.
3 votes -
Override capitalisation of certain keywords
I like to capitalise 'begin' and 'end' in lower case so my code looks like this:
IF @Return = 1
begin
SELECT Name FROM Table
end
ELSE
begin
SELECT 0
endThe begin and end words should not be as bold as the sql statements, a bit like curly brackets are.
3 votes -
Alter Format of Generate Script > Insert #tmpTable
With in the feature "Generate Script > Insert #tmpTable", it renders the DROP TABLE after the CREATE TABLE and SELECT. In troubleshooting and R&D, however, there is value in having the temp table be retained. 90% of the time, I transform the DROP TABLE in to DROP TABLE IF EXISTS and move it to just before the CREATE TABLE.
I would like the option to either customize the rendering to fit my needs, or the option to select this alternate style of rendering in Options.
3 votes -
Option to remove the new Clear button from Query History
The new Clear button in Query History seems, in context, to mean clearing the search or filters applied to searching the history. However, it clears the history - deleting everything. Please either let me turn it off or, even better, just move that to the Options / Settings area. I lost so much history because I wasn't paying close enough attention.
3 votes -
Stacked list with commas before items: make commas align with indent
I have tab size and indent size both set to 4, so most indented items are indented by 1 tab. This is what I want.
However, with a stacked list, I want the leading comma to be indented by 1 tab (and the first item by 1 tab plus 1 space).
At the moment, the commas are indented by 3 spaces. The only way I have found to change this is to set indent size to 5, but that then causes other indents to be 1 tab + 1 space.
3 votes -
align equals
I like the option to align assignments in SELECT, UPDATE, etc, but I don't like that the alignment happens after the equals sign. It's much neater and easier to read when each column is aligned with an equals sign for the assignment.
(It's for this reason we use equals for column aliases rather than AS)
3 votes -
Add an option to Execute Current Batch
Add an option to Execute Current Batch, similar to Execute Current Statement, but highlight and run everything between the current batch separators.
It's a feature I've seen that RedGate SQLPrompt provides and it would be useful to have the ability to run everything within the current batch without having to highlight it all first and then running the selected text.3 votes -
Smarter subquery intellisense
It would be nice to have smarter subquery intellisense that works like the joining intellisense that suggest matches based on column names.
E.g.
SELECT * FROM Users WHERE EXISTS (SELECT 1 FROM UserRoles WHERE Users.UserID = (**Pop up intellisense suggesting UserRoles.UserID*) UserRoles.UserID AND UserRoles.RoleID = 1)E.g.2
E.g.
SELECT UserID, UserName, (SELECT COUNT(1) FROM UserRoles WHERE Users.UserID = (**Pop up intellisense suggesting UserRoles.UserID*) UserRoles.UserID) AS NumberOfRoles FROM Users3 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 -
Create SQL Complete Extension for Visual Studio Code
Create SQL Complete Extension for Visual Studio Code
More and more I find our developer teams using Visual Studio Code as single IDE for all development and scripting. While the SSMS and Visual Studio extensions are great, most of our developers are not using those tools as much and find it cumbersome to open up the supported IDE's to get SQL Complete's benefits.3 votes -
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.
-
Vertical Tabs for Files
In Visual Studio there is a plug that allows you to have the document tabs down the right hand side, which when you have loads of files open is very useful, especially now we have widescreen monitors. However SSMS is behind the times and the tabs along the top isn't enough. Can you please add a feature to display the sql tabs down the side rather than the top.
3 votes
- Don't see your idea?