39 results found
-
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 -
default suggestion even if containing SQL keyword
Please change the default selected suggestion in the dropdown so that columns in a user table take precedence over SQL keywords.
For example:
When a column in a user table begins with the same word as a SQL keyword (for example the field name "Monthly") -- the default selected suggestion when you type the word MONTH jumps to the "MONTH" keyword instead of staying on "Monthly"Code example:
CREATE TABLE #MyTable (Monthly BIT)
SELECT * FROM #MyTable WHERE M --selection stays on "Monthly"
SELECT * FROM #MyTable WHERE Mo --selection stays on "Monthly"
SELECT * FROM #MyTable WHERE Mon --selection…3 votes -
Named Tabs
It would be great if you could name the tabs, not just when saving a query
1 vote -
Execution History by server
Filter execution history by server that the code has been executed on.
3 votes -
configure Tabs Color for [Server]\Database
I have multiple databases on a server some are Test & dev servers, some are Prod. It would be nice to color based upon [Server]\Database. instead of one color for each server.
1 vote -
indent case end
In the CASE statement, add "Indent END by 4 column(s)
1 vote -
Warnings for Execution should not warn on UPDATE/DELETE to Temporary Tables or Table Variables
Warnings for execution should not warn on Temporary tables or table variables.
Example:
UPDATE T
SET T.Description = V.Description
FROM @Problem1099BoxRows T
INNER JOIN APVouchers V ON T.APVoucherID = V.APVoucherID1 vote -
Space-align multiple column values within INSERT VALUES statement
-- view this with monospaced font
INSERT @t (A, B, C)
VALUES
(1, 2, 3),
(11, 22, 33),
(111, 222, 333),
(1111, 2222, 3333)1 vote -
Disable Data Loss warning for a specific Script
I love the new feature that warns before delete data without any where.
However when writing migration scripts and debug them it can be annoying because it pops up every time.
would be nice if this could be disabled for a script.
for example by using a comment like --disable warning--
1 vote -
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 -
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 -
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 -
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.
-
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
- Don't see your idea?