280 results found
-
Ability to change the keyboard shortcuts used in SQL Complete
Add the ability to modify the keyboard shortcuts used for certain SQL Complete features. Reason for requesting this is due to the fact that certain keyboard shortcuts chosen by SQL Complete may clash with shortcuts used by other third party tools.
In my case, the format selection shortcut, Ctrl+K, Ctrl+F is used in the SSMS Tools Pack add-in I have installed. So when I try to use Ctrl+K, Ctrl+F I get the SSMS Tools Pack resultant of the shortcut, and not the format selection option of SQL Complete.
3 votesThis is available in VS/SSMS 2012 or higher.
-
Indent table after FROM
Treat FROM and JOIN as equals be able to indent table names ex:
FROMTableA
JOIN
TableB6 votes -
CrLf after last GO
I'm always adding to batches and no blank line at EOF frustrates the heck out of me.
4 votes -
Extend Highlight Occurences feature to INSERT SELECT construction
You have a very convenient feature Highlight Occurences to highlight all field or variable occurrences.
I would suggest you to make a highlighting of the corresponding value in the INSERT SELECT construction when navigating to a field.
In the following example, when navigating to the 3rd column, the corresponding value should be highlighted in the SELECT clause too:
INSERT INTO table (clm1, clm2, clm3, clm4, clm5)
SELECT 0, 1, 5, 0, 311 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 -
Refactoring: Change variable name in procedure
refactoring (change a variable name in a procedure for example, and have that change propagate throughout the procedure for each instance of the variable)
3 votesThe feature is available in SQL Complete v5.0!
-
Oracle style formatting for SQL statements
It would be great if we could have the Oracle style SQL formatting option, where keywords are right justified and the arguments are left justified. Like below:
select col1, col2, col3
from dbo.tableName
where col2 = 1233 votes -
3 votes
-
Search the grid results pane
SSMS Tools Pack has a feature where you can right click on the results pane and click 'Search Grid Results'. Then you can enter some text and it'll find data in the results that match your search term. This is VERY handy.
11 votes -
Support INSERT/UPDATE statements within MERGE statement
Provide the column list for the INSERT/UPDATEs within the MERGE statement.
18 votesThis feature is implemented in dbForge SQL Complete, v4.8 http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
If the word I manually type matches an autocomplete entry, apply the case in the AutoComplete to the typed word.
If the word I manually type matches an AutoComplete entry, apply the case in the AutoComplete to the typed word. This would apply to both reserved words and object names.
Example 1: I type 'sel' and wait a millisecond. 'SELECT' appears in the AutoComplete. I press [space] and SELECT is typed for me. Next, I type 'select' and press [space] without waiting. The word remains lower case.
Example 2:I type 'select * from peo' and wait a millisecond. 'People' (a table name) appears in the AutoComplete. I press [space] and 'People' is typed for me. Next, I type I type…
1 vote -
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!
-
Ability to select different formatting for alias and schema
The only deal breaker is the inability to generate upper case table alias, without also making all schemas uppercase.
18 votesThis is governed by the option ‘Generate aliases in UPPER case’ that is in the ‘Alias’ branch of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).
-
Allow user to disable automatic close parenthesis functionality
At some point SQL Complete was modified to automatically close parenthesis when writing functions. When I type 'sum(' the close paren is automatically added and the cursor placed within the parens. This forces me to resort to using the arrow keys when I am done supplying the function's arguments. I don't type with arrow keys, and would like the ability to disable this functionality.
1 voteThere is a setting ‘Add parentheses when inserting function’.
-
Add a lowercase option in the SQL Formatter
Redgate has this, infact many of the online SQL formatters give you the option to have keywords, etc as lowercase, capital or uppercase.
Your product is reasonably priced against redgate.
But it's unusable if it makes all my keywords uppercase.
Thanks,
Jason1 voteThis can be setup as follows:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select the active profile.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Expand the ‘Text Case’ node.
6. Expand the appropriate subnode and select the ‘Lower’ radio button. -
Need ability to give intelliSense for store procedure parameter
I am big fan of this SQL Complete tool, it is really a good tool to help develop or build sql blocks. But one thing i notice that, currently sql complete is not providing intellisense for store procedure parameter. if it is providing this thing also than its really help full while building store procedure.
1 vote -
Suggestion: Option to switch between select format styles
Here is a suggestion to allow the formatter (to be set to and) to automatically change the formats of declaring a field name and its definition.
i.e.
Style 1: select [field1] = a+b
Style 2: select a+b [field1]
Style 3: select a+b as [field1]23 votesA possibility to switch between formatting styles is added.
-
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 -
INSERT: Stack values on a row basis
It would be nice if INSERTs could have the VALUES stacked on a row basis. E.g.:
INSERT table (col1, col2)
VALUES (''val1", 2)
, (''val3", 4)
, (''val5", 6)4 votes -
Tag block of code to exclude from or use different formatting
Allow adding special tags as comments before a block of code (begin - end) to exclude it from being formatted (just indent the whole section together to proper indent level), or perhaps to signal to use a different formatting profile.
i.e. /format exclude/ or /format profile 2/
8 votesWe would like to let you know that we have released dbForge SQL Complete, v4.5.167 Beta where the ‘Do not format tag’ feature is implemented http://www.devart.com/dbforge/sql/sqlcomplete/download.html
Please see the following examples:
- noformatendnoformat
SELECT a.AbsenceCode, a.Code FROM Absence a
-— noformat
SELECT a.AbsenceCode, a.Code FROM Absence a
/* endnoformat *//* noformat /
SELECT a.AbsenceCode, a.Code FROM Absence a
/ endnoformat *//* noformat */
SELECT a.AbsenceCode, a.Code FROM Absence a
— endnoformatWe will be looking forward to you feedback on the new feature.
- Don't see your idea?