230 results found
-
"Generate Script As" to Clipboard
"Generate Script As" right now creates a new window which is annoying in most cases because you most likely want to use it in some other script. It would be very useful to have an option to copy it to Clipboard instead of a new window. I would prefer to copy it to Clipboard in 95% of cases.
It might be an option in settings or another menu item.
Thank you in advance.
7 votes -
checking update failed
The checking update menu in sql complete may point to a HTTP url and currently devart.com is only available via HTTPS protocal. It let the update checking 100% failed with network error message: cannot connect to remote server.
1 vote -
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
-
Status bar color (use the tab color)
I would like to see the status bar colored like the tab. The tab coloring is already implemented so it would be nice to sync with the status bar also.
1 vote -
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 -
Increase thickness of the window coloring line
Please add an option to control the thickness of the coloring line of the tab for different servers. The line on the top of the screen is very thin on high definition monitors, so it is difficult to see.
1 vote -
Code formatting for Merge Into "Values"
Merge doesn't have formatting for source table formed from values.
MERGE INTO [TargetTable] AS T USING (
VALUES (@UserId, @InternalId)) AS S
([UserId], [InternalId])
ON T.[UserId] = S.[UserId]
WHEN MATCHED ...5 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 -
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 -
Support for multiple SSMS instances
When running two or more SSMS instances there is an error that pops up pretty often saying: "Access to the path 'C:\Users\FFlintstone\AppData\Roaming\Devart\dbForge SQL Complete\docsessions-journal.db' is denied."
1 voteThis issue is fixed in dbForge SQL Complete, v5.6.169 https://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Automatically add terminating semi-colons to statements
Given that MS is going the route of eventually requiring terminating semi-colons on statements, it would be useful to have an option to do that for me.
1 voteWith dbForge SQL Complete v5.6.146, you can right-click in the SQL document and select ‘Insert Semicolons’ from the popup menu.
-
Close SQL Complete connection to SQL Server when not being used.
When running sp_who2 I can see tasks for "dbForge SQL Complete" for each user running SSMS even when it's not doing anything. (I guess the connection is pooled between each request that the application needs to make?)
Anyway, our admins don't like to see all of these jobs just hanging around doing nothing, especially on our live servers. Any chance of turning off your connection pooling?
1 voteWe would like to let you know that we have released dbForge SQL Complete, v5.6 where the issue you reported is fixed https://www.devart.com/dbforge/sql/sqlcomplete/download.html
Thank you for your help in improving dbForge SQL Complete.
-
Fix capitalization for identifiers with underscores in them _
I spend most of my time working in databases that (unfortunately) use _ underscores to separate words. For example, a table might be called VehicleRidershipActivity instead of VehicleRidershipActivity. This causes the "Proper Case" option to not work on any of these table names, column names, sproc names, etc..
The worst part is that even if I type them correctly or paste them in when they were correct, they will get "corrected" to all lower-case letters after the first letter (for example VehicleRidershipActivity will be changed to Vehicleridershipactivity).
If this is intended, please consider changing.…
3 votes -
Add #temp support to the express addition
Adding limited support for auto SQL complete for column names to be read from #temp table in the express version
3 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 -
Built-in DataType Case option is being ignored
In SQLComplete 5.5.159, the Built-in DataType Case set to lower, but all types are automatically converted to upper case
1 voteThis can be setup as follows:
1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select the active profile.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Navigate to the ‘Text Case’ node and select the options you need. -
Active Directory Integrated Authentication
We'd like SQL Complete to work with (Azure) Active Directory Integrated Authentication
18 votes -
Fully qualified server reference
When performing a query like "Select * from Servername.schema.table"
where servername is the current server connected to, table hints are not available.
3 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
-
1 vote
- Don't see your idea?