715 results found
-
Add possibility to make snippet for "GROUP BY 'by all non-aggregated columns'"
I use GROUP BY only for 'by all non-aggregated columns' in 99% of cases. I've created snippet for GROUP BY (gb) and then I pick this option from the intellisense menu. It would be nice to have possibility to have snippet that would add these 'all non-aggregated columns' automatically most probably by adding new variable.
3 votes -
Use SQL Prompt editing settings in other tools (like MultiScript)
When I am composing a script in Multi-Script, I'd like to have the editing settings available. Include variable/column name completion, keyword formatting, indention, etc..
3 votes -
Custom Formatting and Refactoring (API)
I would like to expand upon suggestions others have made regarding adding custom formatting and analyzers.
I have recently been trying to implement SQL Prompt for our team, and I have struggles with a lack of customization, opinionated options that don’t reflect our needs, and some bugs.
What would have solved this issue for me would have been the ability to add custom formatters and custom analyzers.Custom Formatters
Since SQL Prompt gets the position of tokens from IAlignmentProvider.FinalAlignmentForToken I suggest that the API couple simply be plumbed into this method, if a plugin is attached it would call the…3 votes -
SQL Prompt Setting Sharing
Provide an easier way to share SQLPrompt (snippet/code formatting/settings).
Like give us 2 (or more) folders to connect to, rather than one, 1 for the default items (make them read only, but optional?) Then directories for items you write for personal use, then one or more for team shares.
I share common ones with team, but they don't need my changes, or some I use for personal uses (like formatting code for a book, or snippets for features we don't use)
Right now, I have started using naming conventions to copy out team items to put into Source Control to…
3 votes -
Tab History, wrong server
After doing multiple server migrations, if you open something in tab history that was for one of the previous servers. Sometimes an implicit connection to the server is still used despite not being connected to that server in Object Explorer. This has caused us to have to troubleshoot something that wasn't working anymore when it fact it is just because the connection was the old server. This forces us to copy the SQL statements to Notepad then open a new window and past so that the connection is set to the connected to server. Some kind of warning of this…
3 votes -
Name tab with object name when scripting from Object Explorer
When scripting an object from the Object Explorer, for example with right-click -> Modify or Script as... CREATE To, the tab created has a default name determined by SSMS, for example "SQLQuery45 - database01.sql". It would be great if this naming was the same as when you click F12 on an object name in a script, where the new tab is named the same as the object, for example "dbo.SomeStoredProcedure - database01.sql".
3 votes -
SQL Prompt does not think PERSIST_SAMPLE_PERCENT is valid
PERSIST_SAMPLE_PERCENT is a new feature in SQL Server 2016 SP1 CU4.
SQL Prompt does not think this is a valid UPDATE STATISTICS statement:
UPDATE STATISTICS dbo.MyTable(MyStat)
WITH FULLSCAN, PERSIST_SAMPLE_PERCENT = ON;It is valid and the correct syntax. SQL Prompt should be updated to format this correctly.
3 votes -
install
Would LOVE SQL Prompt to do a silent upgrade, without the need to "promote" admin privledges, nor close Visual Studio / SSMS. Love the upgrades, but they are frequent, and the installation process is disruptive.
3 votes -
global temp intellisense
I use global temp tables (##), and intellisense doesn't pick them up, even after a refresh.
3 votes -
Object definition window: Mark primary/foreign key columns
In the suggestion box primary key/foreign keys are visually marked. I would like to see this in the objects definition box (Summary tab) as well.
Also it might nice to be able to select columns in there and add those columns to the qury
3 votes -
Custom Rank Suggestions
Could see there are ranked suggestions, which is good.
Can we take this to next level by letting user add custom ranking to suggestions to see those we rank always at the top but with a requirement that you need to enter at least a single letter so that your custom suggestions starting with that letter would be the first in order of display.Thanks!
3 votes -
Format SQL Backup to URL with credential breaks code
Formatting a SQL batch which contains
BACKUP DATABASE Databasename
TO URL = N'URL'
WITH CREDENTIAL = N'Credential'leads to
BACKUP DATABASE Databasename
TO URL = N'URL'
WITH AS CREDENTIAL = N'Credential'the AS between with and credential is wrong.
Please fix :-)
3 votes -
Remove PE019 (Consider using EXISTS instead of IN), or allow it to be disabled
Following the suggestions of rule PE019 (Consider using EXISTS instead of IN) leads to performance issues, by creating correlated subqueries. Even the documentation of the rule admits that there is no longer a performance benefit of doing what is suggested. Please remove the rule or allow the rule to be disabled across a team. At the moment, the disabling of rules is done per developer, and a developer who did not know to switch off this rule, followed the advice, creating a performance problem.
3 votes -
CTE column list formatted like the columns in the AS list
The columns listed in the CTE are not formatted like the columns in the AS clause. On larger CTE's, the listed columns may be hundreds or characters long so we get
with xx
( a, b, c, d, e, ...) AS
(Select a,
b,
c,
d,
e,
...3 votes -
Add option to check if object exists when creating stored procedure
It would be helpful if you would add an option to check if the objects used in a stored procedure really exist when creating it.
Example:CREATE OR ALTER PROCEDURE [dbo] [SelectFromTableThatDoesNotExist].
AS
BEGIN
SELECT * FROM [dbo] [NonExistingTable];
ENDThe table used in the procedure does not exist, but the procedure can be created without errors. In this case, it would be desirable if SQL Prompt had an option to output an error when creating the procedure.
3 votes -
auto alias for colums name
when i join 2 tables with columns having same name sql raise the error 'Ambiguous column name'. if it possible i think it is usefull to have an auto alias generator. example:
select a.name, b.name from a join b => select a.name as aname, b.name as bname3 votes -
Code Analysis Selection Background Colour
Could we have the ability to change the background colour when Code Analysis detects an issue with the code. My scheme is black background and light coloured fonts. When code analysis detects an issue, the code becomes unreadable. Below has an example:
https://forum.red-gate.com/discussion/86480/code-analysis-selection-background-colour#latest
3 votes -
Indentation of clauses following alter table
Indent the clauses that may follow an alter table statement. They currently are on the same line or split but not indented.
3 votes -
Whitespace: Tab to indent, then spaces for alignments
Whitespace: I picked up an indenting/alignment pattern from a Stack Overflow thread that solves an abundance of arguments: Please provide the option for using Tabs to indent the line, and then use spaces for alignments following the first character.
3 votes -
Autofix : SC002 – Script should end with empty line
SQL prompt currently removes the empty line at the bottom of a script, which then break rule SC002.
Can format include a setting to add a blank line at the bottom of a script, and also autofix sc002 issues.
3 votes
- Don't see your idea?