268 results found
-
Create an option just change casing
In SQL Complete, I would love an option that lets you Format Selection but only changes the casing to what you have specified in your active profile. It would leave all other formatting as is.
3 votes -
rename
It would be very helpful to be able to right click on a tab in SSMS and have the option to rename it.
I currently have "SSMS Tools" installed to be able to accomplish this. Would be great to have the option in SQL Complete and be able to uninstall "SSMS Tools"
3 votes -
column lookups in MERGE statements, like in INSERT statements. Click on a column name to find the corresponding value in the VALUES area.
column lookups in MERGE statements, like in INSERT statements. Click on a column name to find the corresponding value in the VALUES area.
3 votes -
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 -
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 -
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 -
"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 -
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 -
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 votesAdminDevart (_, Devart) respondedCould 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?