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 -
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 -
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 -
CTR+F12 Options
Currently in SSMS if you right click on a stored procedure and select modify you get something like this
ALTER PROCEDURE [dbo].[ProcedureName]
In SQL complete when use the key commands CTRL+F12 on exec ProcedureName you get this
ALTER PROCEDURE dbo.ProcedureName
notice the missing hard brackets.
I would like an option i can set in SQL Complete to include the hard brackets
3 votes -
Ability to select multiple fields from code completion( wildcard expansion)
Could you please provide the ability to select multiple fields from code completion pop-up( wildcard expansion).
3 votes -
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 -
Grid Aggregates Enhancements
Grid Aggregates Enhancements is a great feature. Here are some additional enhancements you can make:
- Add support for the date/time data types to MIN/MAX. Currently, it is not supported giving a message that it is not a number.
- Add MIN/MAX String length
- Have an option to make Grid Aggregates row permanently visible. It looks a bit funky when it pops-up on selection.
4 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.
- Don't see your idea?