230 results found
-
More control over join indents
In 4.0.53 I can't work out how to configure the formatting for a query to be...
SELECT
--column1
--column2
FROM
--table1
JOIN
--table2
----ON 1=1
----AND 2=2
JOIN
--table3etc
So basically only indenting the predicates not the keywords
3 votessee comments
-
Preserve the users cursor location when formatting is complete
When using the format selection command (or the entire document) the cursor position is reset to bottom of the document, instead of preserving the users cursor location. This is confusing as an end user. I'd like to recommend preservation of cursor location in the document.
3 votesThis issue is fixed in the latest build 4.0.72 of dbForge SQL Complete: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Support adding a numeric value next to new line or indent setting
Support adding a numeric value next to new line or indent setting so users could add 1-9 new lines or indents.
3 votes -
UPDATE and DELETE statement understanding table alias
When creating an UPDATE or DELETE statement and referencing a table alias. It cannot understand these. For example:
UPDATE A
SET ID = 5
FROM Table1 A
INNER JOIN Table2 B ON A.ID = B.IDSQLComplete does not understand the alias 'A' when writing the UPDATE or the SET statement.
3 votes -
3 votes
-
Oracle style formatting for SQL statements
It would be great if we could have the Oracle style SQL formatting option, where keywords are right justified and the arguments are left justified. Like below:
select col1, col2, col3
from dbo.tableName
where col2 = 1233 votes -
Refactoring: Change variable name in procedure
refactoring (change a variable name in a procedure for example, and have that change propagate throughout the procedure for each instance of the variable)
3 votesThe feature is available in SQL Complete v5.0!
-
Ability to change the keyboard shortcuts used in SQL Complete
Add the ability to modify the keyboard shortcuts used for certain SQL Complete features. Reason for requesting this is due to the fact that certain keyboard shortcuts chosen by SQL Complete may clash with shortcuts used by other third party tools.
In my case, the format selection shortcut, Ctrl+K, Ctrl+F is used in the SSMS Tools Pack add-in I have installed. So when I try to use Ctrl+K, Ctrl+F I get the SSMS Tools Pack resultant of the shortcut, and not the format selection option of SQL Complete.
3 votesThis is available in VS/SSMS 2012 or higher.
-
Intellisense for table definition should use INFORMATION_SCHEMA data.
It seems the current implementation parses a CREATE TABLE statement and only shows the columns defined there when you hover over a table name. Columns added later via ALTER TABLE statements do not show up. The intellisense list should be built by querying the CURRENT table structure via INFORMATION_SCHEMA.COLUMNS in order to show all columns.
3 votesPlease check that you have selected the ‘Automatically refresh suggestions cache’ and ‘Detect changes on a server before refreshing suggestions cache’ options in the ‘Text Editor → Code Completion → General’ section of the ‘Options’ dialog box that can be opened by selecting ‘Tools → Options’ from the main menu.
Please also check that the altered object belongs to the database selected in the ‘Database’ drop-down menu on the ‘SQL’ toolbar.
-
3 votes
-
JOIN FIELDS SUGGESTIONS - Enable TAB acceptance of first suggestion
When PRIMARY and FOREIGN KEYS share the SAME NAME according to best practises allow the JOIN suggestion to be immediatly pick up with TAB.
Most of the times the good suggestion comes at top on the list and one can allways navigate to a better one if this is the case3 votesThis can be achieved as follows:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘List Members’ branch in the ‘Options’ window.
3. Select the ‘Tab’ option.
4. Click ‘OK’. -
Add extended properties for columns in quick info window for table
When navigating the mouse cursor to a table, display extended properties in the quick info window.
3 votes -
Support temp tables in Intellisense
Make intellisense to cover the temporary table for example "#rs" ,"##table"
3 votes -
Intellisense doesn't work when using CROSS/OUTER APPLY of a user defined table-valued function
When filling in the parameters for the TVF and it has been CROSS/OUTER APPLY'd with a table, the intellisense does not show any of the fields from the table even though they are allowed in the TVF. Even if the parenthesis is closed on the TVF, the table's fields don't show up. The intellisense options that come up are the generic list of dbs, tables, functions, snippets, etc.
E.g. -
SELECT * FROM Users u
CROSS APPLY dbo.FindInvoiceFiles([INTELLISENSE DOESN'T SHOW FIELDS FROM Users table]) fif3 votes -
Fully qualified server reference
When performing a query like "Select * from Servername.schema.table"
where servername is the current server connected to, table hints are not available.
3 votes -
Add #temp support to the express addition
Adding limited support for auto SQL complete for column names to be read from #temp table in the express version
3 votes -
Fix capitalization for identifiers with underscores in them _
I spend most of my time working in databases that (unfortunately) use _ underscores to separate words. For example, a table might be called VehicleRidershipActivity instead of VehicleRidershipActivity. This causes the "Proper Case" option to not work on any of these table names, column names, sproc names, etc..
The worst part is that even if I type them correctly or paste them in when they were correct, they will get "corrected" to all lower-case letters after the first letter (for example VehicleRidershipActivity will be changed to Vehicleridershipactivity).
If this is intended, please consider changing.…
3 votes -
Synonyms Intellisense
Please provide Code Completion for Synonyms!
I have a development database where I created a synonym for every table and view in another database on another SQL server. When I use SQL Complete and type a SELECT statement for a synonym, column names do not appear.
Please modify SQLComplete to provide column names when crafting a SQL statement for a synonym!
Thanks!
3 votes -
warn when running a query with no predicate
if running an update/delete statement with no predicate on it, it would be nice if there was a warning to appear asking if I was sure I wanted to run the query.
it would prevent accidental deletion/update of a full table when I was only after one row and I forgot to include the predicate.
3 votes -
Functions on Result Window
After selected a column in the result window the possibility of some funcions on it:
- the min/max/avg of the column (if number)
- order the results by a column A-Z, Z-A
- filter the rows with a value
- ...3 votesThis feature is implemented in v5.8 excepting:
- order the results by a column A-Z, Z-AWe added a separate suggestion for this https://devart.uservoice.com/forums/87893-sql-complete/suggestions/33150733-order-the-results-by-a-column-a-z-z-a-in-result-w
- Don't see your idea?