272 results found
-
Show intellisense for stored procs located in Master database
Currently, Sql Complete doesn't show intellisense for procs in Master DB when the active connection is in a different database. These procedures are still runnable from any database, so it should still show intellisense. This should be enabled by default or at least have an option in settings.
0 votes -
Goto Definition (tabel) include field comments
When displaying Goto Definition of a table it would be nice to include the field comments.
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 -
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 -
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 -
SQL Complete (or at least formatter) for Firebird?
Could you expand the SQL syntax to allow SQL code formatting for Firebird SQL?
1 vote -
Have shared settings and snippets
We have a team of people and we'd like them to have one set of settings and snippets rather than having to keep multiple up to date.
8 votes -
Don't generate alias if an alias is already present.
For example if i wrote a query like this SQL Complete will generate alias "ch":
select * from crm.contacts_h chbut when I change table to contacts_d then I get additional "cd" alias generated, like this:
select * from crm.contacts_d cd ch
--
Regards1 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 -
Control of arithmetic operators
Along the lines of keeping function parameters on a single line, SQL Complete also needs to have some control over the treatment of arithmetic operators. For example:
SELECT
c1 + c2
/ c3 as Calculation
FROM t;most formatting packages will format by default as:
SELECT
c1 + c2 / c3 as Calculation
FROM t;Some of the more advanced packages will be able to specify what to do before/after each operator (usually whether to add a newline) but at the very least SQL Complete needs to be able to "gather" a calculation onto a single line.
1 vote -
Move Forward/Backwards Through Tabs as Displayed
There are a couple ways of doing this now in Visual Studio (Microsoft's own Productivity Power Tools 2012 is one), but none that work in SMSS. I would dearly love the ability, after custom-sorting my tabs, to be able to move forward and backwards through them in the displayed order.
Currently you can only move through your tabs in the order you last clicked on them -- similar to Alt-Tab in Windows -- but not necessarily in the order they appear visually. I'm thinking Firefox/Chrome/Internet Explorer-type "sensible" tab movement.
devart will be my eternal hero if SQL Complete had the…
3 votes -
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 -
Email Query (not results)
How about adding the ability to send the contents of the query window out in an email? It's a feature I've never seen in an add-in, but it's one that I'd use almost daily. Even better would be the ability to attach the query or just have the query as the email.
1 vote -
Intellisense/Completion for UDTs
User Defined Types seem to have no intellisense or completion. Hovering over them shows no information about them. SQL Complete does not offer to complete the field list when inserting into them.
This is extremely annoying. Please add intellisense and completion for UDTs!
13 votes
AdminDevart
(_, Devart)
responded
dbForge works with user types.
Could you please describe it in more detail?
-
Add option to include (NOLOCK) when auto-completing
Due to the nature of our data, we use NOLOCK on most of our queries. It would be useful for us to be able to automatically have (NOLOCK) included when part of a statement is auto-completed. It may be useful to have it so that this option can be turned on only in specific databases.
63 votes -
Include Snippets in Import and Export Settings
It would be great if there was an option to import/export snippets in the "SQL Complete->Import and Export Settings".
This way snippets could easily be shared between team members.
29 votes -
align equals
I like the option to align assignments in SELECT, UPDATE, etc, but I don't like that the alignment happens after the equals sign. It's much neater and easier to read when each column is aligned with an equals sign for the assignment.
(It's for this reason we use equals for column aliases rather than AS)
3 votes -
"Folding" queries
It would be interesting to be able to "fold" and "unfold" a query from a single line state (still showing the full query) to a multiline, formatted state.
The following query, for example,
| |
|+| SELECT * FROM SomeTable WHERE SomeField = 3.14;
| |would unfold to
| |
|- | SELECT
| | *
| | FROM
| | SomeTable
| | WHERE
| | SomeValue = 3.14;
| |and back.
28 votes -
54 votes
-
Sync edit in Highlight Occurences feature
SQL Complete (or SSMS) does a nice job of highlighting like words. Put the cursor on a table alias, and all occurences are highlighted for example.
Is it possible to edit all of these like Delphi's Sync Edit feature? Sometimes I would like to edit all occurrences and other times, just those in the highlighted text.
3 votes
- Don't see your idea?