662 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 -
Copy as IN clause - Allow second column as ID comment
So… Copy as IN Clause. Love it, but let’s improve it. Let’s say we have the following output…
ProductID ProductDesc
1 SQL Prompt
2 SQL Search
3 SQL CompareIf we use Copy as IN Clause on the ProductID column, we get:
IN
(
1,
2,
3
)Which super…. However those IDs mean nothing to me in 6 months time when I’m now having to modify my code. What would be awesome, is if I can select both ProductID and ProductDesc, then hit Copy as IN Clause, and get the following output:
IN
(
1, -- SQL Prompt
2,…5 votes -
Don't add trivial queries
Add an option to filter what tabs are moved into history.
- SSMS autogenerated queries are of no interest.
- So are simple DML and EXEC[UTE] queries consisting of one statement.
- Successful executed ALTER {PROC|VIEW} are of no interest.
Optionally calculate a query complexity value or class to hide simple queries.
5 votes -
Tab ageing - automatic deletion after X days / weeks / months
Add a configuration option to automatically delete tabs by age (last executed or tab closed).
Or move them outside the normal tab history (archive them) to speed up the normal history loading and searching.
5 votes -
Warn about always true WHERE clauses such as ID = ID instead of ID = @ID
It is common to create functions and stored procedures that have parameters with the same name as fields. Sometimes the @ is mistakenly skipped when creating a WHERE condition and you end up with something like ID = ID instead of ID = @ID. I would like intellisense that warns me about this type of error.
2 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..
2 votes -
Script as INSERT
Fix "Script as INSERT" functionality with dates.
Currently when I use this great functionality all the datetime fields will get a form N'1900-01-01T00.00.00'.
Unfortunately the Finnish SQL server settings does not recognise that and running this script gives an error "Msg 241, Level 16, State 1, Line 2
Conversion failed when converting date and/or time from character string.". I have not been able to find a way to change that date format in SQL Prompt Options.1 vote -
backup
I would like to see intellisense provide you a list of backup devices that are created when you use the backup database key words.
Backup database [database names in drop down] to [ disk, file, Url, backup devices in dropdown]
1 vote -
Autogenerate variables based on correlated field
When writing SQL, I frequently will create a variable within the statement before I have Declared the variable. It would be great if SQL Prompt offered a UI option to autogenerate the variable declaration.
For example, given the statement:
SELECT * FROM dbo.Person WHERE Username = @Username
I would like to use a shortcut key to auto generate and insert the declaration above the statement:
DECLARE @Username VARCHAR(8);For simple fields, the data type can be pulled directly from the field metadata. For expressions, derive the data type as SQL would if possible, or move the cursor to the data…
6 votes -
Begin statement is not starting on a new line within an If statement. Please allow this in format styles. The option is there but it doesn't
When Place Begin - End statements on new line is selected it doesn't appear to work as part of an If statement. This makes the begin and end difficult to find
2 votes -
Script object as alter also in 'CREATE OR ALTER' statement
'Script object as alter' (F12) works in ALTER statements but not in CREATE OR ALTER statements like. It would be nice if it also worked for the latter.
Example:
'CREATE OR ALTER VIEW [MyView] AS SELECT 1 AS Col1;'
If I right-click on [MyView] in the above code snippet and select 'Script object as ALTER' (or hit F12), I would expect SQL Prompt to script the object if it exists.
Currently nothing happens.5 votes -
Snowflake
Please add Prompt features when connecting to a Snowflake database
2 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 -
Tab History - Option to Open Multiple Tabs at Once
I use Tab History quite a bit, and I often find myself seeing 2 or more tabs that have the search criteria I'm after. Rather than just being able to click one tab to open it, it'd be nice to be able to select multiple tabs from the history (some or all of the result list). The amount I use it daily and the amount I need to open 2 or more tabs from a search this sort of functionality would save me the repetitive task of performing the same search over and over to get each tab open that…
12 votes -
Intellisense for Indexes and Constraints
When I have a table with multiple indexes and I want to determine if a certain column or group of columns are part of an index, I basically have to script all of the indexes.
I would like to be able to hover over an index name in the Object Explorer and have SQL Prompt display the index definition without having to script it.
Same with constraints.2 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 -
Smart Rename on Service Broker Objects
Smart Rename should work on service broker objects. These objects: Message Types, Contracts, Queues and Services are all interdependent. Renaming Message Types, for example, requires the dropping of the dependent Contracts, which in turn requires the dropping of the dependent Services.
It would be great to be able to generate the relevant drop and create sql in one hit.1 vote -
Use a cell pattern to format NULL values in "Open in Excel" feature
When using the feature 'Open in Excel' for grid results, I'm unable to determine in Excel which database values were empty strings vs. NULL values. I like that it no longer exports the word 'NULL', but I'd like some sort of option to be able to make a distinction between the two.
My idea is to use a cell fill pattern (Format Cells + Fill + Pattern Style), but I would be satisfied with just about anything to be able to make that distinction. The pattern I recommend is the most sparsely dotted option, which shows a tool-tip of 6.25%…
1 vote -
set default join conditions
I work on the same databases on a regular basis. Many do not have foreign keys and do not used identically named column names in tables that I'm joining.
I repeatedly have to specify the same several columns in the join condition.
I'd love a way for SQLPrompt to either remember join clauses I've previously used, or allow me to specify default join conditions for pairs of tables (or both).
8 votes
- Don't see your idea?