275 results found
-
Allow for customizable indentation
Allow to specify code blocks that should be indented
For Example:
begin try
{indented code}
end try
begin catch
{indented code}
end catch7 votesThis feature has already been implemented. But it’s available only in Standard edition of SQL Complete.
Free edition has restricted formatting options. -
Intellisense on Temp Tables and Table Variables
Show the table columns in the Intellisense when you create temp tables or declare table variables.
29 votesVersion 3.0 is on the site
-
"Go to definition" feature for procedures, views, etc.
When there's a valid sql object under the cursor in the text editor, two nice features (via context menu):
- Go to definition (select in object explorer)
- Script object (clipboard, new window, etc...)
Also object names should be shown as a link if the Ctrl key in pressed. All object names in script shows as hyperlink. Ctrl+click or Ctrl+Enter on it opens the object definition in new tab.
33 votesVersion 3.0 is on the site
-
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
-
Import/Export options utility
it could be usefull an utility to import/export the options configured by the user.
1 voteIncluded into SQL Complete v2.50
-
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
- Don't see your idea?