39 results found
-
Support SSMS 2016
Support SSMS 2016 CTP
33 votes -
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).
-
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 -
Active Directory Integrated Authentication
We'd like SQL Complete to work with (Azure) Active Directory Integrated Authentication
18 votes -
Display more information about Document Sessions
Display more information about Document Sessions. Currently, it just has SSMS version and number of files in the session (SSMS 2017 (2)).
Session Caption:
1. SSMS Version is close to useless. Because SSMS 2017 provide great backward compatibility with other SQL Server versions. So you don't really need. Please remove it.
2. Add date and time when the session was saved last time.File list:
3. It would be useful to have server and database next file name.
4. Each file has backup time but not backup date. Please add it.Document Sessions screen:
5. Revisit design of the Document…12 votes -
When formatting document or selection, leave cursor on same line on screen
When formatting a document or selection, the line with the cursor is moved as far down on the screen as possible. I would like it to stay on the position on the screen.
As it is now, I have to "search" for the cursor every time I have formatted and often I will have to scroll, since I will typically want to see the code below the cursor.
9 votes -
Format first row in stacked list with leading space
You should be able to add a leading space for the first row in a stacked list with leading commas, so the column names would be evenly aligned.
8 votesThis feature is implemented in version 4.8 and applies when the ‘Stacked List → Place comma before item in stacked list’ and ‘SELECT → Select List → Line break before first column’ options are selected in the ‘Edit Formatting Profile’ dialog.
-
Implement code formatting for Merge statements
Currently, the SQL Formatter has absolutely no options for Merge statements, and they are not formatted very nicely at all.
Please provide options for formatting all the aspects of Merge statements:
- Using section
- WHEN MATCHED section
- WHEN NOT MATCHED sections
- Output sections
Also, if possible, provide the option to have these sections use the same formatting as standard statements. E.g. Update statement in When Matched section uses standard update format, etc.
6 votesThis feature is implemented in dbForge SQL Complete, v4.8 http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Add type into into Tooltip for table column
It would be very usefull if tooltip (OnMauseOver) for column name in select would also provide info about column type, for example
[table].[column](column) => [table].[column](column, int)4 votes -
Sub condition formatting
Example of what you can get currently:
AND
(
old.TestString1 != new.TestString1
----OR old.TestString2 != new.TestString2
----OR old.TestString3 != new.TestString3
);Example of what I'd like to do:
AND
(
----old.TestString1 != new.TestString1
----OR old.TestString2 != new.TestString2
----OR old.TestString3 != new.TestString3
);4 votesThis can be setup as follows https://s8.postimg.cc/cqteckgid/sub_condition_formatting.png
-
Add extended properties for columns in quick info window for table
When navigating the mouse cursor to a table, display extended properties in the quick info window.
3 votes -
Functions on Result Window
After selected a column in the result window the possibility of some funcions on it:
- the min/max/avg of the column (if number)
- order the results by a column A-Z, Z-A
- filter the rows with a value
- ...3 votesThis feature is implemented in v5.8 excepting:
- order the results by a column A-Z, Z-AWe added a separate suggestion for this https://devart.uservoice.com/forums/87893-sql-complete/suggestions/33150733-order-the-results-by-a-column-a-z-z-a-in-result-w
-
Intellisense doesn't work when using CROSS/OUTER APPLY of a user defined table-valued function
When filling in the parameters for the TVF and it has been CROSS/OUTER APPLY'd with a table, the intellisense does not show any of the fields from the table even though they are allowed in the TVF. Even if the parenthesis is closed on the TVF, the table's fields don't show up. The intellisense options that come up are the generic list of dbs, tables, functions, snippets, etc.
E.g. -
SELECT * FROM Users u
CROSS APPLY dbo.FindInvoiceFiles([INTELLISENSE DOESN'T SHOW FIELDS FROM Users table]) fif3 votes -
SSMS 20.x support
SSMS 20.x has been out for a while now, but I am not upgrading until I can install SQL Complete for it, of course ;-)
3 votes -
Synonyms Intellisense
Please provide Code Completion for Synonyms!
I have a development database where I created a synonym for every table and view in another database on another SQL server. When I use SQL Complete and type a SELECT statement for a synonym, column names do not appear.
Please modify SQLComplete to provide column names when crafting a SQL statement for a synonym!
Thanks!
3 votes -
Execution History by server
Filter execution history by server that the code has been executed on.
3 votes -
JOIN FIELDS SUGGESTIONS - Enable TAB acceptance of first suggestion
When PRIMARY and FOREIGN KEYS share the SAME NAME according to best practises allow the JOIN suggestion to be immediatly pick up with TAB.
Most of the times the good suggestion comes at top on the list and one can allways navigate to a better one if this is the case3 votesThis can be achieved as follows:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘List Members’ branch in the ‘Options’ window.
3. Select the ‘Tab’ option.
4. Click ‘OK’. -
CTR+F12 Options
Currently in SSMS if you right click on a stored procedure and select modify you get something like this
ALTER PROCEDURE [dbo].[ProcedureName]
In SQL complete when use the key commands CTRL+F12 on exec ProcedureName you get this
ALTER PROCEDURE dbo.ProcedureName
notice the missing hard brackets.
I would like an option i can set in SQL Complete to include the hard brackets
3 votes -
Ability to select multiple fields from code completion( wildcard expansion)
Could you please provide the ability to select multiple fields from code completion pop-up( wildcard expansion).
3 votes -
warn when running a query with no predicate
if running an update/delete statement with no predicate on it, it would be nice if there was a warning to appear asking if I was sure I wanted to run the query.
it would prevent accidental deletion/update of a full table when I was only after one row and I forgot to include the predicate.
3 votes
- Don't see your idea?