662 results found
-
Prefixes in function parameters
SQL Prompt is removing prefixes from column names used as parameters in function-calls. For example, if you use Cross Apply to a system function:
SELECT *
FROM sys.tables AS T
CROSS APPLY sys.fnlistextendedproperty('blah','schema',schemaname(T.schemaid), 'table', T.name, null, null)
It removes "T." from schemaid and name in the parameters list. This means I have to add them back in if the column names are ambiguous. I don't see a setting for this, and have Prompt set to add prefixes to columns in the other clauses. So it'll add "T." to a column in the Select clause, and remove…4 votes -
Trim white space
Please add an option be added to SQL Prompt to trim all white space.
Ideally, the following would be supported:
- Ability to execute against a query window or block of selected code
- Available as a stand-alone shortcut
- Can include as part of a Format SQL style
- Option to remove a) leading spaces, b) trailing spaces, c) both8 votes -
Apply casing formatting as I type, but without the suggestions.
Currently, SQL Prompt either allows you to apply casing all at once with the Apply Casing Options, or it does it as you type if Enable Suggestions is turned on.
Please add a feature so that I can have casing applied as I type, but without the suggestions.
4 votes -
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 support for SSMS preview candidates
Some people uses the latest versions of SSMS. I'd like to see it in non-release versions, maybe not fully supported yet.
0 votes -
Add formatting support for OFFSET and FETCH NEXT
The Format SQL command currently overlooks these keywords and they end up appended to the last line of the ORDER BY clause. Ideally, I'd like to have the option to place both OFFSET and FETCH NEXT on separate lines, aligned just like the SELECT, FROM, WHERE, and ORDER BY keywords.
3 votes -
Make SQL Prompt & SCG Command line ignore code where scgignore is set
We have adopted SCG and have commented out areas of code we do not want checking with scgignore. The new version of SCG command prompt and SQL Prompt do not recognise these comments, and report the area of code with warnings.
Please amend so they are not reported, or at least reported differently so we can ignore.13 votes -
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 -
Allow importing of .settings file, and setting Code formatting/snippets folders and default formatting style to be done via Command line
I would like to be able to better automate our onboarding process for new developers by helping ensure their snippets folder, formatting style folder and default formatting style are correctly setup. Additionally we would like to be able to automatically import settings from UNC/source control for them. This reduces the inevitability that something is missed when trying to follow a setup guide we have to additionally maintain. Thanks!
4 votes -
Use named parameters when encapsulating as new stored procedure
It would be nice if the "Encapsulate as new stored procedure" logic used named parameter style so I don't immediately get ST008 in my code which calls the new proc.
4 votes -
Don't allow for aliases that match snippet acronyms
What I sometimes run into, is that a table gets an alias (by SQL prompt), that matches an acronym for a snippet. Then, whenever I'm writing out my query, while calling the table by alias, snippet manager replaces the alias with the full snippet. Which can be annoying as Ctrl-Z doesn't work.
My suggestion would be to check the snippet manager before assigning aliases and not have them overlap.
Thanks.3 votes -
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 -
Prevent suggestions after typing a number
It would be good to have an option to not offer suggestions after typing a number. If i'm about to enter a constant such as set @var = 1 I usually don't want to see suggestions containing 1. Often I have to turn suggestions off to type a number.
2 votes -
Prevent suggestions after typing a single quote.
It would be good to have an option to not offer suggestions after typing a single quote. If i'm about to enter a text string I usually don't want to see suggestions. Often I have to turn suggestions off to type a quoted string.
2 votes -
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 -
sonarqube
Have SonarQube plugin that will do code analysis using your rules rather than TSQL or PLSQL plugins
4 votes -
Automatically alias tables and columns in existing scripts
Please could you add a feature that parses a query that has already been written, adds aliases for tables that don't already have them and update columns to use those aliases.
This is because I often get pieces of code which are partially aliased and I have to go through updating the missing ones. Thanks.
15 votes -
Allow custom rules for code analysis
SQL Prompt has the ability to catch and warn about Update statements without Where clauses.
How about something similar that catches and warns about security commands like Grant or Deny.
8 votes -
SSMS - object list - filter from clipboard
In the right-click menu of the "Tables" branch in SSMS, create an extra item that would retrieve string from system clipboard and apply it as an object name filter (using the SSMS built-in [Filter] => [Filter settings] => [Name] => [Contains] feature).
This would allow for instant filtering, saving lot of time.
2 votes
- Don't see your idea?