275 results found
-
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.
-
Provide an option to specify leading or trailing commas in SELECT field list
Provide a setting to choose how fields will be inserted into code when hitting tab to change SELECT table.* to table.field1...
Currently it does:
table.field1,
table.field2,
table.field3
It would be nice if it could do
table.field1
, table.field2
, table.field38 votes -
9 votes
-
Bug: Stack table view doesn't apply to variable assignments
see sample code below
Select
@Variable1 = d
,@Var2 = dsfdasf
From
#data1 vote -
Bug: Line breaks removed before comments
New lines are removed between a parentheses or a comma and a comment.
see sample below.
Select * From(
Select 1 a,
--comment after comma - rows above removed 2 t --comment after field - rows above not removed , --sdf 3 g) /*comment after parentheses - rows above not removed*/ a
5 votes> New lines are removed between a parentheses or a comma and a comment.
> see sample below.
> Select * From(
> Select 1 a
> ,
> —comment after comma – rows above removedThis issue is fixed in the latest build 4.0.78: http://www.devart.com/dbforge/sql/sqlcomplete/download.html
> 2 t
> —comment after field – rows above not removed
> ,
> —sdfThis issue is fixed in the latest build 4.0.78.
> 3 g)
> /comment after parentheses – rows above not removed/
> aSuch behavior is currently by design. Though, you can carry this issue over to a new suggestion.
-
Case statement in select clause - using table view
Select
c.FirstName
,ln = c.LastName
,e.JobTitle
,d =
Case
When a.AddressLine1 = 1 Then 1
End
,a.City As ct
,a.PostalCode6 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!
-
UPDATE and DELETE statement understanding table alias
When creating an UPDATE or DELETE statement and referencing a table alias. It cannot understand these. For example:
UPDATE A
SET ID = 5
FROM Table1 A
INNER JOIN Table2 B ON A.ID = B.IDSQLComplete does not understand the alias 'A' when writing the UPDATE or the SET statement.
3 votes
- Don't see your idea?