275 results found
-
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 -
Table alias gets converted to uppercase
When using a table alias of "u", all new instances becoming capitalized incorrectly.
Please see attached gif:
https://ibb.co/fr9LcH12 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 -
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.
-
De-couple execute-current-statement functionality from code completion.
I like execute-current-statement functionality, but when I disable code completion then execute-current-statement functionality stops working.
3 votes -
"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 -
checking update failed
The checking update menu in sql complete may point to a HTTP url and currently devart.com is only available via HTTPS protocal. It let the update checking 100% failed with network error message: cannot connect to remote server.
1 vote -
1 vote
- Don't see your idea?