230 results found
-
9 votes
Version 3.0 is on the site
-
A handy feature would be to show a live preview of formatting in the options page.
When selecting the various code formatting options it would be very useful to be able to see the effect in real time of the selections on a sample piece of code. Having to make selections, then close the options and Format the code, then go back and tweak is a bit of a pain.
2 votes -
qualify names in a sentence, ussing alias (if present) or table name
qualify names in a sentence, ussing alias (if present) or table name
2 votesThis feature is already implemented in SQL Complete 2.0 (Standard edition)
-
sql complete hangs when there are many procedures
Two ideas here:
1. Limit the suggestion list (entry in options dialog - "Max count suggestions"
2. Loading details could be async3 votes -
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 -
Add a feature to "Run current statement"
The keyboard shortcut to run Execute statement in query editor is F5. If we have multiple queries in the same query editor window, all the query will be executed, unless we first highlight the part of query that we want to execute, and then pressing F5.
I'm suggesting that instead of selecting the statement (usually by using a mouse movement) and pressing F5, we can just put the cursor anywhere in the statement that we want to run, and then pressing keyboard shortcut (something like ctrl+F5) will run the "current statement" which is the text between the first "newline +…
14 votesVersion 3.0 is on the site
-
Include Schema
Can database schema be included (optionally) in the intellisense object name selection? e.g. [dbo].[tablename] ?
(the square brackets also being optional)11 votesVersion 3.0 is on the site
-
Highlight all occurrences of selected word
Highlight all occurrences of a selected word in the current document.
20 votesVersion 3.0 is on the site
-
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
-
Add shortcut ctrl + k + d like Visual Studio
Add shortcut ctrl + k + d like Visual Studio for format document
9 votesSQL Complete v2.0 is on site!
-
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!
-
Intellisense & Format is not working in Stored Procedures
Intellisense & Formating is not working in Stored Procedures
11 votesSQL Complete v2.0 is on site!
- Don't see your idea?