231 results found
-
SSMS 20.x support
SSMS 20.x has been out for a while now, but I am not upgrading until I can install SQL Complete for it, of course ;-)
3 votes -
Execution History not saving data
I have a problem with execution history, recently it stopped behaving correctly. So I daily use SSMS and connect to 2 local instances and several other azure instances. When I open the execution history I notices sometimes that I do not have a log for anything for the past 2 days, for example today is 9th of July, and "Execution History" has records for 7th of July.. 8th and 9th are not there.
Also it is not recording all executions for all servers, so it might record only 1 for a server and several for another. I am not sure…
3 votes -
default suggestion even if containing SQL keyword
Please change the default selected suggestion in the dropdown so that columns in a user table take precedence over SQL keywords.
For example:
When a column in a user table begins with the same word as a SQL keyword (for example the field name "Monthly") -- the default selected suggestion when you type the word MONTH jumps to the "MONTH" keyword instead of staying on "Monthly"Code example:
CREATE TABLE #MyTable (Monthly BIT)
SELECT * FROM #MyTable WHERE M --selection stays on "Monthly"
SELECT * FROM #MyTable WHERE Mo --selection stays on "Monthly"
SELECT * FROM #MyTable WHERE Mon --selection…3 votes -
Named Tabs
It would be great if you could name the tabs, not just when saving a query
1 vote -
table function hint shows wrong parameters
When selecting from a table function the tooltip shows the return columns along with the parameters at last, which is super confusing.
3 votes -
1 vote
This is the native feature of SSMS.
-
Select and copy from Execution History results
Now it is possible copy all script from Execution History results (to clipboard or new window).
But sometimes it is required to copy just part of the code.
It is possible to select code in Execution History result window, but not possible to copy it.3 votes -
Execution History by server
Filter execution history by server that the code has been executed on.
3 votes -
Disable Data Loss warning for a specific Script
I love the new feature that warns before delete data without any where.
However when writing migration scripts and debug them it can be annoying because it pops up every time.
would be nice if this could be disabled for a script.
for example by using a comment like --disable warning--
1 vote -
Code formatting for Merge Into "Values"
Merge doesn't have formatting for source table formed from values.
MERGE INTO [TargetTable] AS T USING (
VALUES (@UserId, @InternalId)) AS S
([UserId], [InternalId])
ON T.[UserId] = S.[UserId]
WHEN MATCHED ...5 votes -
Formatting Profiles - Quick Select (Activate) in Toolbar
it would be great if you add an icon for fast switching between Formatting Profiles in toolbar, rather than going to menu bar SQL Complete>Options>Formatting>Profiles>[select]>Activate>[OK].
The lack of this feature makes it almost impractical to use multiple formatting in one script.3 votes -
configure Tabs Color for [Server]\Database
I have multiple databases on a server some are Test & dev servers, some are Prod. It would be nice to color based upon [Server]\Database. instead of one color for each server.
1 vote -
indent case end
In the CASE statement, add "Indent END by 4 column(s)
1 vote -
Warnings for Execution should not warn on UPDATE/DELETE to Temporary Tables or Table Variables
Warnings for execution should not warn on Temporary tables or table variables.
Example:
UPDATE T
SET T.Description = V.Description
FROM @Problem1099BoxRows T
INNER JOIN APVouchers V ON T.APVoucherID = V.APVoucherID1 vote -
Meaningful parameter names for system functions
Example: suggestion for CAHRINDEX function should look like (expressionToFind , expressionToSearch) instead of (expression1, expression2)
1 vote -
Execute to Cursor change to not check beyond cursor position
Currently you cannot use Execute to Cursor with a CTE. Error is returned as the process looks beyond the cursor.
example:
with cteone as
(
select a.field
from table1 a
)
select * from cteone <-- Cursor placed here and execute to cursor returns error,ctetwo as
(
select b.field
from table2 b
)
select *
from cteone1 voteThe script is invalid.
The correct parsing of CTE statements on Execute Current Statement is supported.
-
Space-align multiple column values within INSERT VALUES statement
-- view this with monospaced font
INSERT @t (A, B, C)
VALUES
(1, 2, 3),
(11, 22, 33),
(111, 222, 333),
(1111, 2222, 3333)1 vote -
"Generate Script As" to Clipboard
"Generate Script As" right now creates a new window which is annoying in most cases because you most likely want to use it in some other script. It would be very useful to have an option to copy it to Clipboard instead of a new window. I would prefer to copy it to Clipboard in 95% of cases.
It might be an option in settings or another menu item.
Thank you in advance.
7 votes -
Copy to Clipboard from Execution History
Currently, you can only open query from Execution History as new query window. It would be useful to have the ability just copy the full or part of the query to the clipboard.
Thank you in advance.
7 votesPlease right-click the query in the ‘Execution History’ window and select ‘to Clipboard’ from the popup menu.
-
SQL XML fucntion value is changed to Value (uppercase V) when formatting a document. This is not valid SQL
Formatting document should not change value to Value in an XML SQL query. Value is not a valid function
1 vote
- Don't see your idea?