639 results found
-
Temporarily Elevate Exact Matches Over Recently Used Suggestions
I like the new feature to put recently-selected items at the top of the list for Intellisense. However, when I have typed an exact match, I would like to see Intellisense elevate that exact object to the top of the list.
For example, suppose I have recently selected a table named "dbo.OrderDetail", and suppose that there is another table in the same database called dbo.Order. With the new feature, I cannot access "dbo.Order" as the top candidate, because it is a partial match of "dbo.OrderDetail," and so SQLPrompt puts that name at the top.
In a nutshell, I would like…
6 votes -
Multiple format options for insert statements
Currently SQL Prompt only has one option for formatting insert statements which poses a problem for us with multi value set inserts.
Ideally we'd be able to select a formatting for a single value set insert and another format for a multi value set insert.
This would allow us to do something like this:
-- Single Value Set Insert
INSERT INTO TestTable (TestName,
~~~~TestValue,
~~~~TestDate)
VALUES (N'Something',
~~~~140,
~~~~'1/1/2019')-- Multi Value Set Insert
INSERT INTO TestTable (TestName, TestValue, TestDate)
VALUES (N'Something', 140, '1/1/1900'),
~~~~(N'SomethingElse', 150, '1/2/1900'),
~~~~(N'SomethingElse2', 160, '1/2/2000')The issue for us is that we have need of…
10 votes -
Option For Aliases (Only For Custon Alias)
Hi
it is better to SQL prompt use only aliases define with user.need option in Aliases : Only For Custom Aliases
Sorry For My Bad English
3 votes -
Show synonym script on F12
I would like to see the Script Object as Alter (F12) feature to work with synonyms. However, I am aware that a synonym cannot be altered - instead I suggest to generate a script containing a DROP and a CREATE statement.
That way one could bring up the code of the referenced object by selecting the synonym, pressing F12, selecting the referenced object and pressing F12 again.
3 votes -
Copy as WHERE clause
It would be useful to be able to copy a selection from the results grid which is pre-formatted as a WHERE clause in the same way "Copy as clause" IN works, e.g. copying a single value from ProductID column would produce WHERE ProductID = 5 and copying multiple values would produce WHERE ProductID in ( 5, 10, 15 ).
4 votes -
flip between adding and removing square brackets
Add ability to add or remove square brackets without having to edit the settings for which direction you want it to go.
4 votes -
Send to Tab History
I would like a hot key combination to send the contents of my current tab to 'Tab History' without having to close the tab. There are times that I know I will need the contents of the tab in the near future (within a few hours/days) and I don't want to have to save a hard copy to my disk.
6 votes -
Alias on Synonym Name
Have auto alias base its output on the alias name instead of the name of the table it is pointing to.
Example: Alias "Transaction" pointing to "TransactionTableWithComplexName" should be "t" and not "ttwcn".
1 vote -
Writing text within quotes
When typing a string of text within a quote, do not replace my text with objects from the database.
3 votes -
Automatically add DROP TABLE IF EXISTS for #temp tables
It would be nice if SQL Prompt had a way to add in the code DROP TABLE IF EXISTS #table for temp tables. Ideally it would add the statement immediately before the table is created from a CREATE TABLE or SELECT INTO statement.
11 votes -
Automatically add Schema to tables when formatting.
Provide the option to enable automatic schema addition when necessary. And when there may be more than one candidate schema, provide a warning
5 votes -
Insert Default Values should include default values defined on the table.
For example, if a table is defined as such :
CREATE TABLE dbo.T1 (
col1 INT DEFAULT 100,
col2 VARCHAR(100) DEFAULT 'Example',
col3 DATETIME DEFAULT '01/01/2019'
)And use auto-complete to generate and INSERT, it will produce :
INSERT INTO dbo.T1( col1, col2, col3 )
VALUES( 0 -- col1 - int
,'' -- col2 - varchar(100)
,GETDATE() -- col3 - datetime
)Instead, it would be nice to have it produce the insert with the defined table default's, something like :
INSERT INTO dbo.T1( col1, col2, col3 )
VALUES( 100 -- col1 - int
,'Example' -- col2 - varchar(100)
,'01/01/2019…5 votes -
with check check
The constraint name is not suggested when using the syntax
"ALTER TABLE <TableName> WITH CHECK CHECK CONSTRAINT <ConstraintName>The suggestion feature works great when using NOCHECK CONSTRAINT
1 vote -
Display intellisense for view columns from underlying base tables
When working with views, you lose the intellisense for columns. It would be nice if SQL Prompt could get the MS_Description value for the view column from the underlying base table for the view.
3 votes -
When typing between tics ' Intellisense is not needed.
at some point i noticed it started recommending suggestions when typing between ''. this should be a literal string with no suggestions required
2 votes -
Correct Inaccurate suggestions for auto complete of column name
Intellisense brings up 'd', CREATE SQL Server login, to top of suggestions when referencing a column beginning with 'cl'.
Specifically, I see this in the where criteria. Have no clue why it would even bring up a 'CREATE SQL Server login' snippet in the context of a WHERE; especially when the autocomplete is coming from the dot to an alias of the table.1 vote -
Parentheses
New Parentheses Style - #6 but ends like #1
Numbering starting at the top left as #1 and continuing to the right one as #5. With the next line starting as #6 and finishing on the right of line 2 as #9.
In the global parentheses settings, Lets make a #10 option which works like #6 in all ways except the closing parentheses is aligned with the beginning parentheses like it does on #1. Actually looking at the graphic that shows on #1, this looks like what I want, the trailing parentheses is below the first one, but #1 has…1 vote -
Add Remove Comments to Context Menu
I love the 'Remove Comments' feature, however it takes too many clicks to implement. Please add it to the context menu.
1 vote -
Highlight difference between selected rows
Time to time you need to compare data in the rows, for example when looking for the cause of duplication. If the query is complex enough with joins and wide tables I usually run
SELECT * FROM ...
and check where the duplication begins to easily find the root cause. The easiest way for me to do so is to copy it into the excel and do some simple formula to find the exact columns that have difference.
It would be nice if SQL Prompt would support that feature. If it's possible then it can be done by highlighting needed…
2 votes -
Add one additional Parenthesis style
My Teams would prefer this option:
xxxxxxxxxxxxxx (
xxxxxxx,
xxxxxxx )Opening parenthesis on the first line, and closing parenthesis on the last line.
Second and following lines indented one stop. This display seems to strip out the leading spaces.
3 votes
- Don't see your idea?