231 results found
-
The first entry in the suggest list dropdown should chosen automatically
The first entry in the suggest (intellisense) list dropdown should chosen by default.
This will speed up my typing as the 1st word at the top is typically is the best fit, but to chose it I need to move my mouse or the down arrow key to actually choose it.23 votesThis is governed by the option ‘Select items in the list if a user input is expected’ that is in the ‘List Members’ branch of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).
-
Suggestion: Option to switch between select format styles
Here is a suggestion to allow the formatter (to be set to and) to automatically change the formats of declaring a field name and its definition.
i.e.
Style 1: select [field1] = a+b
Style 2: select a+b [field1]
Style 3: select a+b as [field1]23 votesA possibility to switch between formatting styles is added.
-
Reverse order of ON clause
Auto-complete always enters an ON clause as:
SELECT * FROM Table1
INNER JOIN Table2 ON Table2.Value = Table1.ValueThis is really annoying to me. I would like an option to reverse the ON clause so it completes like this.
SELECT * FROM Table1
INNER JOIN Table2 ON Table1.Value = Table2.Value22 votes -
automatic insert table alias on columns
when typing a query have the table alias inserted before the column automatically. For example, in the query below, the t. will automatically get inserted before the column names after the table with an alias is entered.
Select t.column1, 1.column2
from tablename t
where t.column1 = @value22 votes -
mouse over
On mouse over column or variable, show datatype full . Ex: varchar(nn), bigint NOT NULL primary autoincrement has index has unique has clustered...
22 votes -
Autorefresh db objects
Autorefresh db objects data held in cache.
I have to manually refresh to see new objects or changes to existing objects - it does not automagically detect changes. It could, by reading the datemodified in sys.allobjects and searching for ones newer than last refresh.
ALGORITHM: If more than one minute (configurable, can be 0) from last refresh, SELECT ... FROM sys.allobjects WHERE modifydate &rt; @LastRefreshTime If any objects found, refresh ONLY THEM. This is very fast, and you will have allways current data.
21 votesTry dbForge SQL Complete v.4.5 beta!
-
Highlight all occurrences of selected word
Highlight all occurrences of a selected word in the current document.
20 votesVersion 3.0 is on the site
-
Highlight paired braces, begin/end, etc like SSMS does.
SSMS editor will automatically highlight paired parentheses and BEGIN/END when one is selected. Very useful in complex statements.
20 votesGet the feature in SQL Complete v5.0!
-
Insert Script generation for row/rows
I would love to see an option where you can right click on a row and say generate insert script for the row. You could also extend this to select multiple rows and limit column selection.
20 votes -
20 votes
Version 3.0 is on the site
-
Synchronize "Refresh Local Cache" with "Refresh Suggestions"
Guys,
Synchronize SQL Complete "Refresh Suggestions" command with built-in "Refresh Local Cache".Overwise, It's always needed to click both of these commands (first refreshes intellisense, sencond refreshes error highlighing)
20 votes -
Support INSERT/UPDATE statements within MERGE statement
Provide the column list for the INSERT/UPDATEs within the MERGE statement.
18 votesThis feature is implemented in dbForge SQL Complete, v4.8 http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Active Directory Integrated Authentication
We'd like SQL Complete to work with (Azure) Active Directory Integrated Authentication
18 votes -
Option to set "Do not change" for Identifier Case
When configuring the formatting options I need to be able to set the identifier case to be unchanged (Camel Case in my instance). Table aliases are fine in lower case.
I can't use version 4 of the product without this.
18 votesPlease, download the latest build.
-
Ability to select different formatting for alias and schema
The only deal breaker is the inability to generate upper case table alias, without also making all schemas uppercase.
18 votesThis is governed by the option ‘Generate aliases in UPPER case’ that is in the ‘Alias’ branch of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).
-
checkboxes to select what columns you want to select
when you need to select a column from a table for anyreason. have them listed with checkboxes so you can just selected the ones you want included and they will be insterted into your query.
17 votes -
Option to put commas at beginning of line rather than end
For example:
SELECT Col1
, Col2
, Col3etc.
17 votesIncluded into SQL Complete v2.50
-
Autocomplete functions with braces
When autocompleting a parameter less function like say: getdate, include also the braces () and put the caret after the closing brace so you can continue typing without having to type the braces youself
When autocompleting a function with parameters, also automatically put the braces, but place the caret in between the braces (<caret here>) so you can directly start typing the parameter.
16 votes -
Add code snippets support
Templates and code snippets should be available as a shortcut to enter. Also the ability to add ones own code snippets.
16 votesVersion 3.0 is on the site
-
"Run Current Statement" Suggestions
I use Oracle SQL Developer more than SQL Server Management Studio, and constantly find myself attempting to use Ctrl-Enter in SSMS to execute the current statement, instead of the existing shortcut of Ctrl-Shift-E. Since Ctrl-Enter in SSMS currently appears to provide the exact same functionality as does the Enter key alone, could Ctrl-Enter perhaps be an additional (or alternate) shortcut for "Run Current Statement"? I can't think of any reasons why there would be any objection to this, but if there are, perhaps this functionality could be turned on or off via an Option.
If a SELECT statement ends with…
16 votes
- Don't see your idea?