278 results found
-
Quickinfo for Objects
It would be great to have a quick information about the object(structure). For example if you type select * from [mytable], then move with the mouse over [mytable], a small window should appear with all columns + datatypes, default values etc.
6 votesIncluded into SQL Complete v2.50
-
Option not to add space after function name before parenthesis
Original:
select sum(abs(i)) from dummy
After formating:
SELECT sum (abs (i)) FROM dummy
Optimal:
SELECT sum(abs(i)) FROM dummy6 votesIncluded into SQL Complete v2.50
-
6 votes
-
Product Update Manager Improvements
It should offer to close SSMS, wait for the save dialog to exit and launch the update.
Or if that can't be done, it should at least launch explorer with the file highlighted after download.
6 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 -
Put ON at top of suggestion list when using JOIN
When typing inner join table1, make the ON keyword display at the top of the suggestion list
6 votes -
Respect case of declared variables
I have text case for variables set to "do not change", because none of the other options match my rules exactly (e.g. I want "RecordID" not "RecordId").
The problem is that if I declare a variable (or it is an input param to a stored proc), subsequent formatting doesn't respect the casing of the variable as it was declared.
For example:
DECLARE @RecordID int
SET @recordid = 5
Ctrl-K, Ctrl-D should change it to
SET @RecordID = 5
but it does not
6 votes -
6 votes
-
Show column sizes in addition to type when hovering cursor over column names
When hovering cursor over column names, it would be nice to show column data types including sizes.
Currently SQLComplete just shows "myalias.columnName(Column)" when hovering, but it would be good to show "columnName (Type, Size)"6 votes -
Case statement in select clause - using table view
Select
c.FirstName
,ln = c.LastName
,e.JobTitle
,d =
Case
When a.AddressLine1 = 1 Then 1
End
,a.City As ct
,a.PostalCode6 votes -
format selection by a profile I select
I'd like to select some code, right click, and have menu choices to match my profiles such as:
Format Selection Horizontal (tight)
Format Selection Vertical (spacious)6 votes -
Indent table after FROM
Treat FROM and JOIN as equals be able to indent table names ex:
FROMTableA
JOIN
TableB6 votes -
Implement code formatting for Merge statements
Currently, the SQL Formatter has absolutely no options for Merge statements, and they are not formatted very nicely at all.
Please provide options for formatting all the aspects of Merge statements:
- Using section
- WHEN MATCHED section
- WHEN NOT MATCHED sections
- Output sections
Also, if possible, provide the option to have these sections use the same formatting as standard statements. E.g. Update statement in When Matched section uses standard update format, etc.
6 votesThis feature is implemented in dbForge SQL Complete, v4.8 http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
mark opening or closing brackets when another is selected
sql complete doesn't mark openning brackets when closing is selected etc. it's working in SSMS but, when i install sql complete it doesnt'.
6 votes -
Options group for logical operation enclosed in braces
Add an option group to the formatting profile for the logical operation enclosed in braces. This option group should include the following options:
Line break before opening brace
Line break after opening brace
Line break before closing brace
Line break after closing brace
Indent braces
Indent logical operation
Format braces around single comparison operation as in logical operationsAlso, make the same options group for the following predicates:
- EXISTS
- ALL
- ANY
- SOMEFor details, please the Devart forums http://forums.devart.com/viewtopic.php?f=33&t=35030
6 votes -
Suggest JOIN expressions and conditions
1 In SELECT statement after user types JOIN suggest full clause basing on table foreign keys.
2. When user types JOIN condition after ON suggest conditions table basing on table foreign keys and matched column names.5 votes -
List members for CTEs
List members for common table expressions
5 votesIncluded into SQL Complete v2.50
-
Different (or customizable) alias generation
For table name, for example, 'tMoneyCashOrder', auto-alias should be like 'tMCO'
5 votesThis feature is already implemented in SQL Complete 2.0
-
Highlight the BEGIN/END ?
Highlight the BEGIN/END ?
5 votes -
After the 'LIKE'
To have an option to on-off and when it is on -
when the keyword 'LIKE' is typed or selected, put the 2 percentage signs sorrounded by single quotes and keep the cursor in between.
Ex:
Select * from t where FirstName Like '%%'5 votesYou can create a snippet wit the Snippets Manager filling in its fields as follows:
Shortcut: like
Description: LIKE ‘$CARET$’
Text: LIKE ‘$CARET$’
- Don't see your idea?