695 results found
-
Suggest data truncation
Consider I've got a variable of varchar(35)
I perform an update on a column of varchar(10), it should suggest that there will be a truncation
2 votes -
Ability to make/see notes about servers
It would be very handy if there was a way when you open a server in Object Explorer that it pops up with notes about that server. For instance, there is a job we have on EVERY server in our environment except one random server that no one hardly thinks about. But if that job is there, then it messes up things. It would be great if when anyone on our team who has redgate sql prompt opens that server they get a reminder that we add on there that says some special note (in this case “DO NOT ADD…
2 votes -
Have Formal SQL Actions be included in the formatting style file.
Have Formal SQL Actions be included in the formatting style file. This way when a team shared a standard we do not have to share the file and screen shots of the Options menu to manually sync to maintain team consistency on code checkin.
2 votes -
Make the "Enclose identifiers within square brackets [ ]" option persist
Currently in Visual Studio the option to "Enclose identifiers within square brackets []" option will be set to true on startup requiring a user to turn it off every time they load Visual Studio.
This option when set to false should remain that way even after a restart of Visual Studio the same way it does in SSMS.
2 votes -
Aliases Postfixes to ignore
Similar to the "Prefixes to ignore" option in Options > Inserted code > Aliases, could we have a "Postfixes to ignore" option to allow use to set words at the end of a tablename to ignore when generating aliases.
Currently I have to keep the custom aliases list up to date, whereas this would do that automatically.
2 votes -
New code analysis rule: predicate data type agreement
Please create a rule that detects when the data type of input parameters, local variables, and/or expressions do not match the data type of the column in a predicate.
For example, if we have
a Person table, with column LastName varchar(60) NOT NULL, and
in the body of a stored procedure which has an input parameter defined as @LastName nvarchar(100)... and a predicate like WHERE Person.LastName = @LastName [join, apply, correlation, and functions also need this]
It would be wonderful - save me massive amounts of time - if SQLPrompt could flag this and help reduce implicit conversions.
Thank you!
2 votes -
Multi Line Comment shortcut
Add /* / multi line comment shortcut for highlighted code in text editor. See SSMSBoost pro for example CTRL+.
2 votes -
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
- Don't see your idea?