679 results found
-
Set preferences for automatically numbering new queries
New queries, as users know, have an automatic naming and numbering system:
SQLQuery1.sql, SQLQuery2.sql, SQLQuery3.sql, etc.It would be helpful sometimes if the queries could have leading zeros or maybe even a different lead-in like the name of the solution. For example, SQLSolutionABC might have the default tab names:
SQLSolutionABC001.sql, SQLSolutionABC002.sql, SQLSolutionABC003.sql, etc.
1 vote -
Add a warning for using a self-join in a delete or update statement
Add a checkbox to the warnings settings, for if a self-join is detected when doing an UPDATE or DELETE.
1 vote -
SQL Search endpoint for Fabric
Make SQL Search work with Fabric
1 vote -
frequently use the ScriptObjectAsAlter shortcut in Visual Studio to modify views and procedures. However, when the script opens, it default
frequently use the ScriptObjectAsAlter shortcut in Visual Studio to modify views and procedures. However, when the script opens, it defaults to ALTER VIEW or ALTER PROC, while our source control requires everything to be saved as CREATE OR ALTER.
Would it be possible to introduce an option in SQL Prompt to default these scripts to CREATE OR ALTER instead of just ALTER? This would streamline the process and reduce manual edits before committing changes.
1 vote -
Aggregate Min/Max for Date/Time
Show aggregates Min and Max for Date/Time columns in result grids.
1 vote -
Allow typing from table then tab to convert it to Select | from dbo.table
Allow typing from table then tab to convert it to Select | from dbo.table and end up with the cursor after the from, to start typing. Now we have to write select * from table, then go back to the columns. A simple improvement.
1 vote -
Add support for PERCENTILE_CONT function.
The statement below is not formatting correctly. There is no space before or after the WITHIN GROUP clause.
PERCENTILECONT(0.5)WITHIN GROUP(ORDER BY Z.cntrresult) OVER (PARTITION BY Z.environment, Z.cntrfullname, DT.GRAIN_DT) AS [median]1 vote -
Automatic Log In after Update
After every update I have to Log On to get SQL Prompt working. Can´t the update do this or just do not log me off?
1 vote -
Modify Code Analysis to show able definition instead of blocking it
When I have Code Analysis enabled the mouse over shows the Code Analysis finding if there is something that isn't breaking a rule. However, this also makes it so that I can't see the normal mouseover behavior of an object. The only way I can see the object definition that would normally show up is if I disable Code Analysis. The only way I can do this by going in and temporarily disabling Code Analysis. Is there some way to make this more intuitive? Maybe if there is a Code Analysis finding you could show the code analysis finding and…
1 vote -
sub
I would like to be able to check a box and always indent a sub-query.
currently formatting a query works like this:
SELECT *
FROM dbo.tbl1 AS a
INNER JOIN(SELECT ID FROM dbo.tbl2 WHERE value = 'y') AS b ON a.id = b.idwhen the paren is set to inline the open paren and indent the content with the indent parentheses contents checked. I would rather have a checkbox to force the sub-query to format like this:
SELECT *
FROM dbo.tbl1 AS a
INNER JOIN (
SELECT ID
FROM dbo.tbl2
WHERE value = 'y'
) AS b ON a.id =…1 vote -
Allow indentation similar to nested JOIN when they are not written as nested
A nested join is indented additionally relative to the join that it is nested within:
SELECT *
FROM Person.Address
--INNER JOIN Person.StateProvince
----INNER JOIN Sales.SalesTerritory
------ON SalesTerritory.TerritoryID = StateProvince.TerritoryID
----ON StateProvince.StateProvinceID = Address.StateProvinceIDWhen joining the same tables but not writing them in a nested manner, there is no additional indentation:
SELECT *
FROM Person.Address
--INNER JOIN Person.StateProvince
----ON StateProvince.StateProvinceID = Address.StateProvinceID
--INNER JOIN Sales.SalesTerritory
----ON SalesTerritory.TerritoryID = StateProvince.TerritoryIDIt would be nice to allow the same amount of indentation that would be used if the join were nested to be used when it is not nested:
SELECT *
FROM…1 vote -
Separate VALUES style by first/subsequent
It would be nice to have an option to specify different styles when there is one set of VALUES compared to multiple. For example, I would like to use "Compact, indented) when there are multiple sets of VALUES:
INSERT INTO Employees
( id
, FirstName
, LastName
, BirthDate )
VALUES
( 2
, 'Jane'
, 'Doe'
, GETDATE())
, ( 3
, 'Frederico'
, 'James'
, GETDATE());But compact when there is only one set of VALUES:
INSERT INTO Employees
( id
, FirstName
, LastName
, BirthDate )
VALUES
( 2
, 'Jane'
, 'Doe'
, GETDATE())1 vote -
Place empty lines between BEGIN/END and their contents
The Whitespace > "Empty lines between statements" option doesn't appear to consider BEGIN/END as separate statements from the code between them, resulting in formatting like:
WHILE @@ROWCOUNT > 20
BEGIN
IF @BusinessEntityID > 0
DELETE FROM HumanResources.Employee_Temporal
WHERE BusinessEntityID = @BusinessEntityID;
ELSE
BREAK;IF @OldId < 2000
RETURN @OldId;
END;Please modify the behavior or provide another option such that the following result can be achieved:
WHILE @@ROWCOUNT > 20
BEGINIF @BusinessEntityID > 0
DELETE FROM HumanResources.Employee_Temporal
WHERE BusinessEntityID = @BusinessEntityID;
ELSE
BREAK;IF @OldId < 2000
RETURN @OldId;END;
1 vote -
Align tables within FROM clause
Currently, I can get SQL Prompt to format my SQL like this.
SELECT
tbl.name AS TableName,
col.name AS ColumnName
FROM
sys.tables AS tbl
INNER JOIN
sys.columns AS col
ON
tbl.objectid = col.objectidThis annoys me because the tables in the FROM statement are not aligned. I would like to be able to achieve something like below where the tables are aligned and the join and ON are indented from the table. So the tables are indented from the FROM and the INNER JOIN is indented from the table. Then, the ON can either be indented from table or…
1 vote -
Make Import / Export of options more flexible (xml file format or enable partial export of sections)
I would like to be able to export (+import) only specific portions of the options.
So that I - for instance - may only distribute my aliases or my coding style options to the team; not everything. The current binary format for the export file only allows for an all-or-nothing approach.
So please
(A) Make the export file a xml-format, so we can filter it ourselves
or
(B) Add a dialog to allow us to mark the sections to be included into the export file via checkboxesThis would also likely solve other feature-requests:
- https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/46784125-export-snippets-to-text-file
- https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/40966285-sql-prompt-setting-sharing
- https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/39174019-import-and-export-aliases1 vote -
Format SQL & Entity Framework — making EF SQL easily readable
I have the misfortune of trying to read an EF query. It would be extremely helpful if the «Format SQL» function in SQL Prompt could greatly reduce the verbosity and make the massively nested queries much, much easier to read.
This is what I am doing by hand:
• Replacing names like 'Extent6' with letters of the alphabet. I will go back later and replace these letters with more helpful names. Because the aliases of the table-valued objects are so long, so is there so much more text to plough through;
• Removing aliases from columns whose names are identical.…
1 vote -
When setting tab colors, allow/disallow the status bar to mirror the tab color
I am color-blind and while tab coloring isn't as big an issue, the real estate of the status bar and font size makes certain color schemes that I use on tabs VERY difficult to read. I would love an option to select whether the tab color propagates to the status bar and possibly even separately set a different "default" color for the status bar. I know some have requested the status bar mirror the tab color but some of us color-challenged developers would rather not have that option. Note, the "default" color could be consistent across all environments rather than…
1 vote -
IntelliSense for $partition.<partition_functions>
I would like the Prompt to be able to list any partition function found in the current context (DB)
like when i write: $partition.<Intellisense here>1 vote -
save /copy result grid as html table
SQL Complete has a great feature to allow copying the result as html table. I wish this feature was available in RedGate. This is the feature I would use multiple times every day.
1 vote -
"Open in Excel" feature should use the default Excel template
In the "Open in Excel" feature, I'd like the resulting Excel workbook to auto-open using the default Books.xlst template file locatedi in the %AppData%\Roaming\Microsoft\Excel\XLSTART folder.
1 vote
- Don't see your idea?