309 results found
-
Snippets - Add Predefined Literals for Date Parts
I would like to be able to use a different format for the DATE predefined literals than YYYY-MM-DD. It would be helpful to include one for YYYYMMDD ... or have literals for YEAR, MONTH, and DAY so I could create my own combination from them.
4 votes -
New Query Template
It can possibly be done with the 'snippet', but when I hit Ctrl- N in SSMS, it would be great if 'my' standard template opened. This allows me have the necessary 'set' options pre configured etc
4 votes -
multiple row tab
Provide for MULTIPLE TAB ROWS like TabsStudio has. This way there's no need for the file menu drop-down list, no need to manually pin tabs, the tabs keep stable order.
Thanks
4 votes -
Saved Filters in SSMS
Within SSMS, allow for the saving of filters.
Justification:
Particularly within large databases, often there is a reoccurring need to work with just a subset of tables. Sometimes, within different contexts, the particular subset changes. Being able to easily apply commonly used filters can allow increased productivity by eliminating frictional work (e.g. scrolling and hunting). Additionally, when filters across object types can be applied, there can be a lot of power. For example, being able to filter a particular set of SQL Agent Jobs, associated tables, and procedures related to those jobs, allows a troubleshooting developer to quickly set into…4 votes -
Improve standard filtering in Object Explorer
The standard filtering in Management Studio Object Explorer is rudimentary at best. I lack the ability to select multiple values, and use drop downs to do so. Or even better, use complex queries (with and/or/not), and maybe even save and reuse these for daily administration (much like snippets).
4 votes -
Row_number() formatting issue
Formatting for rownumber() seems to have issues with breaking up the line. I don't know if the parser is evaluating it as a possible subquery, but it would be great to have the option for a single line or wrapped line rownumber(). A row_number() statement on 4-5 lines seems to be a little confusing.
3 votes
AdminDevart
(_, Devart)
responded
Could you please provide us a concrete example demonstrating this and describe it in more detail?
-
auto alias with full table name or allow rename for non-aliased names
This will interface beautifully with the rename option that is included with SQL complete. Frequently i'll copy code sets that use two different objects or start as table reads and later become a read from a temp table. being table to change the "from" and easily being able to the rename the alias/table to the new source and have all other references to it be updated as well would be great
3 votesAdminDevart
(_, Devart)
responded
Could you please provide us an example of this?
You can send the reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .
-
Installer - Allow option to keep edits I've made to default snippets
When installing an upgrade, my additions to the snippets manager are maintained. However, I would like the option to keep all edits I've made to the default set of snippets as well.
3 votes
AdminPMs
(Admin, Devart)
responded
We just checked and confirm that changes made in the snippets are preserved when upgrading dbForge.
-
Option to reorganize FROM clause so that inner join and left join stay the same, and right join changes to left join
the original sql statment:
SELECT *
FROM T1 RIGHT JOIN T2 ON T1.ID1=T2.ID1after reorganize
SELECT *
FROM T2 LEFT JOIN T1 ON T2.ID1=T1.ID13 votes -
Mark cells in results panel
I want to be able to mark cells in the results panel. I often have SSMS open on one screen, and some spreadsheet or notepad open on another. I can select the cells, but then that selection is no longer visible once I go to the other window. I should be able to change the background color or a cell in the results pane by right clicking, and/or keyboard command.
3 votes -
collapse blocks to definitions
hi, I work with MS SQL Managemenet System and a lot of *.sql files for updating databases
to my specific file can have a lot of lines of code (up to 1000 lines) and navigation and reading becomes tragic - I always manually collapse (press on [-] next to block name) all blocks like CREATE PROCEDURE, CREATE FUNCTION
I really love your SQL Document Outline feature
so you can handle another feature 'Collapse all blocks to definition' and simplify the life of a lot of db coders
Will be glad to be among your clients
Thank you and good luck,…3 votes -
Add bookmarks feature
This feature will allow set or clear bookmark on a line of SQL code, and allow move to successive bookmarked lines. as in Textpad (Ctrl + F2) and (Shift + F2).
3 votes -
Show list of procedures on typing procedure name even with no EXEC
Show the list of available procedures when start typing a procedure name, for example:
sp_proc1
3 votes -
Stop autocomplete of table name if you haven't specified the table name yet
For example, when I attempt to write out this query:
SELECT t.Column1 FROM dbo.Table1 t
As soon as I type "SELECT t." the "t" turns into whatever object name matches t the closest (in my database's case, it's some random UDF). I want to write "t.Column1" before I've specified what t is.
3 votes -
trailing spaces
Option for removing trailing spaces
3 votes -
Option to add a space after table alias.
To prevent a snippet from getting inserted when the alias is the same as a snippet. Many times I will start a query and an alias is the same as the snippet. When i hit tab or enter that snippet in inserted in place of the alias. This is especially true when you have SSMS Tools installed and many of the snippets from it are one letter (s for select, e for execute and so on)
3 votes -
Double-clicking a snippet in the Snippet Manager Must Insert it into the SSMS editor
It must be also possible to insert a snippet into the currently open editor window by just double-clicking it in the Snippet Editor (left pane)
3 votes -
Extended Outline - Highlight outline which is marked by cursor
Click in Document Outline window on some outline shows code line in sql file. But it would be nice to highlight encapsulated outline after clicking in sql code file on some code line. Therefore the position in navigation tree will be clear everytime.
3 votes -
Paragraph between SELECT FROM WHERE etc.
Option to have a paragraph, not just a break, between elements of the statements:
SELECT field1
FROM table
WHERE field1 IS NOT NULL;
3 votes -
Option to add parenthesis into ON clause
Current formatting:
ON e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid
Expected:
ON (e.ModifiedDate = a.ModifiedDate AND e.rowguid = a.rowguid)
3 votes
- Don't see your idea?