313 results found
-
collapse blocks to definitions
hi, I work with MS SQL Managemenet System and a lot of *.sql files for updating databases
to my specific file can have a lot of lines of code (up to 1000 lines) and navigation and reading becomes tragic - I always manually collapse (press on [-] next to block name) all blocks like CREATE PROCEDURE, CREATE FUNCTION
I really love your SQL Document Outline feature
so you can handle another feature 'Collapse all blocks to definition' and simplify the life of a lot of db coders
Will be glad to be among your clients
Thank you and good luck,…3 votes -
Filter formatting options based on selection
This would likely have to wait until the live preview is implemented http://devart.uservoice.com/forums/87893-sql-complete/suggestions/1434717-a-handy-feature-would-be-to-show-a-live-preview-of
It would be awesome if there was a way with the live preview for the UI to indicate which options affected a given line. So, for instance, you click on one of the conditions in the WHERE clause, and it indicates that the 'New Line Before', 'Indent Clauses', and 'Word Wrap' options all contributed to how this line looks. That way if, for instance, the formatter is placing the 'AND' statement after the condition rather than before as you would prefer, the many options would be filtered…
1 vote -
Word Wrap SELECT list only
Currently there is an option in the Code Formatter to word wrap code if it exceeds the right column margin, but that isn't ideal for the instance where you want an individual clause in the WHERE statement to stay on a single line no matter how long they are (makes it clearer what the exact logic is). Disabling this, though, forces all of the columns in the SELECT list to be on one line (I have stacking disabled for the fields). I'd say it is a common enough convention to warrant a special flag just for word-wrapping the columns in…
11 votes -
Hide other databases from suggestions
An option to not suggest other databases while populating the suggestion dropdown would be nice. In our system, we have discrete databases for each client, and so our development machines have hundreds of databases on them. When attempting to type a table name, it is not uncommon for SQL Complete to suggest a database name that matches the abbreviation, but for our use case this will never be ideal (queries are basically never ran across databases, and when they are we can deal with having to manually type out the database name).
At the very least, I think it would…
2 votes -
Include underscore in CamelCase interpolation
In our schema, we have the unfortunate convention (if you can call it that...) of including underscores in many table and sproc names. For instance, a report sproc might be named ReportSalesByChannel. It would be awesome if the CamelCase interpretation either completely ignored the underscores in the name while providing the suggestions (so typing rsbc would suggest the above named report), or make it so the _ is one of the interpreted characters, which would allow rsbc to again suggest the above sproc. Right now any stored procedure with an underscore cannot be quickly suggested by any abbreviation…
12 votes -
More estetics, more light
A) connection identification
a.1. paint background on crc24 of @@servername\db_name() with alfha at 15-20%
a.2. allow a logo on right-bottom from local file or table.field of current connectionB) if I have mySAP's 18.000 objects....
b.1. allow completition ondemand on key (TAB) with rotation searching:
objs: tblarc1, tblarc2, ...
select * from arc{1°TAB} -> tblarc1 {2°TAB} -> tblarc2
(can rotate or use SHIFT+TAB to go back)
b.2 show tooltip with complete list of fields when mouseon obj/sp/fn/etc. identifier (of course the info gathering come from a separated thread or stop if mouse exit from tooltip area)…
1 vote -
Highlight Unused Variables
Declare @var1 INT, @var2 INT
SELECT @var1 = 1, @var2 = 2
SELECT @var1 [@var1]
-- @var2 should be highlighted in the declaration since its assigned value is never used.128 votes -
Alias comprise of the first two letters of table name
Would it be possible to add an option allowing for the alias to comprise of the first two letters of the table name rather than the first, for example:
dbo.position po
dbo.product pr6 votes -
Do Api command lines
To do Api command lines to execute the rules of the SQL Complete in a batch process. Also provide Api command lines give the possibility to create a javascript process to run a task each 2 hours (for example) in the repository of the sp's (for instance). If there is an error an e-mail will be sent to responsible of that sp
6 votes -
Mark cells in results panel
I want to be able to mark cells in the results panel. I often have SSMS open on one screen, and some spreadsheet or notepad open on another. I can select the cells, but then that selection is no longer visible once I go to the other window. I should be able to change the background color or a cell in the results pane by right clicking, and/or keyboard command.
3 votes -
Implement ability to show objects in completion list only for specific databases
It would be nice to have an option to limit intellisense to either 1) the currently selected database or 2) a pre-defined set of databases. That way I don't have irrelevant database object names showing up in the intellisense pop-up.
1 vote -
Few more features
- After where or any other keyword, add a space
- If there is a list of suggestions (ex. for a field name, user should be able to select the last item by the down arrow)
- When one bracket is put, complete the other bracket and bring the cursor point to the middle
The same suggestion as above for the Begin - End (Also the Begin isn't auto complete)
1 vote -
When hovering over SP, display whether it has default values or not
Is it possible that when i hover over an SP, that i see if the parameters have default values or not?
1 vote -
Integrate with CodeCompare Free/Pro
Permitir comparar dos archivos o más objetos por selección; de bases de datos diferentes o de servidores diferentes.
9 votes -
Ident guide lines
Visualize the ident guide lines in the document.
4 votes -
Easy goto definition and graphical position of errors and search
Similar to power tools for visual studio 2010: Pressing Ctrl + Click to go to the definition of the element. Also implement the sidebar where you graphically visualize the position of the matching elements and code errors.
6 votes -
Add vertical scroll bar to 'Quick object info' hint
Add vertical scroll bar to 'Quick object info' hint to make it possible to view the complete list of the table columns (table with more than 60 fields).
23 votes -
Checkbox next to fields in the Table Fields Pop-Up
- Click the checkbox of multiple fields of table joins when the table field pop-up is visible. 2. Auto create the field listing (with alias) in order of clicked when the pop-up is closed/dismissed.
1 vote -
Improve "Execute current statement"
The current statement is not executed when it is commented out.
If i have the following query and attempt to execute it, SSMS says "Command(s) completed successfully.". The query is not actually executed.
-- select * from table11 vote -
Automatic Formatting of "TableName.Value AS Alias"
If you have a field name "Value" then automatic formatting mis-interprets this if it has an alias.
Formatting:
SELECT TableName.Value AS Alias
FROM TableNameBecomes:
SELECT TableName.Valueas Alias
FROM TableNameInstead of
SELECT TableName.[Value] AS Alias
FROM TableName1 vote
- Don't see your idea?