272 results found
-
Remove debug stamp in Releases (keep it for your Debug versions only or verbose mode)
Steps to reproduce:
- run app DebugView
- work with SQL Complete for sometime in SSMS
- keep watching DebugView until you'll see lots of debug messages generated by SQLCompleteExpected: no debug messages in Release binaries
Actual: there are debug messagesPlease chekc all other products for this.
1 vote
AdminDevart
(_, Devart)
responded
We will fix it in one of the next product builds.
-
Allow the 'on' clause to be aligned with the JOIN clause
"Support" was of no assistance, but I'd like to have my 'On' clause aligned with the join clause, but it's not possible:
from
[ExtendedEvents].[Events] ee -- on new line
join
OtherTable
on -- inline with JOIN
OtherTable.[ID] = ee.[ID]
where1 voteAdminDevart
(_, Devart)
responded
This 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 and click the ‘Open Selected…’ button.
4. Navigate to the ‘SELECT → FROM → JOIN’s’ section.
5. Unselect the ‘Indent ON keyword by 4 columns’ option. -
In 'where' clause align the conditions to allow easier column selection
"Support" were or no assistance. I'd like to align the where clause so that I can column select the conditions, bu aligning the logical operators with the where clause:
where
[collectionid] > 5396 -- alignment
and [sessionid] = 114 -- alignmentcurrently the code gets formatted as:
where
[collectionid] > 5396 -- alignment
and [sessionid] = 114 -- alignment1 vote
AdminPMs
(Admin, Devart)
responded
Could you please provide us screenshots of the actual and expected results along with the script?
-
code completion not working when db is offline
when db is offline during ssms startup - it won't get code completion.
you have to bring it online and restart ssms1 voteAdminDevart
(_, Devart)
responded
Could you please clarify if it does not work only for offline databases or for each database on the server?
A video or screenshots would be also of help.
-
DO NOT SHOW intellisense popup after "," typed and SHOW after ENTER pressed
Guys,
The main idea is following:
When people enumerate column names between SELECT...FROM most of them can be separated on two behavioral groups:
1) People who enumerates columns on a single line
2) People who enumerates columns on a new line each.
Both of these goups after previous, already typed, column name and before typing next type "," (comma) first and then " " (space - first group of people) or ENTER (second group).
No one type next column name immidiately after comma.
So really intellisense popup needed after SPACE or ENTER but not after COMMA.
Please. disable displaying of…
1 vote -
For any new subquery nesting level I would also suggest increment the indent from the previous query, not all at same level.
For any new subquery nesting level I would also suggest increment the indent from the previous query or subquery level, not all at same level.
1 vote -
Select from table popup command
When I click right mouse button over table or view identifier in some query, I'd like to see a command 'Execute a query for the table in new document'.
1 vote -
Auto parsing and delimiting IN clause values
Auto parsing and delimiting IN clause values. As an app developer, many a times I find myself dealing with lengthy IN statements and would have to first paste my IN values in excel, run a script to add single quotes when values are strings and delimit each with a comma, then paste the result back into Management Studio and Enterprise Manager....e.g select * from table where col IN ('A', 'B',...)...basically your add-in with format the data once I paste into the IN...if column before the IN is string value, then it add quotes to the values and delimit and add…
1 vote -
Navigating to errors on formatting from Output window
When running format document and there are syntax errors, it would be great if you could double click the error in the output window and it would take you to the error.
1 vote -
Ability to clear results of Output window
It would be nice to be able to clear the results of the output window
1 vote -
Automatic Formatting of "TableName.Value AS Alias"
If you have a field name "Value" then automatic formatting mis-interprets this if it has an alias.
Formatting:
SELECT TableName.Value AS Alias
FROM TableNameBecomes:
SELECT TableName.Valueas Alias
FROM TableNameInstead of
SELECT TableName.[Value] AS Alias
FROM TableName1 vote -
Checkbox next to fields in the Table Fields Pop-Up
- Click the checkbox of multiple fields of table joins when the table field pop-up is visible. 2. Auto create the field listing (with alias) in order of clicked when the pop-up is closed/dismissed.
1 vote -
When hovering over SP, display whether it has default values or not
Is it possible that when i hover over an SP, that i see if the parameters have default values or not?
1 vote -
Implement ability to show objects in completion list only for specific databases
It would be nice to have an option to limit intellisense to either 1) the currently selected database or 2) a pre-defined set of databases. That way I don't have irrelevant database object names showing up in the intellisense pop-up.
1 vote -
When creating/modifying stored procedure, include the current procedure at the top of suggestion list
When creating/modifying a stored procedure, it would be nice for the autotext to include the current procedure at the top (dare I say, like SQLPrompt)
1 vote -
Add option to remove empty lines in BEGIN ... END block
Example:
IF 1 = 1
begin
SELECT
'it does'
print('it does')
end
else
begin
SELECT
'it does not'print('it does not')
end1 vote -
When pressing "Enter" at the end of a line, the indentation of the next line should be same as the previous line
For example:
IF @ID > 1
BEGIN
SELECT '1'
FROM ID
ENDInstead of
IF @ID > 1
BEGIN
SELECT '1'
FROM ID
END1 vote -
Text editor improvement: Text column select enhancements
When I am in Visual Studio and I hold down Alt and select a range of text, I can start typing and it will type into all rows. I use this frequently to type something that needs to be typed across several lines. In SQL Server Management Studio, the highlight process works, but as soon as you start typing, it only types in the first row that is selected.
I would really like to see the input behavior from Visual Studio mimicked in SSMS.
1 vote -
Add stack option for wrap condition in FROM and JOIN clauses
I'd really like the ability to have a stack option for the wrap condition in the FROM > JOIN options. What I mean is, I want to align conditions by the column name like this:
JOIN Person.Address AS a
ON e.ModifiedDate = a.ModifiedDate
AND e.rowguid = a.rowguidI'd like the two "e." to align. Simply inserting a tab after ON and after AND will achieve this.
1 vote -
Add option to align columns in WHERE clause
I'd like to align the columns in the where clause like this:
WHERE
---------------a.AddressLine1 IS NOT NULL
--------AND a.AddressLine2 IS NOT NULLI'd like the two "a." to align.
1 vote
- Don't see your idea?