309 results found
-
Add x blank line before and after as formatting options
I would like to have sometimes a blank line between segments of my SQL, for example before and after the UNION statements so it's easiter to see the different Select statements
1 vote -
SQL Complete (or at least formatter) for Firebird?
Could you expand the SQL syntax to allow SQL code formatting for Firebird SQL?
1 vote -
Execute current statement with variables
When running a query via "Execute Current Statement", it doesn't run if there are variables referenced. Instead you have to highlight the variable + query to get it to run. It would be nice if the variables were automatically included in the execution
1 vote -
Search in Unsaved file (from Document Sessions)
We currently have an ability to search through executed queries. It would be great to be able to search in unsaved (and saved as well) files which are available in Document sessions.
Here is a use case for this. Let say you wrote a script, but you only executed part of it. There is no way to find the full script in the Execution history even though the full file is available in Document Sessions. So you would have to active document sessions which may have a large number of files, but you need only one of them.
Ability to…
1 vote -
Combine views and tables in suggestion list as a single sorted list. Add a setting to enable this.
I would like to see the list of tables and views as a single sorted list in the suggestion list instead of tables then views. Add an option in Preferences to enable this feature for those who want it.
1 vote -
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 -
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
- Don't see your idea?