310 results found
-
Apply Block Comment to Selection
Provide a keyboard shortcut that applies block comment characters at the beginning and end of a selected text. Allow customization so that you can specify how many space characters or newline characters you want applied after the beginning comment characters/before the end comment characters.
3 votes -
AutoComplete table joins
Have the ability to train intellisense when joining tables to learn which tables join together.
so that in the future you can just type:
"select * from employees e
left join "and intellisense gives a drop down list of related tables, which when selected writes out the table name AND join columns.
i.e.:
"select * from employees e
left join "
and intellisense suggests: "manager m on m.managerID = e.managerID"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 -
De-couple execute-current-statement functionality from code completion.
I like execute-current-statement functionality, but when I disable code completion then execute-current-statement functionality stops working.
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.
-
Fix accidental error message popup acceptance
When intensely typing a query and SQL complete has an error in the middle of typing, the error popup window steals focus and if a key is pressed as part of the sql query that accepts the restart ssms button, ssms restarts losing the current work.
2 votesAdminPMs (Admin, Devart) respondedCould you please specify what product version you are using and perform the following:
1. Turn on tracing by selecting ‘SQL Complete → Trace → Start Tracing’ from the main menu.
2. Reproduce the issue and send us the *.log file with the latest date from the folder:
SystemDrive\Users\%UserName%\AppData\Roaming\Devart\dbForge SQL Complete\A video or screenshots would be also of help.
-
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 -
When Formatting, Place Short Queries on a Single Line
I would like the option to specify that queries under a certain number of characters be formatted to be on a single line. This would also apply to subqueries so that if they are over the specified limit it follows the formatting rules already in place for subqueries but places simple subqueries on a single line.
So
SELECT
*
FROM
TABLE
WHERE
COL1 = 5;would become
SELECT * FROM TABLE WHERE COL1 = 5;
and
SELECT
COL1,
COL2,
COL3,
COL4,
CASE WHEN COL5 = 50 THEN 'A' ELSE 'B' END
FROM
TABLE
WHERE
COL1 IN (
SELECT
COLB
FROM…2 votes -
Snippet - Wrap selected text in snippet
SQL Prompt has a fantastic feature that allows selected text to be wrapped up by pressing control + selecting snippet that utilizes the SELECTEDTEXT value. This is great for wrapping up text in "Begin try", "comment blocks" and other selection oriented snippets.
2 votes -
format json output
Add an option to format JSON output with proper indentation and line feeds
2 votes
- Don't see your idea?