663 results found
-
SQL history - Allow user to set custom SqlHistory.db save location
SQL Prompt allows users to set custom directories for various files.
It would be nice to be able to change the location of the SqlHistory.db and other files that load to localappdata.
I would love to have this update to a folder in my oneDrive folder so it is backed up and easier to migrate between computers.
The only way to do this now is via REGEDIT.
6 votes -
Allow LEFT, RIGHT, INNER and OUTER JOINS to be right-aligned to SELECT.
Currently, FROM, WHERE, JOIN, and ODER can all be right-aligned to SELECT when formatting SQL. However, if you introduce a LEFT JOIN, the LEFT keyword is right-aligned to SELECT, and everything else is pushed over to make room for the JOIN. This is hideous and makes no sense.
Instead, allow the entirety of "LEFT JOIN", "RIGHT JOIN", "INNER JOIN" and "OUTER JOIN" to right-align to the SELECT keyword.
The attached images explain it better than I can.
6 votes -
Enable block comments in SQL
SQL Prompt and SSMS do not have the option to create/remove block comments. This is a serious problem.
We SQL Prompt users would love the option to add/remove block comments in SQL, between the marks /* and */, because they sometimes serve very different purposes.
Inline comment options (Ctrl + K, Ctrl + C or Ctrl + K, Ctrl + U) are helpful, but they don't always do exactly what we need. Sometimes they can break things. See below.
/*
Sometimes we need block comments that cover multiple lines.
Like this.
/
/ Or comments where each line begins and…6 votes -
SQL History showing the query on the preview pane while hovering
Bring back TAB History!!! In the meantime, in SQL History, show the query/tab on the preview right side pane while hovering over the query on the left side.
6 votes -
Add the ability to specify a named formatting style using a comment block.
Add the ability to specify a named formatting style using a comment block.
Add functionality to specify, in a comment block, what formatting style should be used when formatting the current file. It could be a simple addition to the existing turn-on/off formatting comment.
Perhaps something like this:
--SQL Prompt Formatting On - Style = "My Style"The above would turn on formatting and specify what style to use.
This functionality would be helpful in many ways.
It is already convenient to have multiple formatting rules, this would keep the user from having to remember what rules apply to what…
6 votes -
Add or remove square brackets (easily!)
Have buttons to add/remove square brackets rather than tucked away under Options, so they can be toggled on or off easily.
And/or move the square brackets option out of Options and into the actual formatting style (like the option to remove additional whitespace) so it can be saved and shared as a template
6 votes -
Option to prevent removal of brackets on database and server names
Removing brackets from database names causes VS schema compare to indicate file differences because VS requires database reference variables to be enclosed in brackets. Need an option to exclude removal of brackets from database and server in three and four part names.
6 votes -
ADS wildcard extension
Please add the wildcard extension (select * => select col1, col2, ...) to SqlPrompt in ADS, the same as it works in SSMS.
6 votes -
Unformat Query
Add a menu Item option to unformat a query. In other words take the query that is highlighted or every query in the script and convert them to be on a single line with only a single space between keywords, words, and operators.
This would be very useful for having to copy SQL into a table or other some object that shouldn't have normal formatting in it.
An option would be to double up all single quotes, so that the query can be placed between single quotes.6 votes -
Properly format the start of a CTAS in Azure Synapse Analytics
SQL Prompt does not start a new line for the SELECT portion of a CTAS statement within Azure Synapse Analytics when there is a defined distribution or index using a WITH clause. Instead the SELECT statement is tabbed way over to the right.
6 votes -
Swap commented / uncommented lines in selection
Using a shortcut to swap commented / uncommented lines in the sql script. This could be very helpful when we need to test (select / update) for the same source query.
Please check the screenshots
Thanks
6 votes -
Quick Edit For Table Row Data In Query Result Grid
Scenario:
If I run any select query where filed1=value1 etc, and it shows one or more rows in the grid below.
Now I identify a required change and want to update that column value in a particular row.Current Process:
One option is to write an update query and change the column value.The second option is to right-click on the table and go to edit but again it only shows a limited number of rows at a time.
Requirement:
Option1: Allow right click on result grid and give the option to script the selected row/columns(s) as edit query.Option2:…
6 votes -
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 -
“Open in Excel” the exported “. Xlsx” is too old
When I use SSMS to query the data and use "open in Excel", the exported “. Xlsx” is too old, which will cause the digital content to become 0 after WPS or other form software is opened. This problem has lasted for a long time. I hope your company can upgrade and handle it accordingly. Thank you Very Much
6 votes -
Enable tab color for "not connected" tabs
I would like to set "not connected" tabs to a passive color like light gray to indicate they are not actively connected to a database. Current tab coloring is set by the connection, so this isn't possible. One possible implementation is to create an environment called "not connected" and then specifying NULL in the "SERVER" field.
This would be especially helpful for those who use SSMS's dark theme with SQL Prompt, because "not connected" tabs become nearly invisible with a black background and black font.
6 votes -
Auto-generate MERGE comparison clauses
One of the most tedious elements of writing T-SQL is handling of proper comparisons in the WHEN MATCHED AND ... THEN UPDATE clause of a MERGE statement.
For example, to compare a single nullable target and destination column you should compare:SRC.column <> TGT.column
OR (SRC.column IS NULL AND TGT.column IS NOT NULL)
OR (SRC.column IS NOT NULL AND TGT.column IS NULL)I'm not sure on exactly how would be best to handle this but it would be great if SQL Prompt could somehow auto-populate these clauses. Or even better would be some way to generate an entire merge statement…
6 votes -
Subquery may return more than one row when filtering on primary key.
At the moment a warning is given "Non-scalar subquery in place of a scalar" when trying to assign a variable to the result of a query filtered by the primary key column. In this case only one result can be returned so the warning appears inaccurate and wrapping the result in a TOP 1 { } ORDER BY statement seems an overkill just to remove the warning. This is kind of a special case however where the subquery contains only one table filtered with "=" on the primary key column, but it is a very common one.
Example:
DECLARE @X…6 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 -
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 -
Automatically add Schema to tables when formatting.
Provide the option to enable automatic schema addition when necessary. And when there may be more than one candidate schema, provide a warning
6 votes
- Don't see your idea?