681 results found
-
Surround highlighted text with
Surround highlighted text with 'thing' instead of replacing it. Like in azure data studio or visual studio, pressing "(" will surround the highlighted text instead of replacing it. I have created surround snippets to surround the highlighted text with what I want; it's just not as good to use.
5 votes -
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 -
Intellisense for system stored procedure parameter values
For system stored procedures, some parameters have a predefined set of possible values, e.g.
msdb.dbo.sp_add_jobstephas the parameter@on_success_action.The MS documentation lists this predefined list of possible values:
1 (Default) Quit with success
2 Quit with failure
3 Go to next step
4 Go to step@on_success_step_idIt would be great if Intellisense could suggest values for these sorts of parameters, saving a trip to Microsoft's website.
3 votes -
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 -
open excel with different account
Configure a different account than the one opening SSMS to open Excel for results. We use an Admin account for DBA work separate from our Windows account.
4 votes -
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 -
Option to display values within IN statements without spaces between them
Another white space removal feature to suggest.
The ability to format all IN statements as:
empType IN ('a','b','c','d')Rather than the default:
empType IN ('a', 'b', 'c', 'd')I have done some exploring in the formatting styles and scouring the forums here and this feature doesn't seem to be available.
2 votes -
CTE on new line with commas before items is adding an extra line
When using the Lists > "Place commas before items" combined with the CTE >" Place CTE name on a new line" options, the subsequent CTEs are getting placed on new lines after the comma is already on a new line, resulting in:
WITH
myCte
AS ( SELECT 1 a )
,
mySecondCte
( Col1, Col2 )
AS ( SELECT
'Test' AS ThisIsAColumn
, 'Test2' AS ThisIsAnotherColumn
FROM Person.BusinessEntityContact )
SELECT *
FROM myCteI believe this combination of settings should be resulting in:
WITH
myCte
AS ( SELECT 1 a )
, mySecondCte
( Col1, Col2 )
AS ( SELECT…3 votes -
Formatting style for CASE statement: on a new line
Add a feature for the formatting styles for CASE expression.
Currently the formatting is so strange, it adds indents that don't make sense.
It should have the possibility to add CASE on a completely new line.Please add :Start expression on a new line or something…
3 votes -
Sql prompt support for Dedicated SQL pool
Add support for Dedicated SQL pool on Azure Synapse.
4 votes -
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 -
Add system versioned table scripting
Add system versioned table scripting
3 votes -
SQL Prompt - More Granular Suggestion. WHERE AND / CASE AND
SQL Prompt - More Granular Suggestion. WHERE AND / CASE AND
Would you add a couple of settings that give users more granular control in formatting SQL Prompt, please?
In the CASE section, please add a section on how to handle Case AND statements, if we want the AND on a new line or the same line, and where to Align the AND.
Also, please add a checkbox to align any '=' signs, like CASE WHEN colA = 1 then 1 else. I'd like all = signs to line up when there are multiple WHEN statements.
Also, Please add a…
3 votes -
One feature idea that I think would be great for many customers. Often I have a pasted column of data from Excel that i need to run a macro
One feature idea that I think would be great for many customers. Often I have a pasted column of data from Excel that i need to run a macro on in Notepad++ to add single quotes and commas. So that I can paste the string into a SQL “in ( ) " clause.
It would be amazing if SQL Prompt had an option to convert that clipboard text right in SSMS. I think lots of people would find that a timesaver.
2 votes -
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 -
Close pop up windows when holding down the control key while editing sql in SSMS
While editing code in SSMS, i often find I want to use control key navigation (ctrl - left arrow for example) to navigate to a different part of the text i'm editing, but a pop-up intellisense window has arrived and instead of moving to the start of the word i'm editing, its trying to make me choose things from its pop up. It would be nice if ctrl key navigation would auto close the intellisense window so I could continue moving around the text of my query instead of having to hit escape all the time to close the pop…
2 votes
- Don't see your idea?