270 results found
-
group by formatting
replace "indent GROUP BY Phrase" with 2 options:
1) "Indent GROUP BY Keyword"
2) "Indent GROUP BY columns"the current options will now allow for formatting flexibility as it does for the where keyword/condition
1 vote -
Add IntelliSense for more linked server types
Currently SQL Complete only provides IntelliSense for linked servers with the server type of SQL Server. Please add support for other linked server types, such as Oracle, generic OLE DB, etc.
1 vote -
1 vote
-
Add an option to group database entities by schema rather than flat alphabetical.
Add an option to group database entities (tables, views, stored procedures, etc.) by schema rather than flat alphabetical. Click +/- sign to expand or collapse schemas.
1 vote -
Formatting for: Create Type <name> as table
Currently, Create Type <name> as table (
doesn't use any formatting rules.
Can we have this use the same rules as CREATE TABLE?1 vote -
add missing column alias to the select portion of insert statements
Those that came before me had a habit of not adding these and it becomes a pain point when debugging.
--ex of how it looks like now
INSERT INTO desttable
(
id
,name
,phone
)
SELECT
code AS id
,user
,tel
FROM origintable--what I would like the addon to do
INSERT INTO desttable
(
id
,name
,phone
)
SELECT
code AS id
,user AS name
,tel AS phone
FROM origintable1 vote -
Add 'BEGIN TRAN' and 'ROLLBACK TRAN' to the suggestions list
The suggestions list already has 'BEGIN' and 'ROLLBACK' but does not have 'BEGIN TRAN' and 'ROLLBACK TRAN'. I use these a lot and it would be great if they were added.
1 vote -
Simplify snippet editing with variables
SQL Prompt allows quick editing of snippets by typing a variable name wrapped in dollar signs and automatically adds this to the bottom list of variables to edit. This makes editing a snippet very easy, and doesn't require as many steps as the current SQL complete UI for adding custom variables. Consider evaluating using this type of simplified editing experience.
1 vote -
Format: line break before From, Where, group by & Order by
You already allow a line break before FROM.
Allows me to specify the number of line breaks.
in my case i wish to use 2 line breaks after the select list
i.e.SELECT
Column1
, Column2
, Column3FROM
SampleTable AS STWHERE
ST.Column1 > 11 vote -
add a "edit data from query"
Add a "edit data from query", on the left click, in the query editor, to open the same module as when "Edit top 200 rows" in the table list is selected.
1 vote -
format section after press tab to complete
when typing an insert statement (as an example), I get the prompt to "Press Tab to paste full INSERT statement". After pressing tab, SQL Complete will put the insert statement in there to the formatting rules specified.
There are situations where I do that and the insert statement is tabbed over to the right but the full statement pasted is over to the left. Could SQL Complete format it so that the paste is formatted where it should be? It would save me a format document request!
1 vote -
Go To Definition should open a connection if one is not already open
Currently you get an error if the Object Explorer is not connected to the same server. Seems like SQL Complete could make that connection for us and save that step.
1 vote -
SELECT Results Generate INSERTS INTO Temp Table / Table Variable
How about a feature which would take a SELECT result, declare a Temp Table / Table Variable based on the schema of the result, and generate INSERT INTO statements?
I do this often when comparing data across disparate systems where the source data is scripted into a table variable to be compared in the destination system. I use a combination of CONCATs and a WHILE loop to handle the need for a trailing comma (if using VALUE), or trailing UNION if using SELECTs as insert into source.
1 vote -
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
- Don't see your idea?