231 results found
-
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 -
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 -
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$’
-
Bug: Line breaks removed before comments
New lines are removed between a parentheses or a comma and a comment.
see sample below.
Select * From(
Select 1 a,
--comment after comma - rows above removed 2 t --comment after field - rows above not removed , --sdf 3 g) /*comment after parentheses - rows above not removed*/ a
5 votes> New lines are removed between a parentheses or a comma and a comment.
> see sample below.
> Select * From(
> Select 1 a
> ,
> —comment after comma – rows above removedThis issue is fixed in the latest build 4.0.78: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
> 2 t
> —comment after field – rows above not removed
> ,
> —sdfThis issue is fixed in the latest build 4.0.78.
> 3 g)
> /comment after parentheses – rows above not removed/
> aSuch behavior is currently by design. Though, you can carry this issue over to a new suggestion.
-
Geography / Geometry Suggestions
Add support equivalent to the XML suggestion capabilities, but for the Geography and Geometry data types.
5 votes -
Code formatting for Merge Into "Values"
Merge doesn't have formatting for source table formed from values.
MERGE INTO [TargetTable] AS T USING (
VALUES (@UserId, @InternalId)) AS S
([UserId], [InternalId])
ON T.[UserId] = S.[UserId]
WHEN MATCHED ...5 votes -
4 votes
SQL Complete v2.0 is on site!
-
ctrl-space on built in function params should not cause hangs
If I enter ...
select replace(
and then I type ctrl-space (ie. give me the params available) Server Studio hangs.4 votes -
Snippets should commit on space/tab
Snippets are only committed when I press Enter, but I use space/tab much more often.
4 votesWe’ve added snippet commit on tab.
Automatic snippet expand on space seems dubious to us.
- Don't see your idea?