674 results found
-
Have the update process default to only updating installed tools
I don't use SQL Prompt in Visual Studio and likely never will. However, every time I update, the updater defaults to installing it for VS and updating SSMS. It would be nice if the update process defaulted to only doing updates.
7 votes -
Discover metadata for OPENQUERY
When I use the OPENQUERY syntax to retrieve data across servers, SQL Prompt does not discover the metadata (column names, data types, etc.) of the fields returned.
My suggestion is that you add support within SQL Prompt to make metadata for fields retrieved by OPENQUERY available just like you do for linked servers.
7 votes -
Format pasted-in list
I need a way to format a group of text items into a SQL query that I'm going to use for an "IN ('item1','item2','item3')" clause within the WHERE clause. There's got to be a simpler way than manually keying in all the single quotes and commas, particularly when the comma triggers SQL Prompt to start trying to prompt each time, so I have to add an Esc keypress to get SQL Prompt out of the way.
7 votes -
The automatic aliasing of tables and views could be improved
Say I typed the code below, just to look at the content of a table (don't slam me for the SELECT *, this is pseudo code).
SELECT * FROM dbo.Address AS A
dbo.Address was automatically aliased as "A", which is fine.
Now, let me double-click on "Address" and replace this table name with another one, just because I want to save time:
SELECT * FROM dbo.Affiliation AS A AS A
This time, the table was automatically aliased again, but your feature does not seem to care if the table was already aliases.
So now, the table is double aliased.
6 votes -
Create snippet to apply on each line in the selected text.
I really love the add (quotes and) commas feature in SQL Prompt. Unfortunately we cannot produce a snippet similar to those.
If you select some text it would be nice to format each line to a certain format.
Like for exampleE46337E5-ECBC-41D4-A63E-A994E16BD8F7
669F0B8E-5E1C-47CE-A799-81B47C9BC045
65D23D56-7EB8-44AE-9158-C3D8B5684357
AAFE4057-10B9-4AE8-BE76-C22537D29790
4426C0B6-6216-4BFE-BE54-C1D917B593A5
7BC5ED9E-E8C3-4618-B625-786F4B931D97
01A37706-63FA-46E5-99EE-293FF290B34D
94CAB432-EA1C-4972-8CD6-3C8B9E1A096B
2C801ADE-995A-4158-9D0A-7DA03911D093
425BAAC6-6A0B-419C-B393-79B21A628538turn into
('E46337E5-ECBC-41D4-A63E-A994E16BD8F7'),
('669F0B8E-5E1C-47CE-A799-81B47C9BC045'),
('65D23D56-7EB8-44AE-9158-C3D8B5684357'),
('AAFE4057-10B9-4AE8-BE76-C22537D29790'),
('4426C0B6-6216-4BFE-BE54-C1D917B593A5'),
('7BC5ED9E-E8C3-4618-B625-786F4B931D97'),
('01A37706-63FA-46E5-99EE-293FF290B34D'),
('94CAB432-EA1C-4972-8CD6-3C8B9E1A096B'),
('2C801ADE-995A-4158-9D0A-7DA03911D093'),
('425BAAC6-6A0B-419C-B393-79B21A628538')OR even better
prepend
SELECT t.x FROM (VALUES
and append
) t(x)
I often use this format to look up data in the database. I know I can achieve this with Excel and consorts. Or even with…
6 votes -
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 -
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 -
Align SET statements around = sign
I am a brand new user (1 day) for SQL PROMPT. I managed to get my parameter statements to align, but there is no option on my custom formatting style to align my set statements. See the attached jpg. Trying to get it to look like the yellow highlighted area.
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
- Don't see your idea?