231 results found
-
Provide quick access to the object definition SQL
E.g. by implementing the command that opens object definition in the new document.
124 votes -
Provide a global rename option of and alias
Have the ability to right-click or hover over an alias and be able to choose "Rename". By renaming the alias in one place it would automatically rename all other references to the alias in the query.
For example: I create a table and it get aliased as r1. I then rename it to rnk, which would change the loin reference to rnk right away.
75 votesThe feature is implemented in SQL Complete v4.7.
-
Ability to re-open tabs after reboot or after closing SSMS
A really cool addition to Sql Complete would be the ability to re-open tabs after a reboot or even after just closing SSMS.
If you look at good quality text editors such as UltraEdit or even browsers such as Chrome & Firefox, they have the ability to remember which tabs were open.
64 votes -
Save Execution History
Save a history of your executed SQL statements and allow you to search that history.
Also save the current session so when you open SSMS you can click a button to open all the queries you has open when you last closed SSMS.
55 votes -
Ability to expand columns when typing UPDATE statements (similar to INSERT)
- Let's assume we have a table:
CREATE TABLE dbo.Employee
(
EmployeeID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
IsMainWorkPlace BIT NOT NULL,
TabelNumber VARCHAR(6) NULL,
PersonID INT NOT NULL,
DepartmentUID UNIQUEIDENTIFIER NOT NULL,
DateIn DATETIME NOT NULL,
DateOut DATETIME NULL,
IsLabourUnionMember BIT NOT NULL,
FiringReasonID INT NULL
)- Let's type the following construction and click TAB at the end:
UPDATE dbo.Employee
- Suggest to expand columns just like it's implemented for INSERT:
UPDATE dbo.Employee
SET
IsMainWorkPlace = DEFAULT /* IsMainWorkPlace - BIT NOT NULL /
, TabelNumber = '' / TabelNumber - VARCHAR(6) /
, PersonID = 0 / PersonID - INT…46 votesMeet the feature in SQL Complete v5.0!
-
Custom Alias Map - Tell SQL Complete to always use a specific alias for specific table
I have a table (ObjectReference) and Sql Complete maps it to or1. I understand why it adds the 1 to avoid using the "or" keyword, but it would be nice to set up Sql Complete to use a more friendly keyword.
One solution for this would be to allow me to map table names to alliases. Then, any time ObjectRerence is used, it would get oRef (or whatever) from the map.
44 votesTry out the feature in SQL Complete v5.0!
-
Extended Outline - Custom Collapsable Regions (like C#) with Comments
Introduce Regions like #region in C# for collapsable sections. This regions should have a "name" or comment and should be displayed in document outline for navigation. This has lot of benefits in large sql code files for better orientation and navigation.
41 votes -
Increase indentation in WHERE with nested OR clauses
In the case where you have a nested (parenthesized) condition, increase the indention after the new line.
How it currently operates:
SELECT *
FROM MyTable
WHERE
(a=1
OR b=2
OR d=5)
AND c=3This doesn't really convey the fact that this is a subexpression, and it requires tracing the parenthesis with more complex queries. Something like this would be better:
SELECT *
FROM MyTable
WHERE
(a=1
OR d=5
OR b=2)
AND c=3So for each parenthesis level with a different logical operator than the previous level (to help prevent over-indenting when parenthesis are applied too liberally), increase the indention level…
35 votesPlease have a look at the latest build of SQL Complete.
-
Installer - Give option to ignore message about running applications
Everytime I upgrade, the installer forces me to exit Visual Studio. However, I only install SQL Complete for Management Studio. Please give me an option to ignore that error message
35 votes -
When autocompleting a column or table name, automatically put brackets around SQL keywords
When autocompleting a column or table name, if the name is a SQL keyword, automatically place the brackets around the name. For example, the query "SELECT Version FROM Table" is currently auto-corrected to "SELECT VERSION FROM TABLE", which causes an error.
Instead, it would be nice if SQL Complete auto-corrected to "SELECT [Version] FROM [Table]".
34 votes -
Support SSMS 2016
Support SSMS 2016 CTP
33 votes -
"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
-
Format table and field names to be consistent with the database letter case
When formatting a statement:
SELECT sometable.fieldname AS something FROM sometable
SQL Complete KNOWS the proper case of the table and field names (as it allows you to autocomplete them as you're typing it in). So, why doesn't it alter the case of them once they're already in the statement?
If the table was actually SomeTable in the database, and the field was called FieldName, the "format" function should fix the statement like so:
SELECT SomeTable.Fieldname AS something FROM SomeTable
32 votes -
Allow Table Aliases to be Uppercase without affecting the Table/View name case
I tried changing the Identifier to Uppercase to try to get the Table aliases to be uppercase but that made the tablename uppercase as well.
30 votesTry dbForge SQL Complete v.4.5 beta!
-
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
-
Options -> Settings -> Qualify column name -> **enclose with []
It would be a nice feature if you can add to database, schema and table brackets []. If you use certain characters like $ you have to enclose it with [].
28 votesIt’s implemented in the latest build of SQL Complete. Have a look at the “Enclose identifiers within square brackets” option.
-
27 votes
-
Make Format Selection to format what is actually selected
the format selection does expand the actual selection. Sometimes this is nice as it expands to include other bits that should have been selected but haven't other times it selects more than I want formatted. I think it should really only format what I actually select. Perhaps another option for format selection and related could be added too?
26 votesTry SQL Complete 4.5 beta!
-
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.
-
Separate formatting for subquery
It would be very nice to have options for separate formatting for subquery, for example:
SELECT
OrderID,
OrderName,
OrderDate
FROM Orders
WHERE ClientID = (SELECT ClientID FROM Clients WHERE ClientCode = 'ABC')Here, I need the main SELECT to be stacked and formatted appropriately, and subquery SELECT - to be wrapped and in one line).
In large and complex SQL script this feature is invaluable.
Currently it is not possible - one format is applied for everything.
Thanks.
24 votes
- Don't see your idea?