271 results found
-
don't break my system when I run update install
How about making sure that your updates don't break my system when I run update install. Every time I run your release update your install process wipes out my Environment.Keyboard.Query Shortcuts
3 votes -
Line break after SELECT only if a DISTINCT / TOP clause is used
Title says it all... Give me the option to insert a line break after SELECT only if a DISTINCT / TOP clause is used.
3 votes -
Auto scroll in Messages tab in "Results in Grid" Mode
Please add Auto scroll in Messages tab in "Results in Grid" Mode
3 votes -
lowercase option for snippets
Add an option to choose the case for snippets - uppercase / lowercase / sentence case. This is already a feature for keywords.
3 votes -
Analyze code in order even with GOTO; Showing code issues with GOTO code now
When using GOTO statement, code that should be reviewed inside the GOTO statement is showing with issues underlined. "The multi-part identifier 'ep_view.MemberNumber' could not be bound".
Would be nice if the code was analyzed as it would be executed so these errors are not present. Takes away from the effectiveness of using SQL Complete.
While I don't use GOTO as a habit, this is a large VIEW that runs faster inside so a GOTO to the code at the end works well. Then a simple command can load it only on the initial run and save time for following TESTING…
3 votes -
Multi-select by selection of suggested objects
When joining tables I often get suggestions by SQL Complete for which tables to join. This is extremely useful and saves me a lot of time. Often times however there are multiple joins I want to make to different tables. But I can only select one join at a time. Selecting multiple suggestions with a ctrl+left click or something similar in the suggestions box would be a great addition for my workflow.
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 -
Formatting Profiles - Quick Select (Activate) in Toolbar
it would be great if you add an icon for fast switching between Formatting Profiles in toolbar, rather than going to menu bar SQL Complete>Options>Formatting>Profiles>[select]>Activate>[OK].
The lack of this feature makes it almost impractical to use multiple formatting in one script.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 -
"Are you sure?" for specific environments
The tab coloring is great, but sometimes you need another layer of protection. It would be fantastic if certain environments could be designated as "protected" or something like that, and if you execute a script that in environment that does anything other than a SELECT (INSERT, UPDATE, DELETE, TRUNCATE, ALTER, etc.), a good old-fashioned "You are running this in "<environment name>. Are you sure?" dialog pops up and you have to click YES in order to actually execute the script.
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 -
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 -
Do _NOT_ hijack Ctrl+S. It is not your key combo to mess with.
Ctrl+S is not to be hijacked in the default install under any circumstances.
2 votes
AdminDevart
(_, Devart)
responded
Could you please let us know after what actions exactly it started happening and what exactly happens when you press the mentioned key combination?
Please also specify what versions and editions of dbForge SQL Complete, SSMS or VS you are using.
-
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 -
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 -
Format selected text using several styles
I need fast way to format selected text using several formatting styles, specified previously.
The formatting style specified manually into hotkey (for example, Ctrl+K, Ctrl+F, Ctrl+1 - first style, Ctrl+K, Ctrl+F, Ctrl+2 - second style and etc.).If I see a very long value clause:
INSERT INTO dbo.Table
VALUES ('111111','222222','333333','444444','555555')
I select the code and apply another style like this:
INSERT INTO dbo.Table
VALUES (
'111111',
'222222',
'333333',
'444444',
'555555'
)The hotkey Ctrl+K, Ctrl+F, Ctrl+1 is very hard to push, it is for example.
Maybe you will think of a more simple alternative, but of course without mouse usage.2 votes -
INSERT INTO expansion
When you type "insert into table(" popup with check-boxes shows up. After you select desired columns you have to add 'values' part manually.
It would be nice if after selection of desired columns and typing ")" 'values' part shows up with preset only for selected columns.
2 votes -
unwrap
I love the "format document" and "format selection" features and would be interested in a "unwrap document" and "unwrap selection" feature.
I use Notepad++ to do it currently but it is required when trying to paste SQL Code in Visual Studio.
All it does is turn the code into 1 line...
Thanks
Yann2 votes -
Add column names to VALUES list for INSERT INTO statement generation
When generating the INSERT INTO statement after typing INSERT INTO [TableName] and hitting tab, it would be helpful in the VALUES list, in addition to showing the default value, if the column name was included. For example -
INSERT INTO Users
VALUES (DEFAULT /ID/, '' /FirstName/, '' /LastName/)This way, for wide tables, you don't have to count column to keep track of which column you are working with.
2 votes -
It would be nice to be able to format the BY after GROUP and ORDER as a different line of code
Would like to have the following:
GROUP
BY p.ProjectNo
,p.Titleand
ORDER
BY p.ProjectNo
,p.Title2 votes
- Don't see your idea?