663 results found
-
Only load suggestion for fresh new databases
Do you think it's possible to only have the refresh of suggestions the first time a database is loaded (so skip refresh if the cache already exists, but let the possibility to manually refresh cache for this db with the contextual menu of course)
We have hundred of databases (with thousands of view and sp) and sql prompt try to refresh all the time the same databases (for example when we restart Management Studio) and nothing never change in these databases ...
So we would like to load schema automatically only the very first time and then on demand.
Thanks
1 vote -
flip between adding and removing square brackets
Add ability to add or remove square brackets without having to edit the settings for which direction you want it to go.
4 votes -
REOPEN CLOSED TAB
I'd like to see a right-click on a tab or the tab-bar and have the option to "reopen closed tab" (and the ability to do that several times through working back through the order the tabs were closed). Same functionality as the major web browsers have.
5 votes -
Generate a meaningful filename when clicking 'Save' in SSMS
When you open up new queries in SSMS they are always called SQLQuery1.sql , SQLQuery2.sql etc. etc.
what would be useful is if SQL prompt generates a more useful filename when you click Save or Save As in SSMS.
For example,
Say I had the script:
CREATE VIEW report.vwRandomName
as
SELECT *
FROM TableAwhen I clicked save, it would replace SQLQuery1.sql with
report.vw_RandomName.View.Create.sql
and the same with other object types (table/stored procs etc) and other actions (create / alter / drop).
thanks
ben3 votes -
Add "insert missing aliases" during formatting if desired
When typing SQL aliases are inserted automatically if configured. However when opening existing query from some other source it would be nice to execute an options to add missed aliases based on the same configured rules as with editing.
9 votes -
Add "duplicate a line" feature similar to Resharper's Ctrl+L.
When cursor is placed on any line simple shortcut would insert exactly same line below and move cursor to the newly inserted. No prior selection of any kind necessary.
1 vote -
Highlight difference between selected rows
Time to time you need to compare data in the rows, for example when looking for the cause of duplication. If the query is complex enough with joins and wide tables I usually run
SELECT * FROM ...
and check where the duplication begins to easily find the root cause. The easiest way for me to do so is to copy it into the excel and do some simple formula to find the exact columns that have difference.
It would be nice if SQL Prompt would support that feature. If it's possible then it can be done by highlighting needed…
2 votes -
1 vote
-
format setting for "Copy as IN clause"
when I paste after "Copy as In clause", got contents like this:
IN
(
1, --comma at behind
2
)I hope got this:
IN
(
1
,2 --comma at before
)please provide option, thanks.
4 votes -
It would be really nice if SQL Prompt had support for defining your own collapsible regions in the SQL code. Like C# in Visual Studio.
It would be really nice if SQL Prompt had support for defining your own collapsible regions in the SQL code. Like C# in Visual Studio.
6 votes -
PE006 is Too Noisy for Temp table Parallel INSERT
We use the WITH (TABLOCK) hint extensively for loading temp tables - see https://www.sqlshack.com/use-parallel-insert-sql-server-2016-improve-query-performance/
PE006 is far too picky - it yells at every such statement in our high-volume hybrid solution. It would be good to "silence" this kind of rule-breakage so we can see any REAL violations on persisted tables.
Please augment to utterly ignore temp tables.
1 vote -
Can we have a keyboard shortcut for "Script Object as ALTER"?
Can we have a keyboard shortcut for "Script Object as ALTER"? You had it before but it isn't available with the latest version.
2 votes -
Filter tables, views, etc. on multiple strings
I would like to be able to filter on more than one string in the Object Explorer of SSMS.
For example, I only want to see views that contain “OKDim” or “SSISOK”. Now I can only filter on “OK”, which still results in a long list of views.10 votes -
Allow for Tab History search with date / server criteria
I use Tab History daily and have come to rely on it to find queries that I thought I was only going to need one time, but end up needing again. It would be great if you could use other things to search instead of just keyword. I would like to be able to select a date or date range (for example, I know I ran that query last month, or 3 months ago) and server (we have multiple servers with the same data sets so it would be nice to be able to filter to the server you know…
8 votes -
remove table names (that are not in any joins) from where clause suggestions, or at least deprioritize it.
It keeps suggesting table names dbo.Something when writing the where clause even if the table is not in any join clauses. This is a pain as I keep selecting the table instead of the column if the names are similar.
1 vote -
Jumping to Begin and Jumping to END
Hello,
I try some Add ins for sql server and i found a very interesting and useful functionnality on Softtree sql assistant.
When we have a very large Stored procedure for example, with several BEGIN and END , softtree have a functionality when i place the mouse on BEGIN to [Jump to end] to find the corresponding END, the opposite is also true, when i Place the mouse on END [Jump to begginning].
This functionnlity is very very useful.
I hope you consider developing the same functionality in your SQL Prompt.Best regards,
Luis6 votes -
Ignore Begin statements with CTE immediately after
SQL Prompt's "Insert semicolon" function behaves weirdly when a CTE is a the start of a control loop. For example, if I have this code:
IF (1=1) BEGIN
WITH numbers AS (
SELECT 1 AS num
UNION SELECT 2
UNION SELECT 3
UNION SELECT 4
)
SELECT * FROM numbers
END;SQL Prompt will format it as
IF (1=1) BEGIN;
WITH numbers AS (
SELECT 1 AS num
UNION SELECT 2
UNION SELECT 3
UNION SELECT 4
)
SELECT * FROM numbers;
END;While the code runs, I think the semicolon after "BEGIN" makes very little sense. First, the beginning…
3 votes -
Provide the option to create custom rules.
Open the Rules Engine API so that we can create our own organizational specific rules.
For example, I would like to be able to flag datetime, getdate(), getutcdate().
12 votes -
Allow Copy/Paste contents of 'List of Code Analysis Issues' window.
Sometimes I would like to just copy/paste the issues discovered and include in an email. Currently, I cannot copy the Issues list. It takes too much time/effort to export to a file and then attach that file to an email. Copy/paste would be so much easier.
2 votes -
Add one additional Parenthesis style
My Teams would prefer this option:
xxxxxxxxxxxxxx (
xxxxxxx,
xxxxxxx )Opening parenthesis on the first line, and closing parenthesis on the last line.
Second and following lines indented one stop. This display seems to strip out the leading spaces.
4 votes
- Don't see your idea?