156 results found
-
Drop-down list of history searches
Now, each time I want to search in Execution History I need to type keyword I want to find. It would be nice that it would be store last X searched keywords and it would be possible to select from drop-down menu those items
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 votesAdminDevart (_, Devart) respondedCould you please provide us an example of this?
You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
mark statement to exclude in execution history
Possibility to exclude lines of code in execution history that include senitive date (username and/or password)
example:
-- run code in sqlcmd mode
:connect [servername] -U my_account -P T0pS3cretP@ssw0rd!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 votesAdminPMs (Admin, Devart) respondedWe just checked and confirm that changes made in the snippets are preserved when upgrading dbForge.
-
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 -
Add "Copy Current Statement (Ctrl+Shift+C)" & "Cut Current Statement (Ctrl+Shift+X)"
Execute Current Statement is a great feature to test out a statement currently being worked. Sometimes I like to break a statement out to its own query window for further development.
Copy (or Cut) Current Statement would work just like Execute Current Statement except it would copy (or cut) the statement to clipboard instead of executing it.3 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 -
Add option to adjust font on intellisense
No option to enlarge font. font size on intellisense is too small.
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 multiple documents
In the Object Explorer of SSMS I would like the ability to format multiple documents via the context menu.
The menu item should be available for Database, Views, Programmability, Programmability/Stored Procedures and Programmability/Functions, and should format all documents in the 'folder'.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 -
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 -
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 -
Allow hiding of standard columns when expanding "SELECT *" with TAB
I would be helpful to be able to hide ID or partitioning columns that may not ever be needed when selecting data. They just get in the way when expanding SELECT * but are still necessary to the table structure.
3 votes -
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 -
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 -
SQL Code Completion for INSERT INTO for a declared variable AS a user defined type
CREATE TYPE dbo.MyType AS TABLE
(
MyTypeId UNIQUEIDENTIFIER NOT NULL
, MyTypeContent1 VARCHAR(20) NOT NULL
);DECLARE @a AS dbo.MyType
INSERT INTO @a --> Tab-Tab expands just like it does for other table types.
3 votes -
Snipets Manager
I am missing a search box in the list snipets
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
- Don't see your idea?