157 results found
-
compare
add feature to compare 2 open tabs in management studio, or compare 2 code objects from different db's to see the changes highlighted
1 vote -
Format Block Comments
As a developer, I would like options to format Block Comments.
Each of these would be check boxes to enable/disable the feature. The last two options would have a text input box at the end to allow the user to enter the character(s)
☑Insert empty line before block comments
☑Insert empty line after block comments
☑Add border above block comments using: *
☑Add border below block comments using: *Before:
USE AdventureWorks2012
GO/* First line of a multiple-line comment.
Second line of a multiple-line comment. */SELECT * FROM HumanResources.Employee
SELECT * FROM Person.Address /*Single line comment*/
GOAfter:
…
3 votes -
Alias generation new rules
Hello,
I would like to get new options for alias generation that are not based on first letters of the object name but more on parts of the name itself.
I work with a database that uses the following name standard: T{1}{222}tablename where {1} equals the type and {222} equals the unique trigram for the table (ie: TRCUScustomer for customers table, R being a reference type). I would like the alias to use the {222} part of the name (so "cus" in this case).
So a new rule such as "T*{3}*" where the 3…1 vote -
New Query Template
It can possibly be done with the 'snippet', but when I hit Ctrl- N in SSMS, it would be great if 'my' standard template opened. This allows me have the necessary 'set' options pre configured etc
4 votes -
Spelling check of the comments and optionally in variables, column names, etc
It is very common to make typos or spell words incorrectly as you code or write comments. It would be nice to introduce a spelling check of the comments and optionally in variables, column names, table names, procs, functions similarly how it is done in PyCharm.
That is especially useful when you create new tables. If you misspell a column name it is such a pain to fix it later.
1 vote -
Suggestion: Null & Not Null count on Grid aggregates
It would be really useful if the option is added to see NULL & NOT NULL Count info on the Grid aggregates info-bar along with other aggregates. This will save a lot of time in finding any null value if presents in large data result set.
3 votes -
TEST MODE
There should be a toggle-button that flips between a TEST mode and a production mode for your "code/code window"... And when its in TEST mode, whatever code is there, BEFORE it is executed, is WRAPPED in a Transaction AND rolled-Back.
APEX SQL has this feature, trying to switch to Devart, and missing it.
1 vote -
Auto-filling the GROUP BY
When I type group by and press the space bar to display "all non-aggregated columns" in the context menu. When I select this option, all columns that are not aggregated are added to the group with all their functions
9 votes -
SQL Code Completion for INSERT INTO for a declared variable AS a user defined type
CREATE TYPE dbo.MyType AS TABLE
(
MyTypeId UNIQUEIDENTIFIER NOT NULL
, MyTypeContent1 VARCHAR(20) NOT NULL
);DECLARE @a AS dbo.MyType
INSERT INTO @a --> Tab-Tab expands just like it does for other table types.
3 votes -
Can write a label to any tab
I click new New Query, then a new Tab open, I wrote my code, then I click again New Query and other Tab open, so I dont want to save to disk this tabs, but I would like to rename and put a label on each so if I have 10 Tabs opened, I can identify quickly for the tittle each one.
1 vote -
Sync user settings and snippets across machines
Sync settings and snippets across machines.
For example, if I create an custom snippet on my laptop, then shift to my desktop, the snippet would sync'd to my desktop automatically
1 vote -
Snippets - Add Predefined Literals for Date Parts
I would like to be able to use a different format for the DATE predefined literals than YYYY-MM-DD. It would be helpful to include one for YYYYMMDD ... or have literals for YEAR, MONTH, and DAY so I could create my own combination from them.
4 votes -
Store the history in text files and not a binary 'database'.
It makes searching for queries MUST easier and is a significant reason I will keep using a competitors product (with the resulting conflict between the 2)
1 vote -
Server Color
There is server coloring in the project. But there are only a few colors I can choose. If I can do it like in SSMS Tool Pack, I can choose any color for the server
1 vote
AdminDevart
(_, Devart)
responded
You might be referring to the Tabs Color feature that can be setup in the ‘Tabs Color’ section of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).
-
Snipets Manager
I am missing a search box in the list snipets
3 votes -
mark statement to exclude in execution history
Possibility to exclude lines of code in execution history that include senitive date (username and/or password)
example:
-- run code in sqlcmd mode
:connect [servername] -U my_account -P T0pS3cretP@ssw0rd!3 votes -
Display what PC an activation is against
Either display the hardware hash in the about box or show the computer name in the manage license web page
1 vote -
SET instead of SELECT whenever possible
We use SQL Complete to format our SELECT statements. So the following
SELECT [aField] FROM [dbo].[aTable]
turns into
SELECT
[aField]
FROM
[dbo].[aTable]However, this stament is then also transferred from
SELECT @intVariable = 1
into
SELECT
@intVariable =1This is messy, so when we're not selecting from a table, we would like SQLComplete to format our that statement into
SET @intVariable = 1
In this case it all fits nicely on a single line again.1 vote -
I need snippet created by highlight then right click
I need snippet created by highlight then right click, not open from menu, that is too complicated. If create more, that cost too much time. We need simple but powerful, currently this feature not.
1 vote -
Drop-down list of history searches
Now, each time I want to search in Execution History I need to type keyword I want to find. It would be nice that it would be store last X searched keywords and it would be possible to select from drop-down menu those items
3 votes
- Don't see your idea?