679 results found
-
Option to Omit Formatting of Comments
Option (such as a check box) to omit active style formatting of comment lines between /* and */. Similar to SQL Prompt formatting off/on without the added code lines.
2 votes -
Enable click-away from the window for the "Summarize Script" feature in SSMS
It would be really nice if I could click away from the summarize script window and scroll around in my script, or maximize the window for use on another monitor, or dock the window next to my script
2 votes -
Save Query Results / Results History
One option that would be really neat, is to have the option to save the results of a query so I can compare the two sets side by side without having to drop them into Excel. e.g. run a query, tag it for archive, then after a time run the query again. And I'd have two Results Tabs in the output window. Results and Results(0). If that could be extended to multiple results windows, it would give me a simple way to track changes over time. And lastly, if tagged, the results would restore with the tab.
2 votes -
"Re-connect" right-click menu option in Tab History
TH knows the instance and DB the tab was connected to. Often, SSMS/SQL Prompt forget upon SSMS shut-down and fire-up the next day, to reconnect. (Happened 2020-10-02, so a current problem on just 4 tabs, when I often have a dozen open).
Select one or more from any of the lists ==> right-click ==> new option to "Reconnect to saved instance-DB", or "Connect all to an Instance" (Problem with that is the default to master means we likely have to visit every tab anyway - unless RG gives us a better version of the Connect dialog! Where it connects and…
2 votes -
materialise temp table (from SELECT INTO)
I pick up LOTS of legacy code with SELECT INTO statements.
sometimes they are into temp tables but also in physical tables.
It would be great to be able to highlight the statement in the SQL and right-click and choose to automatically convert it into a TRUNCATE + INSERT INTO (whilst running the CREATE TABLE statement for me)
for example:
/This is the statement I start off with/
SELECT TOP 10 *
INTO dbo.example_table
FROM sys.objects/SQL prompt pops up with dialog box to choose the table name and creates the table for me/
CREATE TABLE…2 votes -
Macro Recorder
Create a plugin to record and replay keyboard commands like notepad++ or sublime.
2 votes -
Tab History Window Behaviour
Can the tab history window, when maximized, be made to consider the maximum screen size when it's popped out?
I have monitors that have different resolutions and if I pop it out on my smaller screen it doesn't fit and I loose the top of the screen with the search and tabs - but most annoyingly that also means I loose the window bar so can't control the size either!2 votes -
Add option to choose Single/Multi-line script for INSERT and EXECUTE statements
Currently SQL Prompt inserts SQL full INSERT script or EXEC SP in multiline while it might be useful for INSERT statement, but most of the times I have to realign them into a single line. It would be good if we have the option to choose wheather to add statement in single line or multi line? and its more usefull if we have shortcut to switch the inserted statement between formats?
2 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 -
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 -
Snowflake
Please add Prompt features when connecting to a Snowflake database
2 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 -
Convert IIF to CASE
We have code littered with IIFs that we would like to convert to CASE. Logically this is straightforward, but achieving it swiftly is proving more difficult. A regex takes care of the simple ones, but the ugly ones with nested functions across multiple lines and all sorts are proving far more difficult.
Would it be possible to add a feature to SQL Prompt to refactor IIFs into CASE statements? Thanks
2 votes -
Using Ctrl-F12 to jump to object - Refresh if required
I often use the Ctrl-F12 feature to jump to an object in the object Explorer, however this doesn't work if the object has been renamed, or was just recently created. In those cases I need to manually refresh the object Explorer before I can use F12. Perhaps the F12 feature could do that for me? (or prompt if it can't find the object)
2 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".
2 votes -
Add a hotkey that will expand the selection to envelop the current statement
Pressing control+A will select an entire document.
I'd like a control+k, control+A to select the current statement based on cursor position.This would enable me to do a few things:
01. Format the current statement with a hotkey
02. Copy or cut my current statement so I can paste it somewhere elseThanks.
2 votes -
Parse Dynamic SQL Queries if possible
Be able to read through Dynamic Queries and pick up table creation code or any other columns so SQL Prompt will be able to list out the columns in any tables that were created in that sql.
2 votes -
Script object as alter from the Object Explorer
Would like the option to Script Object as Alter (F12) from the Object Explorer pane. So, for example, when I click on a stored procedure in the Object Explorer and click F12 (or right click and select Script Object as Alter), it would open a new tab with the stored procedures scripted as alter.
2 votes -
visual indicator/TAB colour for read-only connection
Ability to set a different TAB colour for read only connections to an instance e.g. to differentiate between connections to primary and read-only secondary in AOAG. This would need to inspect the ApplicationIntent=ReadOnly connection property. n.b. I have tried doing this with a registered server group containing just the one read only server, but it uses the TAB colour defined for that server, not the group, so cannot distinguish whether read-only or not.
2 votes -
warning when dropping a object having dependencies
If I write "drop sv_myview" and this view is used in other views (has objects, which are dependend on it) there will be great a warning: "This object has objects, depending on it. Drop anyway?" So I can first recode the dependent objects and then drop it.
2 votes
- Don't see your idea?