280 results found
-
Option to put commas at beginning of line rather than end
For example:
SELECT Col1
, Col2
, Col3etc.
17 votesIncluded into SQL Complete v2.50
-
Right Align of keywords
Right alignment of keywords is an important formatting option.
25 votesThere is the ‘Right aligned’ profile added in the formatting profiles.
-
11 votes
-
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
-
Prevent SQL Complete Locking SSMS
When you paste a large query containing lots of UNION statements, SQLComplete consumes all available CPU (one logical cpu only) and RAM and SSMS has to be killed to recover. I can email a sample query if required.
3 votesWe have fixed this problem. The new build is on site.
-
List all columns of a table when typing an insert statement
When you type "insert into mytable(", the autocomplete list should contain for example a star character on top, which adds all columns of the given table. So there's no need to select every column separately.
It would also make sense in select statements, when the alias is known.
13 votesIncluded into SQL Complete v2.50
-
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
-
11 votes
Included into SQL Complete v2.50
-
Option to not automatically format document when opening a stored procedure.
When opening a complex stored procedure script, Management Studio hangs, because SQL Complete(v1.0.57) is trying to format the script.When disabling SQL Complete, the stored procedure is opening in less than 5 seconds.
3 votesFix will be included in the next build.
-
4 votes
SQL Complete v2.0 is on site!
-
Disable theme colours or change to default colours in suggestion whindow
Hi! I have this theme applied to SQL Management Studio https://gist.github.com/605296 (http://studiostyl.es/schemes/jon-erickson-s-ragnarok-grey) but when the suggestion window appear is impossible to read some colours in the white background
3 votesWill be included in the next build.
-
11 votes
Version 3.0 is on the site
-
List members for CTEs
List members for common table expressions
5 votesIncluded into SQL Complete v2.50
-
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 -
Automatic table alias generation
In FROM clause of SELECT statement automatically generate table alias when table selected from drop-down list.
2 votesSQL Complete v2.0 is on site!
-
Suggest keywords by relevance
When suggesting keywords place more relevant to this context to the top of the list.
1 voteSQL Complete v2.0 is on site!
-
Datepart parameter inside DATEDIFF function adds parentheses
When using the DATEDIFF function for example, the first parameter is a datepart (year, month, day, etc). The code completion for that parameter always adds parentheses after the datepart - e.g. DATEDIFF(YEAR(), Start, End). Is it possible to turn off the addition of the parentheses to the datepart inside a function that has datepart as a parameter?
0 votes -
0 votes
SQL Complete v2.0 is on site!
-
0 votes
-
0 votes
SQL Complete v2.0 is on site!
- Don't see your idea?