683 results found
-
Add option to check if object exists when creating stored procedure
It would be helpful if you would add an option to check if the objects used in a stored procedure really exist when creating it.
Example:CREATE OR ALTER PROCEDURE [dbo] [SelectFromTableThatDoesNotExist].
AS
BEGIN
SELECT * FROM [dbo] [NonExistingTable];
ENDThe table used in the procedure does not exist, but the procedure can be created without errors. In this case, it would be desirable if SQL Prompt had an option to output an error when creating the procedure.
3 votes -
Suggestion for THIS site
This is a Format SQL request; not for SQL Prompt, but rather for this website. I don't know how many hundreds of examples have been posted where the author spent quite a bit of time formatting an example, only to have the posted code totally bastardized. Have at least a <code> tag that would present the content within the tag in a fixed-width font and not remove leading spaces. I've seen some posts where the poor soul has tried 2-3 times to get their poin t across only to have the presented code rendered in a way that completely loses…
16 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 -
Put DISTINCT Keyword At Top of Suggestions List
Add an option to have the DISTINCT keyword appear at the top of the suggestions list when the first few characters (DIS, DIST) are typed, ahead of any column name suggestions. Nearly every time I type DIS or DIST, I want the DISTINCT keyword and not a column name that begins with the same letters.
1 vote -
A one-click option to minify the selected/entire code
I would like to request a one-click option (or at least an out-of-the-box Format Style) that would minify either the selected line(s) or entire code in the current session.
This would be really helpful when writing a non-dynamic TSQL that will need to be turned into dynamic to save on (VAR)CHAR limit (4000/8000).
Thank you
1 vote -
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 -
Manually define schema/foreign keys
We have a database that has Foreign keys, but doesn't have them set up as such via it's schema. It's a legacy system and there are technical reasons we aren't going to go back in after the fact and define them. I can't imagine we're the only place to ever run into this, it would be nice to have some sort of config file where you could manually set up things like that.
1 vote -
auto alias for colums name
when i join 2 tables with columns having same name sql raise the error 'Ambiguous column name'. if it possible i think it is usefull to have an auto alias generator. example:
select a.name, b.name from a join b => select a.name as aname, b.name as bname3 votes -
Allow for Tab History search with date / server criteria
I use Tab History daily and have come to rely on it to find queries that I thought I was only going to need one time, but end up needing again. It would be great if you could use other things to search instead of just keyword. I would like to be able to select a date or date range (for example, I know I ran that query last month, or 3 months ago) and server (we have multiple servers with the same data sets so it would be nice to be able to filter to the server you know…
8 votes -
Ability to quickly change to another instance (keystroke or drop-down menu)
Switching or connecting to another SQL Server instance requires several steps. It'd be nice if there was a drop down menu or keyboard shortcut to show a list of instances. The list could be frequently used or created manually.
1 vote -
Order By - Enhancements
I often need to have Order By added and the following enhancements will help (same as in the grupy by intellisent)
- order by "Primary Keys" -> Order as in table
- order by Select-list columns -> order as in the select list
- order by Select list columns from table x
All three would help to type less
Thanks
1 vote -
Import and Export Aliases
It would be nice to have the ability to mass import/export aliases.
5 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 -
Indentation of clauses following alter table
Indent the clauses that may follow an alter table statement. They currently are on the same line or split but not indented.
3 votes -
Whitespace: Tab to indent, then spaces for alignments
Whitespace: I picked up an indenting/alignment pattern from a Stack Overflow thread that solves an abundance of arguments: Please provide the option for using Tabs to indent the line, and then use spaces for alignments following the first character.
3 votes -
format setting for "Copy as IN clause"
when I paste after "Copy as In clause", got contents like this:
IN
(
1, --comma at behind
2
)I hope got this:
IN
(
1
,2 --comma at before
)please provide option, thanks.
4 votes -
It would be really nice if SQL Prompt had support for defining your own collapsible regions in the SQL code. Like C# in Visual Studio.
It would be really nice if SQL Prompt had support for defining your own collapsible regions in the SQL code. Like C# in Visual Studio.
6 votes -
Autofix : SC002 – Script should end with empty line
SQL prompt currently removes the empty line at the bottom of a script, which then break rule SC002.
Can format include a setting to add a blank line at the bottom of a script, and also autofix sc002 issues.
3 votes -
Remove/replace String Literals
When you code a SELECT statement as:
SELECT EffDt AS 'EffectiveDate'
SQL PROMPT advises that string literals as column aliases have been deprecated.
Have an option to convert string literals, similar to Remove Square Brackets. In this case, Convert Column Aliases would either remove the apostrophes, where appropriate, or add square brackets if required (e.g. the alias contained special characters, a space or reserved word).3 votes -
Ability to integrate SQLPrompt Formatting with T4 Visual Studio
I use T4 to generate a significant amount of SQL code. It would be useful for purposes of readability especially, to be able to call the formatter from within a T4 build process.
1 vote
- Don't see your idea?