272 results found
-
1 vote
-
Configure Order Code Completion by schema
Order code completion by schema. Currently it orders alphabetical by table name.
Lets say you have the following schema.tables :
main.fullfillmentaddress
staging.contactaddress
history.directrelatedaddressIf I type in the following
select * from address
(the code completion will suggest in this order):
staging.contactaddress
history.directrelatedaddress
main.fullfillmentaddressI'd prefer main to always be the first schema returned. Not a big deal when you only have a few tables but we have hundreds.
1 vote -
Display a single row of data in column format
As per Oracle SQL Developer ability to select a row of data and have it displayed in a column. Makes viewing a large row of data a lot easier.
1 vote -
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 -
Specify Schema Text Case
In my database named "IDS", I have a schema named "ids".
I would like to specify that the schema be lower case when formatting.This is what currently happens.
When I format something like this:
select * from IDS.ids.Location l;It is formatted to:
SELECT * FROM IDS.IDS.Location l;I would like to specify that the schema be lower case:
SELECT * FROM IDS.ids.Location l;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 -
intellisense for tablevalued CLR functions should behave similar to other tablevalued functions
with tablevalued CLR functions, SQLcomplete shows both output and input variables in the tip, making it hard to use the correct input variables.
instead the tip should only show input variables when you are typing input variables and output variables when you are in the select part, right now both input and output variables are suggested regardless of where you are typing, making it next to useless in aiding with the SQL typing.
I submitted this as a bug, but got the reply that this was by design, but with no explanation as to why they think this is a…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 -
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
- Don't see your idea?