674 results found
-
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 -
Post execution
Automate a task after a query execution.
Like, after execute a long query, send-me a email, or if the query run from a long time do something or start a job, another query, kill the original query.
Be able to enable this trigger after start a query will be nice too.1 vote -
RedGate In Clause
When redgate is writing the "in clause" for us based on selected cells it would be nice if it also put the column name in the clipboard when all fields selected are from the same column,
1 vote -
COPY AS ALTER BUTTON
Hello,
So I love the suggestion feature where I'm able to type in an object and the code appears to copy. Home run with this feature I can't thank you enough for it.
I was wondering if it would be possible to expand on it though.
Here is a sample. I'm looking to alter an object, let's say a stored proc...
I usually begin by typing EXEC <name> to trigger the suggestion for stored procs to give me the object.Once the suggestion finds the object, the script contents appears in a side window.
Using the COPY button in the…
1 vote -
Paste copied table rows as seperate entities for snippets
I would like the ability to copy a set of items then treat them as separate items for formatting purposes. For example, say I grabbed these values from a results table.
'A'
'B'
'C'I would want to be able to paste them with the formatting I'd use for an insert, so they would look like this:
('A'),
('B'),
('C'),As it works right now though, copying and using the $PASTE$ placeholder will generate this.
'($PASTE$)',
'(A
B
C)',1 vote -
Add context menu shortcuts to SQL Prompt context menu entries
I want to be able to quickly switch between active styles.
I'm informed that the solution to this was to add the Active Styles section of the context menu, to allow quick access to the active styles.
That's fine as far as it goes, but that entry is very far down the menu and is only quickly accessible by mouse.I would like to suggest having the "Active Styles" entry changed to "&Active Styles" so that the A becomes a shortcut in the context menu; and to have each of the styles listed as &1, &2, &3 etc. in the…
1 vote -
Run Script at Cursor
Run Script at Cursor just Oracle SQL Developer with F5 or Alt+X. Please implement this very helpful functionality.
1 vote -
COLUMNPROPERTY
COLUMNPROPERTY (https://docs.microsoft.com/en-us/sql/t-sql/functions/columnproperty-transact-sql) is missing two suggested property values that were introduced along with System-Versioned tables in SQL Server 2016.
Please find the missing values below:
GeneratedAlwaysType
IsHidden1 vote -
add trigger definition to a triggers tab on object definition box
Currently, when hovering over table objects, and clicking on the table name mini popup, you get the object definition box, with a 'Script' and 'Summary' tab.
The 'Script' tab has the table and index creation scripts, and the 'Summary' tab lists the column definitions.
For tables with triggers, it would be nice to have a 'Triggers' tab that contains
any trigger scripts for the table.1 vote -
Provide support for "Suffixes to ignore" in "Insert code > Aliasing" options
We use a data warehousing strategy that creates potentially dozens of tables for multi-class entities in the data warehouse, so we have many tables that end in "core". This leads SQL Prompt to alias the object with a final "C" that we then remove manually. For example, our InstanceCore and Database_Core tables are aliased to "IC" and "DC" when we would prefer "I" and "D" respectively.
Can SQL Prompt's Aliasing capabilities be extended to support "Suffixes to ignore" just like the existing "Prefixes to ignore"?
1 vote -
Improve Autocomple
After Update to 10.0.
When you for example press J for join and confirm this input with Tab, it wont add a Space. You have to add this space manually :(
maybe it is possible to add automatily always the space1 vote -
Move caret within python_case_identifiers similar to CamelCase
Similar to the movement of caret within CamelCase, could you please enable such behavior for pythoncaseidentifiers? I'd like the caret to stop in these places when using CTRL+<right or left arrow>: (1)python(2)case(3)identifier. Would that be possible, please?
1 vote -
Only load suggestion for fresh new databases
Do you think it's possible to only have the refresh of suggestions the first time a database is loaded (so skip refresh if the cache already exists, but let the possibility to manually refresh cache for this db with the contextual menu of course)
We have hundred of databases (with thousands of view and sp) and sql prompt try to refresh all the time the same databases (for example when we restart Management Studio) and nothing never change in these databases ...
So we would like to load schema automatically only the very first time and then on demand.
Thanks
1 vote -
Add "duplicate a line" feature similar to Resharper's Ctrl+L.
When cursor is placed on any line simple shortcut would insert exactly same line below and move cursor to the newly inserted. No prior selection of any kind necessary.
1 vote -
1 vote
-
PE006 is Too Noisy for Temp table Parallel INSERT
We use the WITH (TABLOCK) hint extensively for loading temp tables - see https://www.sqlshack.com/use-parallel-insert-sql-server-2016-improve-query-performance/
PE006 is far too picky - it yells at every such statement in our high-volume hybrid solution. It would be good to "silence" this kind of rule-breakage so we can see any REAL violations on persisted tables.
Please augment to utterly ignore temp tables.
1 vote -
remove table names (that are not in any joins) from where clause suggestions, or at least deprioritize it.
It keeps suggesting table names dbo.Something when writing the where clause even if the table is not in any join clauses. This is a pain as I keep selecting the table instead of the column if the names are similar.
1 vote -
Apply SQL Prompt Styles with Code
I'd like a NuGet lib to be able to apply SQL Prompt styles to a folder of .sql files or a StreamReader string. I have a console app I'm using to produce a lot of Sql Files and I'd like to create a "everything on one-line" style that I use internally when processing things. There could be tons of other uses as well.
1 vote
- Don't see your idea?