674 results found
-
Tab History Cloud Sync
Option to sync/store tab history in the cloud, network share, or online share (aka One drive, Google drive, dropbox, etc.) That way you don't loose your history when you upgrade or change your computer and have to start all over again. It would also be nice to be able to sync between multiple computers.
40 votes -
Align equals sign in UPDATE
Provide an option in Styles to let the right hand side of clauses in UPDATE statement be aligned.
Example:
UPDATE~~EDSV
SET~~~~~eDocSessionID~~~~~~~~~~~~~~~~~~~~~=~CONSV.eDocSessionID~,
~~~~~~~~eDocSessionKey~~~~~~~~~~~~~~~~~~~~=~CONSV.eDocSessionKey~,
~~~~~~~~eDocSessionValue~~~~~~~~~~~~~~~~~~=~CONSV.eDocSessionValue~,
~~~~~~~~eDocSessionValueTextStyleOverride~=~CONSV.eDocSessionValueTextStyleOverride~,
~~~~~~~~eDocSessionValuePositionOverride~~=~CONSV.eDocSessionValuePositionOverride~,
~~~~~~~~eDocSessionValueLockdown~~~~~~~~~~=~''
FROM~~~~eDocStd2.dbo.eDocSessionValues~AS~EDSV
~~~~~~~~INNER~JOIN~#changedOrNewSessionValues~AS~CONSV~ON~CONSV.eDocSessionID~=~EDSV.eDocSessionID
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~AND~CONSV.eDocSessionKey~=~EDSV.eDocSessionKey;44 votes -
Align ON in JOIN Statements
I really like the latest formatting flavours. Aligning the equivalency symbols in joins is nice, but could I also align the ON keyword? Or pick which one I want to align on.
SELECT *
FROM table1 a
JOIN Table2 b__ON a.foo = b.foo
JOIN Tab3 c___ ON b.fa__= c.fa24 votes -
Trimming trailing spaces in comments
It would be cool if SQL Prompt was able to remove trailing whitespaces/tabs not only for T-SQL, but also for comments.
It's not something crucial, but rather nice-to-have
3 votes -
Format dynamic SQL
We use a lot of dynamic SQL. I'd like to be able to format dynamic SQL that is in a string, eg. and NVARCHAR. e.g.
Input: DECLARE @sql NVARCHAR = '
SELECT foo from bar where foobar = ''foobarred''
'I'd like to be able to highlight the text inside the NVARCHAR for formatting. SQL Prompt would need to handle doubled quotation marks as in my example above.
19 votes -
INSERT INTO Wildcard
When doing an INSERT INTO it would be nice if you could type INSERT INTO TableName (*) then if you tabbed after the * it would expand out all the columns for that table.
9 votes -
Create new Setting to only enclose SQL Keywords in square brackets
I don't want to use brackets for my code (unless I have to). So, for example, dbo.Orders is fine, but dbo.Order isn't. It would be nice if SQL prompt caught this and automatically enclosed the SQL Keyword "Order" in square brackets (i.e. dbo.[Order] AS o)
54 votes -
Format CTE closing parenthesis
It would be nice to have an option under Formatting Style -> CTE to allow closing parenthesis behavior, just like the opening parenthesis one:
- Place closing parenthesis on new line
- Closing parenthesis alignment14 votes -
Empty Line Before and After Multi-Line Statements
Complex multi-line statements are much easier to read when separated by an empty line above and below them. Please add an option to turn on "Empty Line Above/Below Multi-Line Statements".
5 votes -
Align "then"
Please add an option to align "then" keyword and the expressions.
Current format:
declare@fooidint=(case
_______________________when@barId=7then2
_____________________when@barId=800then1
_____________________else5
_________________end
__________________);Suggested format:
declare@fooidint=(case
_______________________when@barId=7then2
____________________when@barId=800_then1
_____________________else________________5
________________end
__________________);14 votes -
grid aggregates
Results Grid aggregates
SUM, AVG, MIN, MAX and COUNT aggregates are shown
for selected range of cells in Results Grid open a new window with this reslults22 votes -
Detect the database compatibility version
When using SQL server 2016 with a database that has it's compatibility level set to 2012, I'm still being offered auto complete options for 2016 features. e.g. string_split
SQL Prompt needs to detect the database compatibility level and adjust it's intellisense accordingly.
3 votes -
Tab History - sort or filter on evironment
Allow me sort or filter the tab history list based on the environments that I have defined.
6 votes -
Match Visual Studio Themes
Visual Studio supports a Dark theme however Prompt doesn't match and still displays the standard white for suggestions.
21 votes -
Export all results to Excel, not just a single table
It would be awesome if the Results tab could be right-clicked (when results are in a grid), and then have an option to export all tables to Excel, with each table being in a new tab. Currently I can only export one table of results at a time to Excel, and if I need to do multiple tables then multiple sheets are opened.
25 votes -
Comment Word Wrap
Hi!
I would be nice to have the option to enable word wrap for the comments as well.
The number of maximum characters for the comment should be aligned with "Wrap lines longer than" for SQL statements.19 votes -
Outline for scripts
It would be very helpful if there was an outline for the script being edited. Say, a script has many "CREATE PROC"s. We could have a tree or a list or a drop-down, to view a list of CREATE PROCs and click to scroll to the section.
If a tree style is selected, this could be expanded into seconds inside each PROCs.
3 votes -
export to excel options
Hi - export to excel is a great feature. if it could be extended in 2 ways it would be even better.
copy the sql used to produce the results (and date, server info) into a separate tab called 'sql' or something. this way data extracts will be 'auditable' and re-runnable.
have some export options (top row = bold, highlighted, freeze top row). column autowidths applied.
the second one can be done with a macro in the excel template but would be a nice to have.
13 votes -
Discover metadata for OPENQUERY
When I use the OPENQUERY syntax to retrieve data across servers, SQL Prompt does not discover the metadata (column names, data types, etc.) of the fields returned.
My suggestion is that you add support within SQL Prompt to make metadata for fields retrieved by OPENQUERY available just like you do for linked servers.
7 votes -
Multiple rows of tabs
If I have more open tabs than can horizontally fit the window SSMS does not show all of them but instead there is a dropdown in the right upper corner. I would prefer if I could have multiple rows of tabs instead, like in VS. Since it does not seem likely that MS is going to implement that soon, can it be done in SQL prompt?
33 votes
- Don't see your idea?