663 results found
-
Formatting arithmetic - new lines (Apex has this)
The only edge Apex has over SQL Prompt formatting, at least for my use, is being able to organize long equations. If I am using a large number of columns for an equation, I'd like to place each new column on a new line.
1 vote -
Ability to search contents of object within contents pop-up
When hovering over an object like a Proc or a View, and you click the link in the pop-up to view the contents of that object. It would be nice if there was a simple search function. Many times when I'm viewing the contents of an object, it's just because I want to see where it's making a particular reference, so I have to copy, open a new tab and then search.
1 vote -
SQL Prompt storage of settings
As we are using a dedicated group of virtual machines for using our high privilege accounts, we don't know at login time on which machine we will have a session. Currently the settings of SQL Prompt are stored under “…\AppData\Local...”. After each logoff we loose these settings. According to the Microsoft standards, the settings should be stored under “…\Appdata\Roaming...”. Could this be changed in a future version?
1 vote -
Autocomplete stored procedure using local time zone on datetime arguments.
When auto-completing an "EXEC storedProc" statement, SQL Prompt will generate the input arguments (and outputs) and generate sample values for the input arguments. If an input argument is of type datetime, SQL Prompt generates a string literal that is equivalent to current date and time in UTC. Please provide an option to either generate a string literal that is the current date and time in the local time zone.
1 vote -
Autocomplete stored procedure using local time zone on datetime arguments.
When auto-completing an "EXEC storedProc" statement, SQL Prompt will generate the input arguments (and outputs) and generate sample values for the input arguments. If an input argument is of type datetime, SQL Prompt generates a string literal that is equivalent to current date and time in UTC. Please provide an option to either generate a string literal that is the current date and time in the local time zone.
1 vote -
Smart Rename auto-generate synonym
It would be incredibly useful to have Smart Rename have the option to generate a synonym that points the old name to the new one, in order to maintain functionality for any legacy applications accessing the database via those old object names.
1 vote -
Aliases -> Prefixes to ignore with Regex
Please add option to specify regular expressions to ignore prefixes.
So if I have a pattern for table/view/SP prefix I would not need to specify all the options/combinations.Thank you
1 vote -
Control the behaviour of SQL Prompt insertion
I would like the ability to control how SQL Prompt completes my statements for me, this mostly becomes an issue with procedures with multiple optional parameters.
If I used sp_whoisactive as an example, there are multiple optional parameters but it is capable of running with no parameters at all, so I find myself having to spend longer than I want to either highlighting the bit I want execute or deleting all the parameters that just got written for me.
So a setting where I can assign keys to complete full statement and keys to simply complete object name would be…
1 vote -
Colon style parameters
Some programming languages (we use FireDac in Delphi) use colon notation to declare variables. Eg
select * from table where id = :id;
Testing such queries in SQL Prompt forces you to change the query before and after testing and that is error prone.
It would be nice if SQL Prompt could handle this type of parameters by instead of raising an error show a "Enter parameter value" input box.1 vote -
open source sql prompt's formatting module.
open source sql prompt's formatting module.
1 vote -
Change the activation model to allow easier portability
As a consultant I move around to many computers. I depend on this product, but it is often a chore to keep track of where it is active. It would be a real quality of life improvement if I could just login to the machine I'm using and type in my redgate creds to activate sql prompt and get on with it. So often I'm running into an activation error, followed by a support call to find where the product is in use, then deactivate it, the activate on the new machine repeat, repeat, repeat...
I understand you make money…
1 vote -
Support 'FROM BINARY' in CREATE CERTIFICATE
Support 'FROM BINARY' in CREATE CERTIFICATE
Since SQL Server 2012 there is an option to specify an ASN-encoded binary certificate when doing ‘CREATE CERTIFICATE’. Alongside CERTENCODED() and CERTPRIVATEKEY() this makes for a good way to transfer certificates generated on SQL server to other stages.
Your formatting engine however does not recognize the BINARY-parameter of said statement. Please include it as valid syntax.
Examples (non-working because the certifcates are fake – but you are free to generate your own; note that passwords are optional):
CREATE CERTIFICATE [TestCert] AUTHORIZATION [dbo]
FROM BINARY = 0x42
WITH PRIVATE KEY ( BINARY = 0x42, DECRYPTION…
1 vote -
Add option in context menu to "Open In Browser"
When the grid outputs a link as its value, right clicking the cell would provide an option to "Open In Browser"
...
Additionally, this same functionality could be customizable (perhaps a customize context menu section within SQL Prompt options) to allow for other applications, wherein the highlighted/cell value is passed as a parameter to a given application. This would be similar to the External Tools, which is provided within SSMS, but having that option right there in the context menu would be gold.So, in the case of a URL, I right click the cell, choose Open In Browser, and…
1 vote -
Stop resetting defaults (like paths) with every Update
I spent a lot of time setting up custom directories for various products/features and its frustrating how SQL Prompt resets this with each new update forcing me to go back and change all these paths/defaults back to what they were before.
1 vote -
Vertical rivers - cobol style
When writing SQL I don't think procedurally, which means I don't think about nested, indented "blocks" unless I'm actually using some procedural style SQL extensions like try/catch, if, case (which is a little procedural expression inside a set based statement), and so on.
Because of this, I like to align various different "types of things" in a statement to create vertical rivers.
So, for example, insert, update, select, from, join, where, group by, having, and order by are all aligned on the left. You might think of this as "column 1 - sql keywords".
Then come column names, table names…
1 vote -
Aliases
On SQL Prompt Aliases section I would like to have on custom aliases when I add a new a dropdown or a list view where I can pick object instead of me writing the object name. it would be even better if it has an option to show only object not already added with alias.
1 vote -
Make a
Similar to visual studio code, it would be good to have a find and replace all occurrences by highlighting what you would like to replace. This would then give you the option to type in what you want to replace. I know Sql Server has a find and replace function, however I just really like this functionality and think it would be a great addition to SQL prompt
1 vote -
1 vote
-
Make semi-colon optional at END(;)
Semi-colons are automatically added at every END reserved key word. Make this optional.
END(;)
END TRY(;)
END CATCH(;)This just look weird to everyone
BEGIN
....
END(;) <=== don't want it here... there's an ELSE continuation.
ELSE
BEGIN
END(;)1 vote -
Arithmetic expressions - format consistently with logical expressions
Arithmetical expressions and compound logical expressions all consist of operations and expressions with parentheses and orders of precedence. All of these should have the options for aligning operands, aligning parentheses, adding parentheses to make the default orders of precedence explicit. All expressions are subordinate to clauses so they should be indented under WHERE, ON, SELECT, WHEN.
1 vote
- Don't see your idea?