156 results found
-
Notifications pane
Currently SQL Complete notification (like "Uncommitted transaction" and "Query execution completed") show up and disappear. It would be great to have them on a panel similar to "Document Sessions", so you can review them later.
1 vote -
Full-Text Search Intellisense
Hi,
I found that full text search intellisense is not there in current version of sql complete, whenever i search for contain or other functions full text search related functions there are not coming in the list. It would be very help full if you can add this feature in next update of sql complete.
Rest if found anything new enhancements to be made will post.Thanks
Ravinder1 vote -
Set different default schema in individual query panes
Add the ability to work in a different schema as default from the user's default schema. This will facilitate easier working with schema-less scripting, in a database with multiple schemas with similar/identical table/view setup.
1 vote -
Add to formatter - Built-in Variable Case
In the formatting profiles, I would like built-in variables to be all-caps, while user variables left as declared
e.g. @MyVariable should stay as-is, but @@ROWCOUNT should be all-caps
1 vote -
1 vote
-
SQL file/tab comparison within SSMS
It would be great if you could do SQL file/tab comparison within SSMS.
1 vote -
Expand contect menu "Generate Script As" with an "As-Is" option.
This would enable easy execution of scripts generated by another script. Preferably with an extra "Execute in new tab" option.
I use this method very often to automate my DBA work. Now it's a 3-4 step procedure, this idea will make it into a one-step thing.1 vote -
Conditional Alias using the right letter case
In the Alias settings I can choose to use upper case, which is fine, but when I do, all my conditional aliases are also all upper case, I would prefer to keep the upper/lower casing that I specified in the condition/action cells
1 vote -
Comment out or remove extraneous commas to prevent a syntax error.
Comment out or remove extraneous commas to prevent a syntax error. Often when I remove several columns I forget to remove the comma on the preceding line.
Ex. A
SELECT a,
b,
FROM worktableEx. B
SELECT ,b
,c
FROM worktable1 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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
Extract to a function or a procedure
By selecting a portion of the code in a stored procedure, giving the ability to create a new stored procedure or function from that code.
All variables present in the selected code are automatically passed as parameters. The selected code is then replace by a call to the function/procedure
This will help to divide the code in sub function and been auto documented.
1 vote
- Don't see your idea?