158 results found
-
Add an option to show/hide or find columns in the Results pane
It will be very helpful if you have an option to Show/Hide the columns in the Result Set and also an option to search the columnname.
6 votes -
Alphabetical listing when creating a SELECT list
Allow for an alphabetical listing when creating a SELECT list? It makes it difficult to quickly check the checkboxes when quickly adding columns.
7 votes -
Notifications pane
Currently SQL Complete notification (like "Uncommitted transaction" and "Query execution completed") show up and disappear. It would be great to have them on a panel similar to "Document Sessions", so you can review them later.
1 vote -
Display a single row of data in column format
As per Oracle SQL Developer ability to select a row of data and have it displayed in a column. Makes viewing a large row of data a lot easier.
1 vote -
1 vote
-
Popup 'select top 100'
I often find when writing queries in the Sql editor that I want to see a sample of data from the table I'm working with. It would by good if I could right click on the table name in the text editor and have a 'select top 100' option in the popup menu
1 voteAdminDevart (_, Devart) respondedYou could use the snippets functionality of dbForge SQL Complete.
The snippet can be as follows:
SELECT TOP $count$ *
FROM $schema$.$table_name$ -
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 -
Execute current statement with variables
When running a query via "Execute Current Statement", it doesn't run if there are variables referenced. Instead you have to highlight the variable + query to get it to run. It would be nice if the variables were automatically included in the execution
1 vote -
2 votes
-
SQL Complete (or at least formatter) for Firebird?
Could you expand the SQL syntax to allow SQL code formatting for Firebird SQL?
1 vote -
Empty line management
There should be a global empty line management structure for formatting. It would be nice to see:
- Add empty line before/after keyword - Remove empty lines - Add empty line between statements
17 votes -
1 vote
-
If user types a paren *immediately before* a paren, skip *past* the paren instead
AutoComplete suggestion: MS Visual Studio does this, you should too.
- Type in a function name: SQLComplete adds a full set of parentheses: SET X=myFunction()
- Type in function parameters: SET x = MyFunction(1,2)
- If user types closing paren, we have two, which is wrong. Current alternative is to right arrow or something to get past it.
- SUGGESTION: If user types a paren immediately before a paren, skip past the paren instead!
MS Visual Studio does this and it works great.
0 votes -
Extend Insert Highlight Occurences feature to show popup with column name in the values area
when typing out the values for an insert statement
SSMS should popup an infotip very much like when inserting parameter for functions in Visual studio C# code.
e.g. After typing the , (comma). SSMS should show a popup
Insert into Person.Address
(
AddressLine1
, AddressLine2
,City
,StateProvinceID
)
Values
(
,N''
,N''
,N''
, __________________________#
StateprovinceID int not NULL #
_________________________#
^ popUP
2 votes -
SELECT Results Generate INSERTS INTO Temp Table / Table Variable
How about a feature which would take a SELECT result, declare a Temp Table / Table Variable based on the schema of the result, and generate INSERT INTO statements?
I do this often when comparing data across disparate systems where the source data is scripted into a table variable to be compared in the destination system. I use a combination of CONCATs and a WHILE loop to handle the need for a trailing comma (if using VALUE), or trailing UNION if using SELECTs as insert into source.
1 vote -
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 -
Go To Definition should open a connection if one is not already open
Currently you get an error if the Object Explorer is not connected to the same server. Seems like SQL Complete could make that connection for us and save that step.
1 vote -
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 -
Performance when starting visual studio
When starting visual studio with SQL Complete, it takes 15 seconds more to open Visual studio.
Maybe you can change to load the data after visual studio is opened? That way the delay is not visible to the user.
3 votes -
Options group for logical operation enclosed in braces
Add an option group to the formatting profile for the logical operation enclosed in braces. This option group should include the following options:
Line break before opening brace
Line break after opening brace
Line break before closing brace
Line break after closing brace
Indent braces
Indent logical operation
Format braces around single comparison operation as in logical operationsAlso, make the same options group for the following predicates:
- EXISTS
- ALL
- ANY
- SOMEFor details, please the Devart forums http://forums.devart.com/viewtopic.php?f=33&t=35030
6 votes
- Don't see your idea?